Upload Text file in sql server through SSIS- Dynamic RRS feed

  • Question

  • Hi Team 

    I need to upload  .txt file from server path like \\\[folder name]\ file name 25-01-2015.txt. [file format]

    File getting creating on server every day.

    Need your inputs on 

    How to copy same file with system date -1 to my local server and then to upload same file sql db.

    Friday, January 30, 2015 10:08 AM


  • Hi developer_rk,

    The approach is to loop through file name(s) set dynamically to the file name value via a SSIS expression.

    Start by looking at http://www.sqlis.com/sqlis/post/Looping-over-files-with-the-Foreach-Loop.aspx and


    What you ask is basics, there are tons of posts on how to do that and if you are new to SSIS I suggest you spend some time learning - it is not as welcoming as it may initially look like.




    Friday, January 30, 2015 2:32 PM