Weird DTS issue - Rows Missing

• ChrisMoix-87856

  SSCertifiable

  Points: 7288

  More actions

  March 14, 2007 at 1:14 pm

  #68466

  Hello,

  I am having a weird DTS data import issue. I am importing data from an Access database with something like 160 tables. I created 8 sets of Access source connectionds and SQL Server destination connections (20 Transformation Data tasks per set of connections). I am truncating the tables then importing all rows from Access into SQL Server.

  The DTS package runs successfully and shows rows copied in the results window (It shows a successful step and the number of rows: tblVehicleIncidents (464)) after it completes.

  When I look at the tables in question, some of them have no rows! Even though they showed a specific number of rows copied, the tables are empty. I have checked all of the obvious things. There are the correct number of rows in the source database, etc. I even reduced the number of parallel connections from 4 to 1.

   

  I'm at a loss. If anyone has any experience with this sort of thing, please help!

  Thanks,

  Chris

• ChrisMoix-87856

  SSCertifiable

  Points: 7288

  More actions

  March 14, 2007 at 1:26 pm

  #695055

  Never mind, It looks like I fixed it. It makes no sense, but at least it works.

  I had an Active X scritp to copy the Access database from a fileshare to the SQL Server. This was the first step, with all of the other steps following On Success of the copy step. When I removed the copy file, it all imported perfectly. I'm going the copy file in a seperate step now, and it is working fine.