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 ««12

SSIS Expand / Collapse
Author
Message
Posted Friday, July 26, 2013 1:38 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:52 AM
Points: 13,364, Visits: 11,145
wanox (7/26/2013)
Koen, is this data sufficient?


I'll have a look later. I have to go to work now




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 #1477893
Posted Friday, July 26, 2013 1:42 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:45 AM
Points: 5,430, Visits: 10,104
You haven't shown what the data in your table looks like, but I think I can picture it.

It looks as if you have three options:

(1) Pivot in Excel then load directly into the table
(2) Pivot as part of your data flow and load directly into the table
(3) Load into a staging table, then do a T-SQL PIVOT into your table

John
Post #1477895
Posted Friday, July 26, 2013 2:12 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 9, 2013 9:48 AM
Points: 34, Visits: 224
I cannot pivot in excel (source data).
I have tried to pivot as part of my data flow and have not been successful. Can you help me out here please
The data in the table looks like this:
ID Date Value
10 getdate() 1.357

The ID is generated by running a query to select name from another table where name matches the column name on the spreadsheet.
Post #1477899
Posted Friday, July 26, 2013 3:08 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:52 AM
Points: 13,364, Visits: 11,145
wanox (7/26/2013)
I cannot pivot in excel (source data).
I have tried to pivot as part of my data flow and have not been successful. Can you help me out here please
The data in the table looks like this:
ID Date Value
10 getdate() 1.357

The ID is generated by running a query to select name from another table where name matches the column name on the spreadsheet.


Can you post a few more lines of sample data and the desired output?




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 #1477911
Posted Friday, July 26, 2013 5:40 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 9, 2013 9:48 AM
Points: 34, Visits: 224
This is a sample of data destination:
SourceRateID RateDate EnteredDateTime Value
1 7/25/2013 00:00.0 0.0005
2 7/25/2013 00:00.0 0.0013
3 7/25/2013 00:00.0 0.0027
4 7/25/2013 00:00.0 0.0037
5 7/25/2013 00:00.0 0.0042
10 7/25/2013 00:00.0 0.225
11 7/25/2013 00:00.0 0.225
12 7/25/2013 00:00.0 0.225
13 7/25/2013 00:00.0 0.225
14 7/25/2013 00:00.0 0.225

This is sample of source excel file:
onemoaccept twomoaccept threemoaccept sixmoaccept twelvemoaccept cadprime twoyrtreas
1.22 1.2475 1.275 1.395 1.6 #NAME? 1.15


Thanks
Post #1477951
Posted Friday, July 26, 2013 6:53 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 9, 2013 9:48 AM
Points: 34, Visits: 224
This is the correct source file sample:
RateDate onemoaccept twomoaccept threemoaccept sixmoaccept
7/24/2013 1.22 1.2475 1.275 1.395

I'll try pivoting this file, now that I have a RateDate column and keep you posted.

Thanks,
Post #1477978
Posted Friday, July 26, 2013 7:41 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 9, 2013 9:48 AM
Points: 34, Visits: 224
Pivoting does not seem to be working for me. Can someone please assist me
Post #1478008
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse