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

if the referenced table has a specific column name (in the example [StatisticsName]), this will find all objects that are referencing the object(ie table) in question.

...

using row number is how i would find the dupes.
the query i'm using here can be switced to a delete by simply swapping the commenting the --DELETE and commenting...

you can end up getting the empty  "toolbox" from visual studio, which IS NOT THE SAME as the ssis toolbox.
there's always a shortcut for the SSIS toolbox and SSIS variables...

I think the Flat File Connection Manager will create a...

you said it occurs when the package is run on the server, by the proxy or service account, right? or by another, specific user.....

check the permissions on the...