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
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..
October 21st, 2010 1:40pm