Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Issue looping through multiple excel files with different sheet names Expand / Collapse
Author
Message
Posted Monday, July 19, 2010 3:58 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC 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
Posted Saturday, October 22, 2011 8:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, May 23, 2014 9:03 AM
Points: 1, Visits: 85
Have you had any response to your question offline? I am attempting to do the same thing. Thanks!
Post #1194801
Posted Wednesday, October 26, 2011 1:43 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, January 6, 2014 11:35 PM
Points: 75, Visits: 262
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 (2 views, 22.35 KB)
Post #1196103
Posted Wednesday, October 26, 2011 2:52 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, June 6, 2014 2:18 PM
Points: 843, Visits: 2,559
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
Posted Wednesday, October 26, 2011 3:06 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, January 6, 2014 11:35 PM
Points: 75, Visits: 262
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
Posted Wednesday, October 26, 2011 3:24 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, June 6, 2014 2:18 PM
Points: 843, Visits: 2,559
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
Posted Wednesday, October 26, 2011 3:31 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, January 6, 2014 11:35 PM
Points: 75, Visits: 262
Here you go ..

  Post Attachments 
SSISTest.zip (11 views, 22.35 KB)
Post #1196137
Posted Wednesday, October 26, 2011 3:47 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, June 6, 2014 2:18 PM
Points: 843, Visits: 2,559
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
Posted Wednesday, October 26, 2011 4:07 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, January 6, 2014 11:35 PM
Points: 75, Visits: 262
It is working with DB tables as well.
Let's wait for the original poster to respond.....

Post #1196153
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse