Post reply

SSIS Package Connection Contexts

  • November 4, 2006 at 2:59 pm

    #175098

    1) When we work with SSIS data flow packages, for source and target conatiner, we add a connection.

    2) Instead of pre-fixing connection contexts this way, I would like to provide these dynamically at execute time.

    3) Is this possible & if so, how?

    4) Is it possible to compile, deploy and install packages without specifying connections for source and target containers and then provide these dynamically at execute time. 

  • November 7, 2006 at 7:45 am

    #670287

    Not entirely sure what you mean by connection contexts but here are a couple of ideas...

    You can set the connection string used by you connections via the ConnectionString property on the connection object through an expressions. Using variables you can pass these connections strings among packages.

    Secondly you can open, modify and execute a package using the script object. This requires you write some code but you should be able to dynamically change most of the contents of the package before execution.

    Regards

    Daniel 

  • November 7, 2006 at 10:22 am

    #670335

    Thanks, Daniel.

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

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