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

This is the correct source file sample:

RateDateonemoaccepttwomoacceptthreemoacceptsixmoaccept

7/24/20131.221.24751.2751.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:

SourceRateIDRateDateEnteredDateTimeValue

17/25/201300:00.00.0005

27/25/201300:00.00.0013

37/25/201300:00.00.0027

47/25/201300:00.00.0037

57/25/201300:00.00.0042

107/25/201300:00.00.225

117/25/201300:00.00.225

127/25/201300:00.00.225

137/25/201300:00.00.225

147/25/201300:00.00.225

This is sample of source excel file:

onemoaccepttwomoacceptthreemoacceptsixmoaccepttwelvemoacceptcadprimetwoyrtreas

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