SSIS - Get info from SQL server table about which particular files will get loaded in target SQL server table

  • Hi all,
    I am struggling with the problem as below.
    "A folder contains many source files (may be excel or text file). Need to create a solution which gets the information from SQL server table about
    which particular file/files will get loaded in target SQL server table".
    Not sure how to pick files whose names match with the names listed in an SQL server table. And then load each file into another SQL table.
    I only know how to load multiple files from a folder to an destination SQL server table.

  • Duplicate post. Answers here please.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

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

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