But where did you get confused in the article? I assume you want a dynamic pivot, which the articles do explain.

Good day

sidlfc08,

I would like to do the same condition ( transposing date column to rows )

Can you please share with me your query statement to solve your initial question.

I...

You've not set the connectionstring property to be an expression, you've set it to be literally the value Provider=Microsoft.ACE.OLEDB.12.0;Data Source=@[User::IntegrationFile].xlsx;Extended Properties="EXCEL 12.0 XML;HDR=YES";, and your file path to be literally...

That sentence honestly makes no sense and doesn't explain anything. To repeat myself:

Explain...

Images of data aren't going to help us help you. Post the data as DDL and DML statements. Also explain the problem, what are you expected results here? What have...

Yep, start

Shifting gears a bit... the following message started showing up on my machine some time ago (seems like at least a week) on every post thread and ONLY...

Honestly, I'd suggest doing this in the presentation layer. In, for example, you are in SSRS you could use an expression like this:

=StrConv(Fields!YourColumn.Value, vbProperCase)

C# has the string...

Looks like an SQL question.  Suggest you post in the appropriate forum, trim down your request, provide some sample input and output data that someone can just run to...

Did you have to post this four times...? I thought 3 times in the same sub-forum was bad enough, but 4 times? Now I don't know if you want a...

Assist with what? You've posted this in the SSIS forum, so are you looking to pivot the data using SSIS? Where did you get stuck? Posting the topic 3 times...

Duplicate post of https://www.sqlservercentral.com/forums/topic/pivot-split-column-2, which is a duplicate post of https://www.sqlservercentral.com/forums/topic/pivot-split-column.

Duplicate post of https://www.sqlservercentral.com/forums/topic/pivot-split-column.

You could use the ReportingServicesTools Module for Powershell (note it doesn't work in Powershell 6). I don't know what the layout of your Folders are, but getting the entirety...

I assume, therefore, that none of your reports aren't already in an SSRS project? If so, how are the existing reports maintained? What happens when someone asks for a change...

Why did you post in the SQL Server 2016 forum then? 2008 has been completely unsupported since mid...