top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How to solve 'can not covert between unicode an non unicode' error in SSIS while inserting data from Excel to SQL Table

+9 votes
363 views

My table columns are varchar and i can't alter the table

posted Jan 31, 2014 by Neeraj Pandey

Looking for an answer?  Promote on:
Facebook Share Button Twitter Share Button LinkedIn Share Button

Similar Questions
+3 votes
Problem in inserting data from Excel to database

I am using SSIS to insert data from Excel 2007 to SQL Server database, but i am not able to insert all the rows present in Excel. Suppose My Excel is having 2000 rows but only 1500 rows are inserting in DB,while Package is showing as successfully completed.

+3 votes
How to pick up the date from any Excel file in SSIS

I need to take date from a excel file, Suppose it is in 2nd column of 2nd row. Can i do it with SSIS only or with any other scripting language ?

...