ETL/SSIS

Re: SSIS importing multiple excel sheets

PedroCGD — Mon, 19 Oct 2009 11:04:42 GMT

Very good!!

regards,

Pedro

Re: SSIS importing multiple excel sheets

Cecil1982 — Wed, 16 Sep 2009 15:11:50 GMT

h Pedro

i was just letting you know that i manage to fix the problem i had last time, so no need to worry about it

Thanks

Re: SSIS importing multiple excel sheets

PedroCGD — Wed, 09 Sep 2009 13:31:06 GMT

Could you attach here the package or send to my email?

Regards,

Pedro

Re: SSIS importing multiple excel sheets

Cecil1982 — Wed, 09 Sep 2009 11:14:55 GMT

Hi Pedro

I have already saw the information from that link, but now my problem is i couldnt get hold of the solution that you said you will publish, if i can at least get my hands on the solution so that i should know how you created the tables and importing their according to the iterated spreadsheet,

all i have done is i can iterate through all excel files, and create the table per each iterated excel file , but the problem is i am getting an error when i try to import dat on the data flow side... please help please

Re: SSIS importing multiple excel sheets

PedroCGD — Wed, 09 Sep 2009 10:54:59 GMT

Hi Cecil,

Welcome to the community.

Take a look at the answer I gave in this following post:

http://biresort.net/forums/t/30.aspx

Helped?

regards,

Pedro

SSIS importing multiple excel sheets

Cecil1982 — Tue, 08 Sep 2009 15:05:49 GMT

Hi everyone

how do i create a table based on the name(s) of excel(or Sheets) file that you are importing(or looping through), and at the same time import the data from that excel(Sheets) file into the created table in the database

all i have done is, i can loop through the excel file, and create the table into the database based on the name of the iterated excel file, but i dont know how to import the data from that excel file. i will be really happy if you can provide this as a solution that uses excel sheets

Thanks

Cecil