Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gavinjb
Starting Member
34 Posts |
 Posted - 2009-10-30 : 06:52:10
|
| Hi,I am moving from SQL 2005 to SQL 2008 server, but am having an issue with SSIS I am trying to get my package to create an error log to SQL Server.I have setup the Logging to point to the database, but when the package runs SQL 2008 does not create the error log table, do I need to create the table manually. (I am sure with SQL 2005 it was created automatically if it didn't exist)Thanks,Gavin, |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-11-03 : 05:20:51
|
| The table will be created automatically at run time.http://technet.microsoft.com/en-us/library/ms186984.aspx"Contains one row for each logging entry that is generated by packages or their tasks and containers at run time. This table is created in the msdb database when you install Microsoft SQL Server Integration Services. If you configure logging to log to a different SQL Server database, a sysssislog table with this format is created in the specified database.Integration Services writes logging entries in this table only when packages use the SQL Server log provider." |
 |
|
|
gavinjb
Starting Member
34 Posts |
Posted - 2009-11-09 : 10:12:09
|
| Thanks, that what I thought it should do from my experience with SQL 2005, but for some reason the table is failing to be created at run time, I have checked and the user that I am connecting to the DB with had Admin right to the DB so it can't be a rights issue which was my first thought.Gavin, |
|
|
|
|
|
|
sysssislog Log Table