Hi, I've got appr. 100 packages on a SQL server 2005 server, I need to edit them and import to the new SQL Server 2008 server. I used dtutil to import them to a directory. Is there any way I can add all files from this directory to a SSIS project without clicking 'Add project' 100 times. Thanks

you can create an empty ssis package, then go to project directory , and open projectName.dtproj file with notepad this is a file which contains information about packages in the project and other settings, you can find DTSPACKAGES tag there, you can add your packages all in this directory, and also under this tag, like: <DTSPackages> <DtsPackage FormatVersion="3"> <Name>Package1.dtsx</Name> <FullPath>Package1.dtsx</FullPath> <References /> </DtsPackage> ... </DTSPackages>http://www.rad.pasfu.com

Open the directory in Windows Exploder, Select All and Copy to your clipboard (control a, control C) Go to your VS project, right click SSIS Packages folder, select Paste.Michael R Milligan

Thank you for your replies. Is there any way to update Server Names in the Connection Managers for mutiple packages? I used Ole automation when migrated DTS packages between SQL servers 2005 - it does not seem to work any more.

I've got a package configuration on all these packages. Is there any way to add the ConnectionString property from outside the package to all these packages at once? Thanks

That's what configurations are for. Yes, you can alter the configuration file without opening the package to "push" in a new value for the connection string. BUT - only if the connection manager is named identically in ALL packages that you attempt to apply that configuration to. To do so, open one of the packages, and edit the configurations. Add the connection string to the configurations, and have SSIS create the XML file (I'm assuming you're using XML - if not, have it create in whatever format). Now you can alter the dtsConfig file to have the values you want, and apply that config to all the other packages at runtime. Talk to me now on

Or do that with a little scripting: http://microsoft-ssis.blogspot.com/2010/12/downloading-all-packages-from-your-sql.html

This is by far the easiest method I have found. I only wish I would have thought of trying this sooner.