Progress count in Step: 0 - SQL Server Forums

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)

Progress count in Step: 0

Author

Topic

ProgramX
Starting Member

4 Posts

Posted - 2006-12-08 : 08:17:03

Hello
I think your forum is great!

I have this problem since June, when I wanted to scheduler a DTS package.
This package transfer data from a text file.
Text file (Source) ->Transform Data Task ->MS SQL Sever(My_database)

The source contains 60.000 rows.

When I execute the package in Enterprise Manager is OK.

Package Steps execution information:

Step 'DTSStep_DTSDataPumpTask_1' succeeded
Step Execution Started: 08.12.2006 08:14:54
Step Execution Completed: 08.12.2006 08:15:06
Total Step Execution Time: 12,625 seconds
Progress count in Step: 61999

But when is running in scheduled tasks with a *.bat file containing
dtsrun /S SERVER_NAME /N Import_text_file /E

Progress count in Step: 0

And not a single row is transfer.

Please help me with that!

PS
This is happening with ODBC Data Source to, where I have ~ 500.000 rows.

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-12-08 : 08:22:30

Add /L option to generate log file and see what the log file contains.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

ProgramX
Starting Member

4 Posts

Posted - 2006-12-08 : 11:20:15

The purple text is taken from log file:

Package Steps execution information:

Step 'DTSStep_DTSDataPumpTask_1' succeeded
Step Execution Started: 08.12.2006 08:14:54
Step Execution Completed: 08.12.2006 08:15:06
Total Step Execution Time: 12,625 seconds
Progress count in Step: 61999

The diference is Progress count

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources