Home Forums SQL Server 2005 SQL Server 2005 Integration Services Connection manager in SSIS - RE: Connection manager in SSIS -

  • February 3, 2009 at 10:59 am

    #937367

    sql-oholic (2/3/2009)

    Sorry to bother u again... but i didn't get it clearly.

    Can you explain it a bit more ...

    I assume it has to start with creating user variable...using it in ConnectionString .

    I am not sure if this is right way

    Or is there a web resource, I can refer to.

    thank you!

    You don't need to use variable and build the connection string. You can include the complete ConnectionString (with all parameters) in the configuration and apply it to the connection manager property.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/