I suggest you run this: https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver15#ssdt-for-vs-2017-standalone-installer

making sure you select 'SQL Server Integration Services' during installation. I'm not sure whether you have to uninstall your existing SSDT first.

Which version of VS are you using?

Did you install the SSIS extensions after installing SSDT? Take a look

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