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-07-02 : 09:38:51
|
| Hey allI'm running a data flow task where all the "good" rows go into a table and I would like the "bad" (error) rows to go into an excel file. I've got everything set up, I'm using 'Derived Column' transformation to put all the error rows into the Excel Destination but I get the following error when I try to convert StaffNo to Unicode string:[Derived Column [19833]] Error: Converting an input column from type DT_STR to type DT_WSTR failed. An error occurred while performing the implicit conversion on the input column. [Derived Column [19833]] Error: The "component "Derived Column" (19833)" failed because error code 0xC0049066 occurred, and the error row disposition on "output column "StaffNo" (19864)" specifies failure on error. An error occurred on the specified object of the specified component. Any ideas?? Many, many thanksRupa |
|
|
|
|
|
Help on error message please!