Error in SSIS conversion [modified]
-
I have a SQL table that I am importing that has 2 columns title and description of type text that need to be converted to varchar(max). none of the 2 have more than 4000 chars and its English only. I created a data flow task with a transformation to convert both columns to string [DT_STR] 4000. My destination has both columns as varchar(MAX). I get a very informative error of Cannot create an OLE DB accessor. Verify that the column metadata is valid. When I GIS most suggest the conversion which I am already doing. Anyone been through this?
modified on Monday, August 4, 2008 2:30 PM
-
I have a SQL table that I am importing that has 2 columns title and description of type text that need to be converted to varchar(max). none of the 2 have more than 4000 chars and its English only. I created a data flow task with a transformation to convert both columns to string [DT_STR] 4000. My destination has both columns as varchar(MAX). I get a very informative error of Cannot create an OLE DB accessor. Verify that the column metadata is valid. When I GIS most suggest the conversion which I am already doing. Anyone been through this?
modified on Monday, August 4, 2008 2:30 PM
If your destination column is Varchar(MAX), you've to convert it to DT_WSTR in your transformation.
-
If your destination column is Varchar(MAX), you've to convert it to DT_WSTR in your transformation.
-
If your destination column is Varchar(MAX), you've to convert it to DT_WSTR in your transformation.