Home Forums Article Discussions Article Discussions by Author Discuss content posted by Stan Kulp No SFTP Task Component in SSIS 2005/2008? No Problem! RE: No SFTP Task Component in SSIS 2005/2008? No Problem!

  • May 11, 2010 at 8:08 am

    #1165565

    Good article.

    Having that username/password in a batch file is an issue. If (for any reason, like the FTP server is down) the package fails, that file could be left behind, and then anyone could see it. You might be deleting it in the last step, but if the package fails before that step then that last step won't get run.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2