Enable logging in SSIS package

Enable Logging in SSIS Package

1. On the SSIS menu,
Right click —> click Logging.
 
2. Select a logging provider in the list, and then click Add.
 
3. In the Configuration column, select a connection manager to create a new connection manager of the appropriate type for the log provider. Depending on the selected provider, use one of the following connection managers:
For Text files use a File connection manager.
For SQL Server Profiler use a File connection manager.
For SQL Server use an OLE DB connection manager.
For Windows Event Log do nothing. SSIS automatically creates the log.
For XML files use a File connection manager.
 
4. Add the location of text files where you want to create log file.
 
5. Run the package and check the log.
 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.