ssis - data transfer from Multiple Excel files to SQL table -


need transfer data multiple excel files sql table. instance there multiple excel files in folder such 1.inr_08012013.xls 2.inr_08022013.xls 3.inr_08032013.xls note: @ datepart increments in file_name.

i'm planning create ssis package , import data sql. know can import 1 excel file @ time i'm planning several @ time. there many excels don't want create multiple ssis packages job.

i want create 1 ssis package(for multiple excel files) , import data sql. possible thru ssis, give me guidance.

thanks!

i not ssis user, using google found

http://bi-polar23.blogspot.com/2007/08/loading-multiple-excel-files-with-ssis.html

and

http://codejotter.wordpress.com/2010/04/06/importing-multiple-text-files-using-ssis/

hope helps.


Comments

Popular posts from this blog

Detect support for Shoutcast ICY MP3 without navigator.userAgent in Firefox? -

web - SVG not rendering properly in Firefox -

java - JavaFX 2 slider labelFormatter not being used -