Post reply

Ssis import file

  • October 15, 2014 at 3:12 pm

    #300232

    Hello Gurus - I need to import a csv file into a Sql server table. The issue is the file name structure changes from day to day. Here is a sample of the file structure: \\Server\share\reports\Oct152014\test03-15-58\Recently Created Users.csv

    The bolded folder names change from day to day and we only run this once a day. This is the date Oct152014 folder and this is the time test03-15-58 folder. Next month this folder Oct152014 would change to Nov12014 on November 1st.

    Any help would be greatly appreciated.

    Thanks.

  • October 15, 2014 at 4:28 pm

    #1752700

    There should be a way to do it completely in SSIS, but you could create a table in SQL Server to query the correct path according to your dates.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • October 16, 2014 at 1:38 am

    #1752748

    You need to use expression on your flat file connection manager.

    Dynamically set Flat File Connection Manager

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply