Issue looping through multiple excel files with different sheet names

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Issue looping through multiple excel files...

Issue looping through multiple excel files with different sheet names

Rate Topic

Display Mode

Topic Options

Author

Message

Harjiv Kochhar

Posted Monday, July 19, 2010 3:58 PM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, October 18, 2012 8:52 PM
Points: 33, Visits: 150

I have an several similar excel files and all of them have just one sheet/tab under them with month names. Looping through multiple excel files and loading them into tables was working fine earlier using the For Each Loop Container until I started receiving files with different sheet names other than the default "Sheet1".
Kindly suggest step by step instructions for implementing this. I have tried using the Script task but the package would fail while looping through the files.

Thanks

Post #955157

davemcminoway

Posted Saturday, October 22, 2011 8:26 AM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, August 12, 2012 9:51 AM
Points: 1, Visits: 56

Have you had any response to your question offline? I am attempting to do the same thing. Thanks!

Post #1194801

swaroop.sahoo

Posted Wednesday, October 26, 2011 1:43 AM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:36 AM
Points: 75, Visits: 255

Hi,

I don't know what error you are getting. I just tried your scenario by putting 2 excel files in the source folder with data in Sheet1 and Sheet2 respectively. It is working perfectly fine for me.

May be SSIS engine searches for the right sheet to use. I am using SSIS 2008 R2.

Thanks,
Swaroop

Post Attachments

SSISTest.zip (1 view, 22.35 KB)

Post #1196103

Mr. Holio

Posted Wednesday, October 26, 2011 2:52 AM

SSC Eights!

Group: General Forum Members
Last Login: Friday, May 10, 2013 5:58 PM
Points: 843, Visits: 2,558

Hi,

Would you mind sharing your package so that one could have a look who is interested in the above topic?

__________________________
Allzu viel ist ungesund...

Post #1196126

swaroop.sahoo

Posted Wednesday, October 26, 2011 3:06 AM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:36 AM
Points: 75, Visits: 255

I am not sure how to upload the package and the excel file to this thread. would you mind sharing your email ID!!

Post #1196130

Mr. Holio

Posted Wednesday, October 26, 2011 3:24 AM

SSC Eights!

Group: General Forum Members
Last Login: Friday, May 10, 2013 5:58 PM
Points: 843, Visits: 2,558

swaroop.sahoo (10/26/2011)

I am not sure how to upload the package and the excel file to this thread. would you mind sharing your email ID!!

You can ZIP your files and attach it to your post. Thanks.

__________________________
Allzu viel ist ungesund...

Post #1196133

swaroop.sahoo

Posted Wednesday, October 26, 2011 3:31 AM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:36 AM
Points: 75, Visits: 255

Here you go ..

Post Attachments

SSISTest.zip (10 views, 22.35 KB)

Post #1196137

Mr. Holio

Posted Wednesday, October 26, 2011 3:47 AM

SSC Eights!

Group: General Forum Members
Last Login: Friday, May 10, 2013 5:58 PM
Points: 843, Visits: 2,558

swaroop.sahoo (10/26/2011)

Here you go ..

Assuming the original poster meant to load the stuff into a SQL server table rather than into another excel file?

__________________________
Allzu viel ist ungesund...

Post #1196146

swaroop.sahoo

Posted Wednesday, October 26, 2011 4:07 AM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:36 AM
Points: 75, Visits: 255

It is working with DB tables as well.
Let's wait for the original poster to respond.....

Post #1196153

« Prev Topic | Next Topic »

Permissions