Import Data From Excel to SQL Server Using SSIS

preview_player
Показать описание
Import Data From Excel to SQL Server Using SSIS
Рекомендации по теме
Комментарии
Автор

I was trying to copy data from Excel to Excel (just to test how SSIS works). I failed it previously, but that 4:40 solved it for me. Thank you!

ArtoKilponen
Автор

Why not use the SQL destination instead of OLE DB ?

joshi
Автор

thanks! great help, successfully executed

marvicgayomali
Автор

Best tutorial! BUT what if i need to browse the excel file at run time (how can i run the package from ASP.NET by having the excel file from a File-upload Control.)
Thank You in Advance!

jobiraw
Автор

How is this related to Visual Studio?!

JobQuestUnveiled
Автор

Thanks for the effort, but not a realistic tutorial. In real life, 100% of the cases, the datatype needs to be converted from Excel into SQL... it should be added

xaviercomelli
visit shbcf.ru