Write a CTE that numbers the rows, partitioned on the values of the single column, then delete from that CTE where the row number is greater than 1.

John

I would leave that to your presentation layer, if I were you.  Excel and SSRS will both present the data in the form you're looking for very easily.  What happens...

So is it OK now?  I can't explain why it happened.  At first I thought maybe it didn't upgrade all the components, but then I noticed that in the original...

This does everything in one go; from there you can create and/or populate your table accordingly.

DECLARE
     @RowCount bigint
,    @Schema sysname = 'TempTest'
,    @Table sysname...

Jonathan

What happens if you set the DelayValidation property of the connection manager to True?  If that doesn't work, you could set the connection string property with an expression...

That can't be the whole script.  I need to see everything, please, including where you're assigning values to those variables.  And you still haven't answered how you're actually doing this.  Don't...

Mmmm... not much good without the actual parameter values, I'm afraid!  But as Adi and Phil have suggested, try unduplicating those backslashes in your file path(s).

John

Post your CREATE DATABASE statement, please.  If you're doing it through the GUI (which I don't advise), click on the Script button in the New Database window.

John

Is it an upgrade, or a new install?  This is my guess: you wanted to upgrade from 2014 to 2016, but you put Install instead of Upgrade in your config...

Raj

You're wrong, I think.  If you have two dates that you need to compare, you need to make sure they can both be converted to datetime.  The lesson...

Use the STUFF function to make your string look like this: '20140626 19:08:25'.

John