November 30, 2011 at 9:21 am
personal
Imagine the scenario:
I created a *.dtsx in IS sending a file to an ftp "x".
If the configuration folder (reading and writing) to change, as well as the username and password, I have to open the *.dtsx, making this change in your *.dtsx?
There is possibility to make this change automatically, like, checking for changes in order to forget the *.dtsx related settings ...?
November 30, 2011 at 9:33 am
You could have those paths parameterized and then just pass the parameters to the execution of the dtsx.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 30, 2011 at 9:43 am
and how do the parameterization? in fact I know I can create the expression of connection, but as I do that?
add:
the idea is stored in SQL server and mount the expression
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply