If you are on SQL 2000, you can turn on Package Logging. Then you can get timings on package and step execution from the msdb database.

sysdtspackagelog - cotains package execution...

The message you get sort of points to an error with some SQL being used within the package.

Can you successfully execute the package via the designer?

Thanks

Phill Carter

Yes it is possible.

To get an idea on what you can do with DTS, get the SQL Server Accelerator for BI.

http://www.microsoft.com/solutions/bi/

With this tool you define what you want your datawarehouse...

Have a look at the following discussion and see if it gives you some ideas.

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=571&FORUM_ID=23&CAT_ID=2&Topic_Title=CDONTS%20Email%20from%20SQL*Server&Forum_Title=General

Also check this article to see if you've got things setup correctly,

http://support.microsoft.com/view/tn.asp?kb=312839

Thanks

Phill Carter

Edited by - phillcart...

I've always done client side validation. This prevents someone using SQL Injection by entering something like,

Insert into dbo.CUSTOMER(comments) value '' exec master..xp_executesql 'drop table dbo.customer'--'

Not to sure what the equivalent...

Check out

http://support.microsoft.com/default.aspx?scid=kb;en-us;306401

Thanks

Phill Carter

If you select {LF} as the row terminator you'll be able to import all the rows in the file. You'll get an extra column that has the carrige return character...

Define "reasonably 'pretty' format" what output are you looking for?

You could put together something in ASP. I believe there is a NextResult method that allows you to process multiple resultsets.

Thanks

Phill...

Here's a start. It shows how to reference the package, step and task objects within a script. All it really does is display the step and task name. Once you...