CODEWITHSUNDEEP
sql-serverssispackage
mhn
mhn

Reputation: 2750

Log to text file - items in Progress Tab of SSIS Package

In SSIS, i need to write into a log, whatever items get displayed on the Progress tab. Is there an inbuilt feature to do this? i tried the logging option but it logs too many details and the log is pretty huge for a single package run.

i need only whatever gets logged on the Progress tab to be logged on to a text file when the package undergoes a scheduled run through Sql server agent

Upvotes: 0

Views: 1661

Answers (1)

TsSkTo
TsSkTo

Reputation: 1420

Here is a possible solution.

You have an option at DTEXEC at the command-line. There is a switch called /Reporting or /Rep for short.

I found it here

This link says the same.

This is your question in MSDN. Its pretty useless since they suggest you turn on logging, which you've already done. I thought I should add it anyways for completeness.

Upvotes: 1

Related Questions