Pivoting does not seem to be working for me. Can someone please assist me

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,

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

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...

Koen, is this data sufficient?

File sample data:

col1 col2 col3 col4 COL5

1.22 1.2475 1.395 ...

This will not work because the excel column header is a row in the table. For instance, the 160 column header is the same as the 160 rows in ...

Thank you guys for responding.

The spreadsheet has 160 columns with one row for each column. The destination table has a primary key called "ID" which is not on the spreadsheet....

In my organization we stay away from accessing tables directly, so instead we use views. For instance, if we want to create a database based on data from a table/tables...

Thanks Jeff. I ahve a presentation ready to sell Syninyms to the rest fo my team.

Thank you all for your responses!!

We are trying to stay away from linked servers. Alos we have a policy to to directly access the tables in the other databases and that is why we use...

Can traces also be used to monitor the windows environment?

I want to audit the changes made on our servers by those with administrative rights in our group. This includes both the SQL and Windows environments. Need to...

Can i get a sample powershell script that outputs the result of a stored procedure run by a sql job

This code does not show the result of the query within the stored procedure