• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 887
  • Last Modified:

SSIS Log provider for SQL Server not working on my SSIS Package

I've set up logging to a SSIS log provider for SQL Server but it doesn't seem to be populating anything. I thought it would create a log file in my connection database but there's nothing there. THought it may be defaulting to syssislog in MSDB but that's empty as well. Is there a way of finding out where it's being logged, or if it's working at all please?
0
Grffster
Asked:
Grffster
1 Solution
 
PedroCGDCommented:
The logging table will be created after the first package execution and stored in the connection you create inside the respective package. The table is stored under the system tables folder of your database connection.
regards,
pedro
0
 
GrffsterAuthor Commented:
Ha! Never thought of looking in there! Many thanks.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now