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 |
|
sqluesr_2010
Starting Member
1 Post |
 Posted - 2010-02-19 : 07:31:41
|
| I have a SSIS created with source as a MS SQL table and destination is a MS Excel. I need to transfer data from sql table to this excel file. The table has a column with data type "TEXT". When package is executed it fails with :[OLE DB Destination [34]] Error: Cannot create an OLE DB accessor. Verify that the column metadata is valid. "I tried to use convert in the sql query to use varchar(8000) and even varchar(max) but they fail again. It only works when i use convert varchar(255) for this field in my sql query. But, I am losing the data as its truncated to 255. Please help |
|
|
|
|
|
SSIS fails for text column'd datatype