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

5 excel file each file contain 5 sheets we want to load into data using single Dtata Flow task Expand / Collapse
Author
Message
Posted Wednesday, July 17, 2013 1:37 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: Wednesday, March 12, 2014 5:45 AM
Points: 967, Visits: 84

Hi All,

My Name is vivek,i have few doubts below any one know to how to resolve please give me advise.

1).I have 5 excel files each file contain 10 sheets and how to load table by using sing DFT,in DFT we need to use single excel source and single destination.Is it possible in SSIS.
2)each file contain country name, i need to load country names from file path's and product names from each sheet name.
3)how to create dynamic files by using variable.

Thanks,
Vivek.
Post #1474413
Posted Wednesday, July 17, 2013 1:47 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:31 PM
Points: 12,239, Visits: 9,212
Let's start with number 1.
Why a single DFT and a single source?
You need at least 50 sources, and preferably not in one single data flow.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1474423
Posted Wednesday, July 17, 2013 2:00 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 10:56 AM
Points: 4,832, Visits: 11,200
There is an example here that might be relevant to you.


Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.
Post #1474426
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse