Post reply

setting connections dynamically

  • September 18, 2003 at 4:54 am

    #106294

    How do I change the database referred to in SQL Server connections for all called DTS packages

    In Brian Knight's article of 23 May 2001:

    quote:

    Next week we will go into setting connections dynamically

    I can't find the subsequent article

  • September 18, 2003 at 5:45 am

    #474849

    You may use the Dynamic Properties task for this.


    Joseph

  • September 18, 2003 at 6:19 pm

    #474966

    You can also use an ActiveX Script task. In the past I've found this method a bit more flexible than the Dynamic Properties task.

    For an example, check out this post,

    http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=16191&FORUM_ID=19&CAT_ID=3

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

  • September 19, 2003 at 3:15 am

    #474995

    Thanks for your replies - I have had a play with both methods and seems fairly straightforward and lots of possibilities.

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

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