hi, Paul_J.

thanks.

Yeah, I did installed Excel and I could use it.

But I end up not using Excel library,,,

Because, when I use Excel library in Script task, proccessing time was...

hi, LucaZAV

thanks for the site.

It looks hard to me, but I will try.

thank you.

tomoko

hi, Paul_J.

thank you for replying.

I understand that I need to install the office primary interop assemblies.

To get those, do I have to install Excel on SSIS Server since I havent...

hi, JKSQL

thank you for replying.

Package did run well without having Excel on Server.

thank you.

hi, bang.prashant

Thank you so much about the site above.

Now it worked !!!!

I didnt set default value of the variable, so when I tried to change

the "table" to “Table...

hi, bang.prashant

thank you for your reply.

but the excel file may have more than 2 sheets. sometimes 10 sheets.

and each sheets data must be inserted into one same table.

If I use...

Hi,Karen.

Thank you very much for replying me.

I found this site : http://msdn.microsoft.com/en-us/library/ms345182.aspx

I tried Foreach Loop Container to loop one data flow which is to read, to transform, and...