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.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Insert Filename

Author  Topic 

Rupa
Posting Yak Master

123 Posts

Posted - 2007-06-20 : 06:39:12
Hey all

How wld I insert a filename using:

INSERT INTO SSISLog (Filename,EventType,EventDescription)
VALUES (???, 'OnError','" +@[System::ErrorDescription]+"')

I would like to insert the filename that failed to import. Any help will be highly appreciated.

Many, many thanks

Rupa

   

- Advertisement -