I have created a SSIS package for loading data from flat file to sql table. I am using the xml configuration file for storing the location of the flat file. Following the package configuration wizard for this purpose. Since I want to be able to change the source flat file location when we move to production environment, under properties to export in the package configuration wizard: I selected the ConnectionString Property which is under Connection managers\Flatfile Please let me know if the ConnectionString Property is one to go with for my purpose. Thanks.sqldev

Yes, the connection string property is the correct one. You should be able to edit it in the XML config file to change the location.John Welch | www.varigence.com | www.agilebi.com | ssisUnit.codeplex.com

My practice is to divide my configuration MXL files into 4 main categories 1. SSIS-XmlDestinationDBConfig-YourETLName.dtsConfig 2. SSIS-XmlFolderConfig-YourETLName.dtsConfig 3. SSIS-XmlMailConfig-YourETLName.dtsConfig 4. SSIS-XmlSourceDBConfig-YourETLName.dtsConfig Ø SSIS-XmlDestinationDBConfig-YourETLName.dtsConfig Usually the destination is SQL in my case so, I have the § Server name Or IP § DBname § Destination Table Name § Destination Error Table Name Ø SSIS-XmlFolderConfig-YourETLName.dtsConfig I keep the folder names like § BackUpFolder § Log Folder § DeploymentLog Folder § Job Logs § Main root of the ETL Ø SSIS-XmlMailConfig-YourETLName.dtsConfig Email information § The TO list of Emails § SMTP IP § Subject of the ETL ..... Ø SSIS-XmlSourceDBConfig-YourETLName.dtsConfig In this case I am giving you a excel source file example § The connection string § Etc... And I pass all of the mentioned XML config files to the package when I am running the package. Sincerely SH --MCTS 2005 & 2008 MCITP 2008 -- Please kindly mark the post(s) that answered your question and/or vote for the post(s)

In order to change the source flat file location when we move the SSIS to production environment, all we need to do is change the SSIS.DTSCONFIG XML file to update the C:\SSIS\Sourcefile.txt to \\Prod\SSIS\Sourcefile.txt correct? <Configuration ConfiguredType="Property" Path="\Package.Connections[FlatFile].Properties[ConnectionString]" ValueType="String"> <ConfiguredValue>C:\SSIS\Sourcefile.txt</ConfiguredValue> </Configuration> I also have FlatFile connection manager, so do I also change the location of the flat file in the flatfile connection manager too? or if I update just the flatfile location in the configuration file is that enough? Thanks. sqldev

Please let me know. Thanks.sqldev

In order to change the source flat file location when we move the SSIS to production environment, all we need to do is change the SSIS.DTSCONFIG XML file to update the C:\SSIS\Sourcefile.txt to \\Prod\SSIS\Sourcefile.txt correct? <Configuration ConfiguredType="Property" Path="\Package.Connections[FlatFile].Properties[ConnectionString]" ValueType="String"> <ConfiguredValue>C:\SSIS\Sourcefile.txt</ConfiguredValue> </Configuration> I also have FlatFile connection manager, so do I also change the location of the flat file in the flatfile connection manager too? or if I update just the flatfile location in the configuration file is that enough? Thanks. sqldev Is this the same FlatFile connection manager whose ConnectionString property you are seeting in Config file if Yes then no need to update at run time package will pick up the value of ConnectionString defined in above config file .Cheers, Shailesh

Yes, you should be able to just change the value in the configuration file. Is that not working?John Welch | www.varigence.com | www.agilebi.com | ssisUnit.codeplex.com

There is now an utility available in CodePlex which can be used to batch update SSIS Package Configuration File paths without using BIDS: http://ssisconfigeditor.codeplex.com/