Post reply

Dynamic Connection for a Data Flow Task

  • June 2, 2009 at 12:57 am

    #221849

    Is it possible to set a dynamic connection for a Data Flow Task ? My requirement is like this - I need to create database and tables in it at run time and then I want to copy data from my source database to this newly created database. Since my Database is created at run time I want to set the connection property of OLE DB Destination task at run time. Is it possible ? If yes, how ?

  • June 2, 2009 at 5:49 am

    #1003335

    You need to set the "ConnectionString" property of the destination connection manager's "Expressions" collection using global variables or package configurations.

    --Ramesh

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

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