Hi Jeffrey,

Thank you for your reply!  🙂  WinSCP is what I was looking to use when I started this whole process but I was asked to look into the PowerShell...

Here is a screenshot in SSIS

Hi Phil,

Yes, I meant better 🙂  Thanks for the feedback.  I'm just trying to get a feel of what people are using out there and confirm if WinSCP is a...

Thank you for your reply!  That is very helpful 🙂  I need to run this purge job once a week but unfortunately I don't know how many rows it will...

Hi,

Thank you for the information.  I will look at both the links you provided and keep digging. 🙂

Hi Phil,

Thanks for your reply!  So does Visual Studio not work with sftp?  Right now the SSIS package just has the ftp setup with the connection manager and it works...

That worked perfectly!  Thank you again. 🙂

Hi,

So I was able to change the email address but struggled on how to deploy the changes to PRD.  The SSIS packages are not stored in the server so there...

Hi,

Thank you!  I was able to see he was using a package configuration for his email and was able to make the change successfully.  I appreciate your response.  🙂

Hi Scott,

Thank you!  That worked perfectly 🙂

Thanks for all the feedback.  I will test these suggestions as well...always good to learn new things!  You guys are awesome 🙂

Well, that certainly did it.  Thank you Lynn...I never would have thought to use the STUFF command. 🙂

(No column name)
2018-02-09 16:51:17:00
2018-02-09 16:51:17:00
2018-02-09 16:51:17:00
2018-02-09 16:51:17:00

Hi,
Thank you for that info.  One of the first things I checked was to make sure each server had AlwaysOn still enabled.  We noticed this message in the logs:

Hi,
Based on the fact that it looks like two completely different queries are running for TST and Production, I went ahead and restored the Test database to the 2016...

Hi,
The query is coming from an application so I have no control over how it is written and I cannot modify it.  I am using the same exact query on...