Dynamic directory location for "Flat File Source"
Hi, I am using a "Flat File Source" to read from a source file. Now I want the directory location to be dynamic because it will change during migration from development to UAT to Production. Can anyone help me here on this. Ofcourse my intention is not to open and modify the package after migrating into a different environment. Actually I want to store the directory location in a table and want the "Flat File Source" to read the location form that table duing runtime. But not sure whether can I achieve this or not. If yes then how? Regards - Koushik
October 21st, 2010 10:03am

Create a variable and set the falt file connection manager's connection string property using this variable. Give a correct default value to the variable. Now add a package configuraiton and select this variable as configurable. Now change the value of this varibale and the flat file connection manager will connect to a different flat file.Nitesh Rai- Please mark the post as answered if it answers your question
Free Windows Admin Tool Kit Click here and download it now
October 21st, 2010 10:39am

Use package configuration as nitesh suggested you.. Please check this Rafael's blog on msdn for more understanding.,.. Let us TRY this | My Blog :: http://quest4gen.blogspot.com/
October 21st, 2010 11:21am

Have a look at my blog post "Dynamic file connection in SSIS using for each loop" on how to design a package for this need. Tweet me..
Free Windows Admin Tool Kit Click here and download it now
October 21st, 2010 1:40pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics