I'd like to pass a parameter value from a ASP.NET application to an SSIS package. My SSIS package pulls data from SQL and loads it a flat file based on the parameter value.
Is this possible?
Very much possible.
Check out the example @. http://www.codeproject.com/useritems/CallSSISFromCSharp.asp
More details on "Loading and Running a Package Programmatically " @. http://msdn2.microsoft.com/en-us/library/ms136090.aspx
Thanks,
Loonysan
No comments:
Post a Comment