How can I use parameters in a connection file manager and source in ssis 2015 to load 2 different file definitions
Posted on 2016-10-31
How can I use parameters in a connection file manager and source in ssis 2015 to load 2 different file definitions with variable names from the same directory into sql server.
I want to define connection managers, parameter(s), file sources, and for each loop to load 2 different .txt file definitions into sql server.
the 2 different defintions are a seperate files named with a date time stamp at the trailing end of the file name:
def1 = posdef<dtstamp>.txt
def2 = posdef2<dtstatmp>.txt
both files are loaded to the same directory periodically.
I don't understand how to implement a combination(s) of params to account for varaible file names and different definitions to load using for each loop(s) to load into different tables in an ssis package