October 28, 2011 at 8:34 am
I have had a weird experience that I have not answered yet.
I made a ssis project and added an existing package to it. After that I tried to change the flat file connections on the package I added(lets call it bob).
When I save the changes, to the flat file connection settings, I made on Bob and look at the connection setting after the save everything is blank like it never changed. Does anyone know why this might be?
The quick solution so far has been to delete and remake the connections overall but I don't like that fix. It doesn't answer the original question. I am google engineering this problem to try and find answers but I thought I would try to get the answer from here as well.
November 1, 2011 at 8:10 am
make sure that no expressions are assigned to the flat file connection manager as that will make the path of the file read the at runtime, thus at design time you will not be able to see a default path pointing to the file.
November 1, 2011 at 1:38 pm
Make sure the package is not using PACKAGE CONFIGURATIONS and reading the connection string out of that.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply