Post reply

SSIS Connection String

  • March 13, 2009 at 6:00 pm

    #131822

    Please help.

    I have a very simple SSIS package that reads a flat file and loads it into

    SQL2K. How do I make this package fetch the destination connection string from a text file?

    Much Thanks in advance

    Michael

  • March 14, 2009 at 4:37 am

    #959663

    To make the connection dynamic, you have to set the "Connection String" property through the Expressions of Connection Manager to a User Defined Variable that will contain the connection string. Then you need to create a Package Configuration (an XML file) which will have the newly added variable and its properties (such as name, value etc.). And when the package runs, the value of variable gets populated with that defined the package configuration file (i.e. XML file).

    --Ramesh

  • March 20, 2009 at 4:07 pm

    #963838

    Thanks Ramesh! This worked very well.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply