DTS gives problems on Win XP and Win 2003

• Suresh-138986

  Grasshopper

  Points: 17

  More actions

  April 12, 2005 at 1:43 am

  #87278

  Hi,

   

  I had a question on executing DTS packages on Win XP/2003.

  We developed a DTS package in VB 6 to copy data from an MS Access (97/2000) database to a SQL Server 2000 database. This standard .exe package runs fine on Win 2000. However, on Win XP/2003, it runs in a haphazard manner i.e. it copies some random number of tables and then hangs. I wanted to know if any one experienced such a problem and how they resolved it.

  Since the source database has around 100 tables, we used SQL Server DTS Import/Export Wizard to generate the VB code. We created 10 separate .bas files - one per set of 10 tables - for ease of maintenance. We then added these files to a standard .exe project.

  We created a similar package to copy data from one SQL Server database to another. It works fine on all 3 OSs mentioned above.

  Any help on this would be highly appreciated.

   

  Please do not suggest upgrading the MDAC but i would like to understand if i am missing something here or i need to take care of some stuff for WinXP/2K3.

   

  Thanks,

  Suresh

• James Horsley

  Hall of Fame

  Points: 3196

  More actions

  April 13, 2005 at 2:18 am

  #552319

  You might want to check if you have Jey Service Pack 8 for Win 2003 installed

  ---

  James Horsley
  Workflow Consulting Limited