Post reply

Polite DTS Packages - one waits for the other ... an issue?

  • September 16, 2004 at 2:17 pm

    #83980

    I run one DTS Package and it starts.  I run another DTS Package while the first is running and it stays in a start mode (not registering records processed) until the 1st stops.  What is my configuration problem? ... I assume I have a problem if my server can only run one DTS Package at a time.  Both DTS Packages hit the same server but a different source file using ODBC (BTR Pervasive sources).  I don't want to run the loads in the same package because they may or may not both be needed.

    Help!  I just don't feel like this solution is dynamic enough when we need to run parallel loads.  

    Thank you so much for any reply you can get me.

  • September 16, 2004 at 10:12 pm

    #523443

    Dear Ohio,

    What edition of SQL Server are you testing on?

    -Chris

     

  • September 17, 2004 at 8:34 am

    #523509

    Enterprise Manager.  SQL Server 2000

  • September 19, 2004 at 5:01 pm

    #523603

    Are you using the same ODBC datasource, or the same destination tables? It could be that the second package is waiting for locks to be released from the first package.

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

  • September 20, 2004 at 12:08 pm

    #523707

    Same source, differnt table.

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

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