DTS output how to put it in a log file

[ehx6]

hi, I created a TDS to upload data into a table in sql server, the output of the dts is shown below, my question, how can I capture the output of the DTS so I can save it in a log instead of showing it in query analyzer window?
thanks
ehx5
output
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: Delete from Table [PCx].[dbo].[sales_option_price_report] Step

DTSRun OnFinish: Delete from Table [PCx].[dbo].[sales_option_price_report] Step

DTSRun OnStart: Copy Data from sales_option_price_report to [PCx].[dbo].[sales_option_price_report] Step

DTSRun OnProgress: Copy Data from sales_option_price_report to [PCx].[dbo].[sales_option_price_report] Step; 1000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 1000

DTSRun OnProgress: Copy Data from sales_option_price_report to [PCx].[dbo].[sales_option_price_report] Step; 2000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 2000

DTSRun OnProgress: Copy Data from sales_option_price_report to [PCx].[dbo].[sales_option_price_report] Step; 3000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 3000

DTSRun OnFinish: Copy Data from sales_option_price_report to [PCx].[dbo].[sales_option_price_report] Step

DTSRun: Package execution complete.

NULL

(23 row(s) affected)

 

[jms8222]

Right-click in the whitespace of your DTS package and choose "Package Properties" If you click on the logging tab, you have the option to write your output to a log file.

 

[ecobb]

You can also export your results to a text file.



Hope This Helps!

Ecobb

"My work is a game, a very serious game." - M.C. Escher