October 16, 2015 at 10:21 am
I've created a few SSIS packages with one package being the main package to call my other packages
With each package I set-up package configuration to use a SQL Server table
This connection will need to use a SQL Server Authentication, and not windows authentication.
I've then imported all my packages into SQL Server.
When I run the main package I go to connection manager and supply the password to the connection string for the Configuration DB
But when the child packages execute, that all throw errors saying the login failed for the SQL Server user account.
This is because the password is not saved.
I have even changed the connection string within the configuration table for this DB, but it still fails
How do I pass the connection string to the child package to access the configuration DB?
October 16, 2015 at 2:34 pm
https://www.youtube.com/watch?v=GiGHkQi2SAk
He gets around to it at 7:15. Config type is Parent package variable.
[font="Courier New"]ZenDada[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply