My ssis package exports .xls file data into a sql server table. The fields in the sql server table have to be nvarchar instead of varchar. If I use varchar then the ssis package gives an error about converting unicode to non-unicode... Another ssis package exports .csv data into the sqme sql server table as above. This time the sql server table fields have to be of type varchar because otherwise the ssis package gives an error about converting non-uniciode to unicode... I basically would like to have a sql server table with varchar fields and let these packages import into it. These packages may retrieve data from .csv or .xls. How can I resolve this? Thanks
U need add SQL script component which converts varchar to nchar using the CAST or CONVERT functions before dumping into SQL server. Check BOL you find ample examples on this, Iam not able to locate SSIS example on it yet but Iam sure the Gurus will in next post. Cheers Sat