Tuesday, September 29, 2009

SSIS not logging in sql server table sysdtslog90

SSIS not logging errors in SQL Server Table sysdtslog90
Drop and recreate the sysdtslog90 table with DBO as the owner as below.


select * into dbo.sysdtslog90_1 from sysdtslog90;

drop table sysdtslog90;

select * into dbo.sysdtslog90 from sysdtslog90_1;

drop table sysdtslog90_1;

No comments:

Post a Comment

Featured Post

SQL Server AWS Migration BCP

stored procedure to generate BCP scritps to migrate the SQL Server database. Developed this stored procedure on my labs to simulate t...

Contributors