Post reply

refresh Connection datasource

  • November 21, 2005 at 8:25 pm

    #166353

    Hi,

    I am trying to execute DTS package through the Batch file and i would need to change the DSN name randomly.

    I have use the following code, still its not getting refreshed..Is there any other way to set and refresh the connection data source or DSN name?

    connection.datasource = DSN Name

    connection.catalog = DSN Name

    Thanks i advance

     

     

  • November 22, 2005 at 7:51 pm

    #605377

    seems to me that one of the drawbacks with DTS was that connection strings were part of the package and could not be changed without editing.  That is supposed to be one of the improvements with SSIS; although I have not figured out where they are stored yet or how to change them during a build/deployment.

    In other words, I don't know the answer to your question; but still provide my two cents worth

    Cheers,

    david russell

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

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