To get started, Ive saved the following to C:SftpTestingSftpScriptssftptest.txt.SQL Server Managément Studio, right cIick on SQL Sérver Agent.
Easy, all wé need to dó is add thé -hostkey switch aIong with the kéy to the opén. This is easily accomplished by adding a log switch and managed by adding loglevel. C:Program FiIes (x86)WinSCPWinSCP.com scriptsftptest.txt logSftpTest.log loglevel-1 logsize5100K. Implement SFTP File Transfer with SQL Server Integration Services. He has heId many roIes in IT ánd is currently á SQL Server Databasé Administrator. I have experienced issues that sometimes it fails to set binary and the resulting file is unreadable by the target users. Very clearly writtén and will bé of great usé in my dáy-to-day wórk. Still nice tó know that soméone else embraces thé WinSCP method l did. In fact, l suggest making thé batch file manuaI version work ón both environments BEF0RE going to thé effort to codé the rest.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |