June 17, 2009 at 11:01 am
Hi All,
i am unable to save any added objects in the data flow tab. i have tried adding a flat file source and an OLE Db source and when i save the dtsx file and exit and open back the file, the flat file source and the OLE Db source are both missing. Not sure how this happens. i have checked the dtsx file and it is not being used or referenced by any other process.
i even tried and renamed the dtsx file. when i open the new dtsx file and make changes (add objects), they do go missing.
any help is much appreciated. this is an urgent request...
thanks
JD
June 17, 2009 at 3:23 pm
This same issue drove me insane a few weeks ago. Your package is probably using config files for the Connection Managers. I had to find the config files on my PC and edit them manually. A more experienced person(I'm still learning SSIS.) might tell us where we can set an option so it will automatically save changes to the config file when we edit a connection manager.
I found my config files in folder named 'config' in the same vicinity of the 'packages' and 'log' folders for my package.
The config folder is useful. I have setup up Live and Test environment connections in separate config folders to switch out as needed. There are probably lots of ways to achieve this as well.
Good luck.
June 17, 2009 at 3:36 pm
More info - In the Visual Studio 2005 BI Development Studio environment, there is a menu item SSIS\Package Configurations. This shows you where the config files are. There is a checkbox to not use them, but I have not tried that. It has been my experience that you often get unintended results when you start changing settings without doing a little research first.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply