SSIS Part II
-
Before, I had problems when I try to execute my SSIS package to SQL Job. I've tried using different approach. I used batch file (executed in SQL Job) to connect to a remote server, then copy a file (thru psftp). With this, my command line needs to open another file that contains my original psftp command. This is the example of command-line from my batch file
psftp -i C:\OpenSSH\etc\myPublicKey.ppk myusername@hostname -b D:\getFile.ftp
This is my psftp command
get fileFromServer.sdf D:\fileFromServer.sdf
Example: getFile.ftp (contains the 'get' command which will the psftp do) After using batch file (which didn't work, too) I tried putting my psftp command to another filename (from getFile.ftp to getFile1.ftp) It worked! Now, I can say that SQL Server 2008 R2 really has some issues when it comes to names. :doh: Curse you SQL Server 2008 R2! :mad:
Don't mind those people who say you're not HOT. At least you know you're COOL. I'm not afraid of falling, I'm afraid of the sudden stop at the end of the fall! - Richard Andrew x64
-
Before, I had problems when I try to execute my SSIS package to SQL Job. I've tried using different approach. I used batch file (executed in SQL Job) to connect to a remote server, then copy a file (thru psftp). With this, my command line needs to open another file that contains my original psftp command. This is the example of command-line from my batch file
psftp -i C:\OpenSSH\etc\myPublicKey.ppk myusername@hostname -b D:\getFile.ftp
This is my psftp command
get fileFromServer.sdf D:\fileFromServer.sdf
Example: getFile.ftp (contains the 'get' command which will the psftp do) After using batch file (which didn't work, too) I tried putting my psftp command to another filename (from getFile.ftp to getFile1.ftp) It worked! Now, I can say that SQL Server 2008 R2 really has some issues when it comes to names. :doh: Curse you SQL Server 2008 R2! :mad:
Don't mind those people who say you're not HOT. At least you know you're COOL. I'm not afraid of falling, I'm afraid of the sudden stop at the end of the fall! - Richard Andrew x64
-
Before, I had problems when I try to execute my SSIS package to SQL Job. I've tried using different approach. I used batch file (executed in SQL Job) to connect to a remote server, then copy a file (thru psftp). With this, my command line needs to open another file that contains my original psftp command. This is the example of command-line from my batch file
psftp -i C:\OpenSSH\etc\myPublicKey.ppk myusername@hostname -b D:\getFile.ftp
This is my psftp command
get fileFromServer.sdf D:\fileFromServer.sdf
Example: getFile.ftp (contains the 'get' command which will the psftp do) After using batch file (which didn't work, too) I tried putting my psftp command to another filename (from getFile.ftp to getFile1.ftp) It worked! Now, I can say that SQL Server 2008 R2 really has some issues when it comes to names. :doh: Curse you SQL Server 2008 R2! :mad:
Don't mind those people who say you're not HOT. At least you know you're COOL. I'm not afraid of falling, I'm afraid of the sudden stop at the end of the fall! - Richard Andrew x64
Karen Mitchelle wrote:
Curse you SQL Server 2008 R2!
There, doesn't that feel better now? :-D :-D Good rant!
Will Rogers never met me.
-
Before, I had problems when I try to execute my SSIS package to SQL Job. I've tried using different approach. I used batch file (executed in SQL Job) to connect to a remote server, then copy a file (thru psftp). With this, my command line needs to open another file that contains my original psftp command. This is the example of command-line from my batch file
psftp -i C:\OpenSSH\etc\myPublicKey.ppk myusername@hostname -b D:\getFile.ftp
This is my psftp command
get fileFromServer.sdf D:\fileFromServer.sdf
Example: getFile.ftp (contains the 'get' command which will the psftp do) After using batch file (which didn't work, too) I tried putting my psftp command to another filename (from getFile.ftp to getFile1.ftp) It worked! Now, I can say that SQL Server 2008 R2 really has some issues when it comes to names. :doh: Curse you SQL Server 2008 R2! :mad:
Don't mind those people who say you're not HOT. At least you know you're COOL. I'm not afraid of falling, I'm afraid of the sudden stop at the end of the fall! - Richard Andrew x64
Where's Part I ? Is it your post from 11-Jul-14 0:13 ?
Karen Mitchelle wrote:
I had problems
That doesn't tell us much.
Karen Mitchelle wrote:
SSIS package
That says quite a bit.
You'll never get very far if all you do is follow instructions.