CODEWITHSUNDEEP
ssis
pramodtech
pramodtech

Reputation: 6270

Configure SSIS logging to log in one file

I know configuring the logging for individual packages thru BIDS. But the drawback I see here is I have to add connectionstring for each tasks and when I have to deplloy these packages on server I have to change log file connectionstring for all packages. Currently I have 32 pacakes and this seems to be time consuming. Is there any way where I can set up logging for all packages in one place?

Upvotes: 0

Views: 1303

Answers (2)

CTKeane
CTKeane

Reputation: 670

I run some jobs through the DTEXEC dos command and I redirect the output to a .log file.

Example

DTEXEC 
   /DTS "\File System\Customer_pkg" 
   /SERVER xxxxx 
   /MAXCONCURRENT " -1 " 
   /CHECKPOINTING OFF  
   /REPORTING V > c:\log\Customer_pkg.log

Upvotes: 0

William Salzman
William Salzman

Reputation: 6446

You need to look at storing your configuration in either files or sql tables. For instance, in my current project, I have a common configuration file that has all of the items (like logging that are common to the entire project, then I have individual config files for items that are different per package (like individual database connection strings and variables). This allows me to modify the config on deployment without changing the package. SSIS reads in the configuration at runtime. To use logging see the answers in this question:
Is there a way to easily change the server name on several SSIS packages programmatically?

Upvotes: 3

Related Questions