I created the table in SQL and SQL Azure using the exact same script. When I tried to use Ado.net data source and OLE data destination in the SSIS package, the SSIS complains about "cannot covert unicode and non-unicode". I do not really have time to figure out why this can happen. Instead, I use the DataConversion solved this problem.
No comments:
Post a Comment