Post reply

SQL Server configuration table

  • October 16, 2015 at 10:21 am

    #312334

    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

    #1833913

    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