I found this article online that looks like it does looping through column values.  Is this what I need to do?  I would replace the runningtotal with the bcp command

Here's a post from Erland Sommarskog... passing parameter to stored procedure in bcp command

then all you'd have to do is loop over the list of values to pass into...

I have another question.  In my example I used header1 values to break up the main table into smaller tables.  If I use a parameterized stored procedure to process it...

that is looking promising.  They give an example:

bcp "SELECT FullName, PreferredName FROM WideWorldImporters.Application.People ORDER BY FullName" queryout D:\BCP\People.txt -t, -c -T

Can the file name "D:\BCP\people.txt" have a...

Thank you for the feedback.  I will definitely test it out to make sure it does what I hope it does.  Thanks again for your help!

I found this article on microsoft website.  Is this what I need to do?

https://docs.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqltransaction.rollback?view=dotnet-plat-ext-6.0

I am a rookie so I need some guidance to make sure I am doing...

issue resolved.  please ignore post.

• This reply was modified 2 years, 9 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 2 years, 9 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.