issue resolved.  please ignore post.

• This reply was modified 3 years, 8 months ago by water490.

good points.  Thank you for that.

No problem

The script looks for a particular text within the SFTP files.  I made a typo so that is why it would not find the files I was testing.  I...

i figured out the issue.  ignore post.

• This reply was modified 3 years, 8 months ago by water490.

one more thing ...

I am using Powershell but I am definitely open to using other tools like C# etc.  I just need a way to access that one button.  The...

it is definitely a desktop.  workload is running queries against DB and making updates to DB by writing new data.  way more reads than writes. the only write is updating...

You mean...

You mean a...

Thanks Michael and Jeff.  I will do more research on this.

Thanks for the links.  I read them over.  This raises some questions and I need to better understand this. ...

• This reply was modified 3 years, 8 months ago by water490.
• This reply was modified 3 years, 8 months ago by water490.

I used powershell to create a script that prepares the files for bulk insert.  it ensures that the columns match with the destination table.  works beautifully.

SQL Server does not all "FROM @FILENAME", only "FROM 'data_file_name'".  Google the syntax of the command.

You'll need to use dynamic SQL if you want to feed in...

SQL Server does not all "FROM @FILENAME", only "FROM 'data_file_name'".  Google the syntax of the command.

You'll need to use dynamic SQL if you want to feed in a FROM...

the bulk insert options you used were just a sample - you needed to adjust to your own needs.

you also can't have extra columns on the destination table -...

There is one extra column in the table that is not found in the csv but I was able to import the file using Import Data wizard.  I also removed...