Try right-clicking on the Payroll.dtsx package. You should see the option 'View Designer' – select that.

Is the package part of an SSIS project? It needs to be. Open the project in SSDT and then open the package.

Temp tables: instead of

declare @table table (id int)

use

create table #table (id int)

Unfortunately, that error file does not shed much light on the problem!

I can suggest some things to try:

1. Try deploying to a local database instance
2. Make sure that all packages...

Note to OP: Please click the Insert/edit code sample button when adding code to your posts, it's really not difficult to use.

I've attached the failure to this post.

I cannot see it.

Phil,

Yes, there won't be any duplication in the file within itself because of the unique values(username).

However, regular importing the same CSV file with older data and new data, will...

If the key is unique, how can there possibly...

What do you mean by 'unique values'?

The...

What do you mean by 'continuous record-appending file'? Is this a file which just keeps on growing forever? I'd be looking quite vigorously for a way to avoid that, because...

Is the user a member of the ssis_admin role in SSISDB?

Are you using a Windows login to perform the deployment? SSIS does not like SQL logins much.

Regarding your question about column names, have you considered creating a text file which contains (only) your desired column names as headings (which match the names in your target table)...

I did not quite understand your suggestion about the Data Conversion component for the columns.  I am getting CSV files with hundreds of columns.  Are you suggesting that I...

Unfortunately, the short answer is 'no and no', to the best of my knowledge.

Regarding your second point, the 'pure' SSIS way of handling this is to send all of the...