Post reply

DTS Weird Error?

  • May 17, 2005 at 12:59 pm

    #164400

    Hi

    I have 2 DTS packages P1 and P2

    1)P1 creates database and database objects and login

    2) P2 creates user and then loads all the tables

    Everything works as expected.

    Issue: I am required to merge these 2 packages as one... so i add Execute sql task to P2 and put SQL scripts to create database and database objects. But when i execute the package, the database/tables are created but fails when tries to execute the load step ( text source to table).. say's in correct syntax near column 'XYZ'.. if i create DB and Tables in some other package or create them extreanally and start my package with load step it works just fine..

    Any thoughts..?

    Thanks for your time

    THNQdigital

     

     

     

     

     

  • May 18, 2005 at 1:25 am

    #559486

    What are your transaction settings for the package?

     

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

  • May 18, 2005 at 7:58 am

    #559580

    Hi Phill,

    I found the issue.. If i use 2 connection objects one for creating objects and another for loading tables inside the package (p2).. Things work fine.. If i use the same connection object for both of the tasks then i get in to trouble..

    2 connection objects similar in nature.. like same server and default database is same etc.. but this is how i fixed it..

     

    Thanks

    THNQdigital

     

     

     

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

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