Results 1 to 2 of 2

Thread: DTS Looping

  1. #1
    Join Date
    Oct 2003
    Location
    Australia
    Posts
    15

    Red face Unanswered: DTS Looping

    DTS Looping
    Hi,
    I have read articles on DTS looping http://www.sqldts.com/default.aspx?6,103,246,0,1 and a few others, but I still have a problem.

    Trying to connect to different Interbase databases via Interbase ODBC driver.
    -After connection, use a datapump to select data from db A
    -Then loop, based on a global variable that holds the count/ID of the new database B to connect to.

    Problem
    -GLobal variable successfully getting updated with new branch details
    -ODBC driver 'seems' to be switching to new branch db B
    -But datapump goes to database A and tries to select the same data again it has done already.
    -Loop fails. But if all steps run manually one by one the loop works i.e goes to A then goes to B.

    HeeeEEEllLLLppppp !
    Attached Files Attached Files

  2. #2
    Join Date
    Oct 2003
    Location
    Australia
    Posts
    15
    Hi,
    Looks like I have had no luck in this, and nor has anybody else.
    Calling all SQL server experts to take a look

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •