Viewing 15 posts - 1 through 15 (of 138 total)
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...
June 21, 2021 at 3:40 pm
Here is a screenshot in SSIS
June 18, 2021 at 9:19 pm
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...
April 20, 2021 at 5:47 pm
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...
December 4, 2019 at 10:01 pm
Thank you for the information. I will look at both the links you provided and keep digging. 🙂
November 13, 2019 at 10:02 pm
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...
November 13, 2019 at 8:10 pm
That worked perfectly! Thank you again. 🙂
June 21, 2019 at 5:48 pm
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...
June 19, 2019 at 9:47 pm
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. 🙂
June 5, 2019 at 4:22 pm
Thank you! That worked perfectly 🙂
March 6, 2019 at 1:07 pm
Thanks for all the feedback. I will test these suggestions as well...always good to learn new things! You guys are awesome 🙂
March 14, 2018 at 9:48 am
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:002018-02-09 16:51:17:002018-02-09 16:51:17:002018-02-09 16:51:17:00
March 13, 2018 at 4:37 pm
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:
March 12, 2018 at 6:00 pm
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...
February 16, 2017 at 5:31 pm
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...
February 15, 2017 at 3:59 pm