June 29, 2012 at 8:59 am
Hello,
In an effort to get my package to work as a job:
http://www.sqlservercentral.com/Forums/Topic1321933-364-1.aspx
I'm trying to enable package logging. I've read a couple of pages that discuss the subject:
http://learnsqlwithbru.com/2009/11/26/configure-logging-in-ssis-packages/
Unfortunately I can't get it to work. I've followed these steps:
1. Opened up the dialogue by visiting the menu item at SSIS/Logging
2. Made sure the checkbox is checked in the top left corner (with my package name).
3. Chosen a provider type: 'SSIS log provider for SQL Server'
4. Clicked "add".
5. Checked the box next to the new line that appears.
6. In the 'configuration' column, chose the existing database connection. (The package writes user-defined messages to the same connection.)
7. In the "details" pane, clicked on "OnError", "Diagnostic", "OnTaskFailed" and just to see something, "OnProgress."
8. Clicked on "ok" when finished.
I've run the package in BIDS. I'm expecting that a a new SQL table is created on the database specified by the connection. I'm assuming the new table name will be 'SSIS log provider for SQL Server 1", which is the default name for the row that I created when I clicked "Add."
However, after debugging the package in BIDS I never see the new table in the database in question.
Am I missing something? Surely this feature works.
thanks.
July 2, 2012 at 1:40 am
The table is called dbo.sysssislog.
If it's not created in the database, take a look at the system tables, it may have ended up there.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 2, 2012 at 6:56 am
I see it now. It is in the 'System Tables' folder in the database it should be in.
Thanks!
🙂
July 3, 2012 at 4:09 am
Flat file logging can be easier to follow when starting logging.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply