Posts
19
Comments
28
Trackbacks
1
SSIS - “OLE DB provider ‘STREAM’ for linked server ‘(null)’ returned invalid data for column ‘[!BulkInsert].column_name’."

I've been trying all day to solve the problem with export of data using SSIS and keep encountering this error: "OLE DB provider 'STREAM' for linked server '(null)' returned invalid data for column '[!BulkInsert].{column_name}'.

It seems that data in that column is invalid so I've tried to add validation to my source OLEDB source. I've created a dataflow to filter all records that have bad data and redirect it to a file. To do this in the query of my source OLEDB I've add the following condition: WHERE isnumeric(convert(varchar(250), coalesce([{column_name}],0))) = 0 then put the results in the file IDs and etc, but I removed the {column_name} to prevent errors.

I now have the IDs of bad data and will try to some fixes before do the import.

posted on Friday, March 06, 2009 6:24 PM Print
Comments
Gravatar
# re: SSIS - “OLE DB provider ‘STREAM’ for linked server ‘(null)’ returned invalid data for column ‘[!BulkInsert].column_name’."
Freelance DBA
3/6/2009 6:59 PM
When you found the cause of problem please update the post. I am very insterested what exactly the problem was. My packages also fail from time to time with this kind of error and I have not managed to figure out what is wrong.
thanks, Vadym.
Gravatar
# re: SSIS - “OLE DB provider ‘STREAM’ for linked server ‘(null)’ returned invalid data for column ‘[!BulkInsert].column_name’."
RPaulo
3/7/2009 1:00 AM
The problem is with the data, some third party application put a NaN value on a float data type.
Comments have been closed on this topic.