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

ssis package for loading excel sheet with diff no of columns Expand / Collapse
Author
Message
Posted Tuesday, November 20, 2012 12:10 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 30, 2013 9:11 AM
Points: 3, Visits: 14
hai,
can anybody tell me how to load the excel with diff columns
ie i have global , region, cluster, market
what i need is want to load the all four columns data into one

any ideas
please

thnaks

Post #1386702
Posted Tuesday, November 20, 2012 6:31 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, November 24, 2014 12:12 PM
Points: 1,219, Visits: 1,263
mohmad.shaik 7313 (11/20/2012)
hai,
can anybody tell me how to load the excel with diff columns
ie i have global , region, cluster, market
what i need is want to load the all four columns data into one

Not exactly sure what you're asking. Are you saying you have four columns and you'd like them to be in one column? If so, you can use the Unpivot transformation to put these into one column.

Rob
Post #1386884
Posted Tuesday, November 20, 2012 7:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 30, 2013 9:11 AM
Points: 3, Visits: 14
hai can you explain how
those are in hierarchy global has region has cluster has market


thanks.
Post #1386891
Posted Tuesday, November 20, 2012 8:20 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, November 24, 2014 12:12 PM
Points: 1,219, Visits: 1,263
mohmad.shaik 7313 (11/20/2012)
hai can you explain how
those are in hierarchy global has region has cluster has market


Are you saying that you have four seperate worksheets? I'm really not following you. If you have four spreadsheets, you can use four seperate OLE source transformations and use a Merge or Merge Join transformation to bring these all together. The write out to a single OLE destination.

I have a feeling I'm not understanding the whole issue,
Rob
Post #1386945
Posted Tuesday, November 20, 2012 8:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 30, 2013 9:11 AM
Points: 3, Visits: 14
not four work sheets
in one work sheet only four columns like Global Region Cluster Market these are inter linked with hierarchies

as Global
Region
Cluster
Market


thanks
Post #1386959
Posted Tuesday, November 20, 2012 9:53 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:12 AM
Points: 5,259, Visits: 12,195
Your answers are confusing. Perhaps if you provided some sample data and details of where you want it to go it would clarify things.


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 #1387017
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse