April 18, 2011 at 1:26 pm
From C#, i am calling SSIS Package. I have to fetch the connection string from C# Code which would be input paramters for executing the Package.
I have Script Task -> For each loop Container which in turn calls Data Flow Task !!! How should i pass Source and Destination Connection string to Data Flow Task ?
April 18, 2011 at 1:59 pm
chokka (4/18/2011)
From C#, i am calling SSIS Package. I have to fetch the connection string from C# Code which would be input paramters for executing the Package.I have Script Task -> For each loop Container which in turn calls Data Flow Task !!! How should i pass Source and Destination Connection string to Data Flow Task ?
Set them via variables and expressions, then when you call the DTEXEC exe, you can /set the variables at the time of the call.
Another option would include using configurations.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
April 18, 2011 at 2:36 pm
I have variables for SourceConn and DestinationConn. My issue is, i dont know the syntax for passing these values to the variables !!
April 18, 2011 at 2:44 pm
Thank you for the link ..! Your link doesn't carry solution for my comment !!! I am discussing about SSIS Package !!
April 18, 2011 at 2:47 pm
You're kidding, right?
Sentence 1 from the link:
The dtexec command prompt utility is used to configure and execute SQL Server Integration Services packages.
How were you going to run the package if not using dtexec?
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply