Editing a saved SQL SSIS (.dtx) package
Posted on 2009-07-08
I have set up a pretty long-winded SSIS package in SQL Server to import some data from a flat file in to a SQL table. I saved the SSIS in the file system and have the .dtx file, which enables me to run it whenever necessary. However, one of the parameters in the package needs to be amended - it's a database name in a connection string that needs altering. I can open the .dtx file with the Execute utility and can apparently edit the destination connection under the Connection Managers menu. Unfortunately this doesn't seem to take effect - and when I close the utility, the change isn't saved.
Is there a way I can edit this saved SSIS package - to avoid me needing to go through the entire process of creating a new one, just for the sake of one tiny amendment?