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 |
|
Rupa
Posting Yak Master
123 Posts |
 Posted - 2007-06-19 : 08:28:45
|
| Hey allWhich system variable do I use if I would like to transfer success message into an SQL table? I'm running a task to import data into an SQL table. And I'm using the System::ErrorDescription variable (Execute SQL task) to insert error messages into a table but I would really appreciate it if someone could tell me what system variable would insert 'success' message into an SQL table. Tried a lot of searching on the net but couldn't find anything.Many thanks,Rupa |
|
|
Rupa
Posting Yak Master
123 Posts |
Posted - 2007-06-19 : 08:40:50
|
| P.S> I would like to use the System::PercentComplete variable but it gives me the following error:The data types "DT_WSTR" and "DT_I4" are incompatible for binary operator "+". The operand types could not be implicitly cast into compatible types for the operation. To perform this operation, one or both operands need to be explicitly cast with a cast operator.This is my code:"INSERT INTO SSISLog (EventType,EventDescription)VALUES ('OnProgress','" +@[System::PercentComplete]+"')"Many thanks,Rupa |
 |
|
|
|
|
|
Success message