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 2008 Forums
 SSIS and Import/Export (2008)
 varbinary(max) data and SSIS

Author  Topic 

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2010-03-31 : 05:34:42
In my SSIS package, i have to extract data to RAW file as destination, but source table contain a column with datatype varbinary(max).

I am getting this error:
Error at Data Flow Task - TestSSIS [Attachments_Raw [8237]]: The column attachment_file cannot be used. The raw adapters do not support image, text, or ntext data.

What should i do... ?, What should be my destination file format to achieve my goal?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-03-31 : 14:12:48
try with flat file destination

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -