I'm trying to update columns in my SQL Server Compact Edition 3.5 DB through OLE DB COMMAND in SSIS 2012.
When I update a column with NTEXT datatype my SSIS Debug Host stops working.
Otherwise I could update all the other columns with datatypes like nvarchar,int,numeric,datetime.
I'm trying to update with value from ORACLE 11g DB Column of the datatype VARCHAR by using the data conversion Unicode text stream.
Kindly suggest a solution.
Arthur My Blog
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?