I'm assuming that your column [START DATE] is what determines the order on a Per Id basis;
here's soemthing i slapped together, does this get you closer?
i had to...

the browser service helps application sort out the right place to connect.

so assume that something is connecting with a connection string like this, and your sole SQL server...

I'm a bit confused by what you mean when you say "Not sending data" when connecting via a port vs working file when using a named instance. i would expect...

are you sure you've assigned a static port in the SQL configuration manager?
The SQL Browser Service tells incoming connections to your instances which port to use, whether it's static...

i think your group by needs to round the timestamp to your interval of  20 seconds(DATEPART(SECOND, datetimestamp) %20, i think?)  or at least to the nearest minute, which is a...

I've seen far too many SSAS experts leave out foreign keys in the sources they build to fill the cubes,because they think the source it's coming from already has referential...

COPY or MOVE? there's a difference!
copy duplicates the data, so you have to script all the objects out, change the schema in that script , and create the objects...

is your file name you are writing to dynamic? Did you modify your flat file destination to have an expression that points to what the dynamic file name should be?

you said I opened a new query window and ran this:

select convert(nvarchar(64),context_info())

the context_info is session specific, similar to a temp table.
so if i call a...

duplicate post.
no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.
the "Latest Posts" link shows us everything.
continue...

the classic way would be to use GROUP BY HAVING count >  1

SELECT
Col1,Col2,Col3,Col10Or12
FROM
YourTable
GROUP BY Col1,Col2,Col3C,Col10Or12
HAVING COUNT(*) >...

if you can modify the stored procedure, you could populate the VARBINARY(128) CONTEXT_INFO property.

that value is session based, i believe, so if the application calls a proc, and...