Scott Abrants (5/24/2016)

---

Remember in-order to execute the script that executes the SSIS package you need to be logged into that SQL Server as a Window's Account - SQL Server accounts...

Jack Corbett (3/14/2016)

---

hjp (3/14/2016)

---

Thank you for an interesting article. I find it less useful, though, when you rely on two assumptions:

1. SQL Authentication (and the willingness to store...

hjp (3/14/2016)

---

Thank you for an interesting article. I find it less useful, though, when you rely on two assumptions:

1. SQL Authentication (and the willingness to store credentials in plaintext in...

hjp (3/14/2016)

---

Thank you for an interesting article. I find it less useful, though, when you rely on two assumptions:

1. SQL Authentication (and the willingness to store credentials in plaintext in...

Jeff Moden (3/14/2016)

---

Good article but, is there any way around this major security violation???

6. Modify the configuration file to change the server name and [font="Arial Black"]user name and add the...

tskelley (3/14/2016)

---

Is there a reason you chose 64-bit instead of 32-bit? (or is this another article...) In other words, are there circumstances where one is more preferable than...

This article was originally published two years ago when my company was still using XP and when XP was still supported.

I use it...

SilentMike (7/9/2015)

---

Hi Stan

Really useful article, thanks.

I have a question around the long term use of this solution. I've done a bit of testing and the subscription still seems to work...

I don't really know what to do next.

Here are some links I found while searching for an answer. You might give them a try.

http://sql-articles.com/articles/dba/how-to-schedule-ssis-package/

https://technet.microsoft.com/en-us/library/dd440761(v=sql.100).aspx

http://stackoverflow.com/questions/846135/schedule-ssis-package-execution

Try setting the password for the task as shown in this link:

http://myitforum.com/myitforumwp/2013/01/16/changing-the-password-for-windows-task-scheduler-tasks/

It would be the password you use to log into Windows.

I would first create a batch (.bat) file from which you can run your SSIS package.

The batch file should contain the following command:

DTEXEC /File "C:\Path\MyPackage.dtsx" /CHECKPOINTING OFF /REPORTING D

Replace...

Here is a tutorial on using WinSCP to SFTP in SSIS:

http://www.sanjaykumar.us/index.php/automate-sftp-ssis-part-1-winscp-installation/

khicon73 (5/5/2015)

---

I download the 'SftpScriptTaskDemo.dtsx', also download 'psftp.exe' and placed it in 'C:\psftp\psftp.exe', and imported into my SSIS project. I modified the SFTP's credentials...It run fine, no error but i...

At this point my suggestion would be to get the BatchETL.dtsx SSIS package I wrote for this article working.

If you can't get it working, then there is something wrong...