I have the following: Source column from text file: string, length=50 Target column in the SQL table is varbinary(75) datatype When loading the data from flat file into the sql table, all the columns are loading fine except for the above column. For the above column in the SQL table the actual data from text file is not going into the table instead below data shows up in the SQL column: 0x034574210111 0x034783409122 I tried different ways to convert the data type, I tried to convert the column as string in the OLE DB destination editor, then I was getting the failure insert error into a read only column. Any ideas on resolving this. Thankssqldev

Can you change the type of column in the destination SQL table? Change the column type to nvarchar(MAX) and it will work just file.Please mark as answer if this helps. Thank you. http://thebipalace.wordpress.com

Yes, that will work. But without changing the datatype of the destination SQL table can we do anything inside SSIS?sqldev

I understand one of the columns in your flat file contains some binary/raw data. I think an Import Column Transformation may be needed. Please see this example if helpful: http://jahaines.blogspot.com/2009/10/ssis-importing-binary-files-into.htmlArthur My Blog