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

  • Question

  • Hi Team 

    I need to upload  .txt file from server path like \\00.00.00.00\[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

Answers

  • 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

    http://www.mssqltips.com/sqlservertip/2874/loop-through-flat-files-in-sql-server-integration-services/

    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.


    Arthur

    MyBlog


    Twitter

    Friday, January 30, 2015 2:32 PM