December 28, 2010 at 11:16 am
Hello all,
This is the weirdest thing that I just can't seem to figure out. I have a package which I am using package configurations with. The connection string configurations are stored in a SQL database (user name and password). From BIDS this runs great as well as if I deploy it to our test server from my development PC. I can go into SQL management studio to integration server ()from my dev PC), right click the package and it runs great, reading the configurations from the SQL table.
Now here's the weird part. If I remote into that same test server that I installed the package on from my development machine, go into sql mgmt studio to integration server and right click, execute package, it fails saying the username and/or password is incorrect. It's almost like configuration isn't being read when I remote to the test server. Reason I have this assumption is because I can look at the connection string in the SQL table and see that it is correct. In addition, the same package runs when I execute it from integration server on my development pc vs when I do the exact same by remoting into the test server.
Has anyone ever experienced this? Am I doing something wrong here? I'm using SSIS 2008.
Thanks,
Strick
December 29, 2010 at 12:15 pm
What is the protection level of your package?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 29, 2010 at 3:05 pm
Hi,
Not sure what "protection level" is. Can you elaborate on what that is?
Thanks,
Strick
December 30, 2010 at 12:03 am
stricknyn (12/29/2010)
Hi,Not sure what "protection level" is. Can you elaborate on what that is?
Thanks,
Strick
Sure.
In your package, go to the properties of the package. There you can find the setting of the protection level. It basically defines how sensitive data in your package is treated.
For more information: http://technet.microsoft.com/en-us/library/ms141747.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply