0

In Windows 7 I want to schedule the execution of some DTSX packages. What I've done is to make a CMD file for each DTSX package, and schedule them with Windows Scheduler.

Starting from this article, I write the following code for my CMD files:

@ECHO ON
"C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTExec.exe" /FILE "C:\MyPath\MyPackage.dtsx" /REP P > "C:\MyPath\MyPackage.txt"

the problem is that in the log saved to the file C:\MyPath\MyPackage.txt I can see only the progress of Data Flow tasks.

How can I write the progress of all the flow items (for example "Script Tasks", "Execute SQL tasks", ...).

Nicolaesse
  • 2,554
  • 12
  • 46
  • 71

2 Answers2

1

/Rep P indicates to report On Progress events, which would be related to the data flow. To see more detailed information use 'V' for Verbose:

"C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTExec.exe" /FILE "C:\MyPath\MyPackage.dtsx" /REP V > "C:\MyPath\MyPackage.txt"

For more options, look here: https://learn.microsoft.com/en-us/sql/integration-services/packages/dtexec-utility

Mark Wojciechowicz
  • 4,287
  • 1
  • 17
  • 25
1

Progress information is received from On Progress events, which are available on DataFlow tasks only. On Progress event is fired when complete buffer is processed or at the end of processed data flow.
Regular Tasks do not have On Progress event, since they are not processing lines of data; they are either at Completed or Failed state. So, you cannot see progress of standard non-DataFlow tasks at your log.

Ferdipux
  • 5,116
  • 1
  • 19
  • 33