I have a package that runs an individual task but when I compile the full package and run it in VS, I get a connection issue to the Server I'm pulling from.
The datasource is another SQL Server, both are 2005. It uses a specific username and password which I supply in the config file.
I'm thinking I need to set the Protection Level at the package level but I've tried most of the options and I get the same error.
Anyone have this issue before or know how to solve it?