I don't know how we can help you any further - I have provided several links on how to setup the command line for dtexec.  The examples are very clear...

It is good that you are able to get the processing down to 15 seconds...but I am concerned at the cost that will have on maintenance of this solution.  The...

I think you missed the new AutoAdjustBufferSize setting - this setting should auto adjust the buffer size as needed instead of you having to figure it all out.

Looking at what...

This is really a DB2 question - from a quick search I found this int(to_char(current date - 2 days, 'YYYYMMDD')) which you should be able to adapt in your where...

Before applying a CU or SP in *any* environment - make sure you have good backups of all databases.  If you ever do run into an issue with a patch...

It still isn't clear what you are trying to accomplish - your explanation is saying you want to copy powershell to another server...why?  Powershell should already be installed on the...

This would be much better as a daily/weekly report - that you can then take action on if there are new sysadmin accounts.  There are other accounts besides sa that...

The first step would be to list the logins that are a member of the syadmin role - to get that you query sys.server_principals and sys.server_role_members:

 Select...

It is not clear what your expected results are - can you show what you expect given the example data you provided?

What are the batch/commit settings on the destination?  If those are default - set them to a reasonable amount and see if that improves the performance any.  In some cases...the...

You are aware that you can create an agent job that runs in the powershell sub system?  Using that - you can easily setup a job to run on a...

Either works - I guess...but then again I have SSISDB and that has changed a whole lot of the requirements for config files/tables.  In fact - moving to a project...

Not sure why you are 'copying' powershell to another server - Powershell is a command line utility that should be installed on the servers and updated to the version you...

I would recommend that you switch over to project deployment - build out the integration services catalog - and deploy your packages to the catalog.  You can then use the...

Do you want to just exclude the rows that do not have a '-' in them?  Or do you want to return something different - or some other value?

Just to...