DTS silently fails to import all data

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

DTS silently fails to import all data

Author

Topic

annqueue
Starting Member

12 Posts

Posted - 2007-01-11 : 15:44:53

Hi folks,
I'm using the copy objects task in DTS to move tables from one database to another. It seems to work great, but when I look at the table counts after it's finished, there are rows missing.

This is a known bug, and it's supposed to be fixed in SP2. Here's the whitepaper: [url]http://support.microsoft.com/kb/300195/en-us[/url]

However, we've got SP3 installed and I'm still seeing the issue. Anyone have any ideas what might be going on? Thanks.

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2007-01-17 : 18:37:46

are u logging the dts -- in dts designer, right-click blank spot, click properties, logging tab, enter file name example d:\dts.log

execute dts. what does the log show you?

annqueue
Starting Member

12 Posts

Posted - 2007-01-18 : 11:24:37

quote:
Originally posted by russell
execute dts. what does the log show you?

Here's the log. This time it failed to xfer the last <1000 rows of a very large table, and about 60 rows of a table with just 550 or so rows. Any ideas?

The execution of the following DTS Package succeeded:

Package Name: copy tables to reporting server
Package Description: (null)
Package ID: {CE8B5F25-A107-459C-A4FB-C2C7D67D1EA4}
Package Version: {D8D9EC85-B157-47B2-BDC5-F0514747B2C2}
Package Execution Lineage: {8B14F00D-8AFE-44E4-8777-FB2D59EEBD0C}
Executed On: MyServer
Executed By: me
Execution Started: 1/18/2007 7:55:47 AM
Execution Completed: 1/18/2007 8:15:13 AM
Total Execution Time: 1165.297 seconds

Package Steps execution information:

Step 'DTSStep_DTSTransferObjectsTask_1' succeeded
Step Execution Started: 1/18/2007 7:55:47 AM
Step Execution Completed: 1/18/2007 8:15:13 AM
Total Step Execution Time: 1165.281 seconds
Progress count in Step: 0
****************************************************************************************************

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2007-01-18 : 12:56:31

i'd apply sp4 and post sp hotfix. version 8.00.2039. are u running standard or enterprise? both servers same?

annqueue
Starting Member

12 Posts

Posted - 2007-01-18 : 15:06:40

quote:
Originally posted by russell
i'd apply sp4 and post sp hotfix. version 8.00.2039. are u running standard or enterprise? both servers same?

thanks for the tip, I'll get on our IT folks about SP4.

The source is enterprise and the destination is standard, which I didn't realize until now. I'll try different variations on that and post whether it makes a difference or not.

annqueue
Starting Member

12 Posts

Posted - 2007-01-18 : 18:33:44

quote:
Originally posted by annqueue
The source is enterprise and the destination is standard, which I didn't realize until now. I'll try different variations on that and post whether it makes a difference or not.

Okay, I've tried std->std, std->ent, and ent->ent, and the verdict is that it only happens when I'm transferring FROM an enterprise machine. Doesn't matter if the destination is enterprise or not.

Still working on the SP4 possibility. Still would love to hear other ideas.

Thanks. -Ann

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources