Archive

Archive for April, 2015

solution from web for SSIS “can not convert between unicode and non-unicode string data types”

http://www.mssqltips.com/sqlservertip/1393/import-excel-unicode-data-with-sql-server-integration-services/

Advertisements
Categories: Uncategorized

Useful SSIS tips and tricks from the web

Categories: Uncategorized

Copy Excel Data to SQL Server Tables using Copy and Paste

This works and saves lot of headache and time

Try to create the Excel columns and table structure in the same format and structure as ms sql table is. Open the excel select the row (whole row by clicking on row number) select the whole data till end of the data (selected first row to last row). press ctrl+c

edit the ms sql table, go to last row where you can find blank.

Select that row by clicking on row button and press ctrl+v.

Done you’re excel data will be inserted into sql table.

Suggested on Stackoverflow by user3666801

Categories: Uncategorized