Post reply

Dynamic Connection

  • May 30, 2009 at 5:46 am

    #73097

    Hi

    I am new to DTS. I designed package with some ExecuteSQLTask. I have to deploy it in several locations. My connections are hard coded in the connection. How to change connection property dynamic?. I tried DynamicPropertiesTask with query which will get servername from some table. But while executing the dts is taking default connection property only.

    1.How to make the package portable?

    2. Is there any way to hide the package design from the user while sending .dts files to execute in the user environment

    Any help please?

    Soundari

  • May 30, 2009 at 9:17 pm

    #1002445

    Hello,

    For your first question, it may be worthwhile taking a look at this article.-

    http://www.sqlservercentral.com/articles/DTS/portabledtspackages/865/

    For the second question: It is possible to Password protect DTS packages. Please see the Books Online Topic “Handling Package Security in DTS”

    Regards,

    John Marsh

    www.sql.lu
    SQL Server Luxembourg User Group

  • June 3, 2009 at 6:14 am

    #1003914

    Hi

    I refered http://www.sqlservercentral.com/articles/DTS/portabledtspackages/865/

    I followed the article. I couldnt set “On Success” workflow from Dynamic Properties task to connection 1.

    If i select these two workflow property is disabled. Where am i wrong?

    Soundari

  • June 4, 2009 at 2:52 am

    #1004474

    Hello Soundari,

    You don’t need the workflow to go to the connection (they are sort of independent of the workflow). You would instead want the package to move on to your next (data processing) step when the Dynamic Properties Task completes successfully.

    Regards,

    John Marsh

    www.sql.lu
    SQL Server Luxembourg User Group

  • June 4, 2009 at 3:53 am

    #1004488

    Hi

    I tried earlier as u said. But when its executed in the other named instances of sql server its showing the error "Cannot open datatbase "DBNAME" requested by the login. The login failed.

    In My Conncetion Connection1 I set server name is (local) and windows authentication

    In Dynamic properties, I opened Connection1 and set the datasource as GlobalVariable and I am passing this Global Variable in the dtsrun command

    If Server instance changes then its giving error ""Cannot open datatbase "DBNAME" requested by the login. The login failed."

    With Regards

    Soundari

Viewing 5 posts - 1 through 4 (of 4 total)

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