DTSRUN customized output

Question

DTSRUN customized output

JMI

SSChampion

Points: 11831
More actions
November 29, 2005 at 3:37 pm

#169633

Is there any way to
have custom output when using DTSRUN?
For example I want to have:
DTSRun: Loading...
DTSRun: Executing...
DTSRun: DTS package 'MUREX.dts' started
...
Thanks,
Rob

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Jeet SSCommitted Points: 1536 More actions · Answer 1

If you use ole methods and load and run the package using this then since each of the above(load, execute ) are seperate steps you could output this info.

Thanks Jeet

David Korb SSCrazy Points: 2505 More actions · Answer 2

You can log each step in a scheduled job.

Open the job, open a step for editing, click the advanced tab, choose an output file location in the "Transact-SQL Script" section, choose append output to step history.

You can use the output file to create whatever report you want.

JMI SSChampion Points: 11831 More actions · Answer 3

Guys!

I'm not using SQL Server Agent (Scheduler).

It's a batch file that has DTSRUN command

and that batch is being scheduled in Tivoli Workload Scheduler by IBM.

So, is there any way during DTS design to make some costom output?

Thanks,

Rob

David Korb SSCrazy Points: 2505 More actions · Answer 4

I don't know what kind of output you get, but you can:

In DTS designer, right click in the open field, choose package properties, click the logging tab, and go from there.

JMI SSChampion Points: 11831 More actions · Answer 5

SprocKing,

Right Click in Designer , Properties, Loggigng

gives you an option to log to SQL Server,Even Viewer.

But what I need is in DOS window

have output that I want,

not only default messages like DTSLoading...etc.

Rob

swede SSCommitted Points: 1773 More actions · Answer 6

We use a product call Batch Job Server, which runs dos bat files. We get the DTS messages in our Batch Job Server logs, which is a text file for each execution of the job.

DSP-120308 Hall of Fame Points: 3959 More actions · Answer 7

Rob,

If you right click in the designer window and chose the Disconnected Edit option you can copy the description of each task and step to the name field under Tasks and name and TaskName under Steps. NOTE - Be Sure you put the same descriptions in the TaskName of Steps that is in the Name field under Tasks.

Give your DTS package a Description when saving.

Now when you run the DTSRun you will see the information you are looking for.

Good Luck,

Darrell

JMI SSChampion Points: 11831 More actions · Answer 8

That's not what I want.

I want CUSTOMIZED output.

I know I can give unique names to Tasks and Steps

and then DTSRun will show

<TaskName> starting...

<TaskName> finished...

Lets' say I need to output:

"INSERT: 3450 records inserted into tblABC"

Nobody seems to know how to do it....

David Korb SSCrazy Points: 2505 More actions · Answer 9

Then maybe you should figure it out, then come back and tell us?

JMI SSChampion Points: 11831 More actions · Answer 10

Solution:

In ActiveX Task switch to Perl Scripting language

and type this, for example:

#**********************************************************************

# Perl ActiveX Script

#************************************************************************

sub Main()

{

print "PERL WILL PRINT!";

return 0; # DTSTaskExecResult_Success;

}

Now to to DOS and run DTSRun command.

You should see "PERL WILL PRINT!"

Thank you all!