NigelRocks
asked on
SSIS File Import by Directory
Experts,
I have an SSIS packae that imports a flat file into a database. I'm wondring how I might improve it so that it can append several flat files from one directory into the same database table in one fell swoop. These files are not named similarly, but they do have the same extension.
I have an SSIS packae that imports a flat file into a database. I'm wondring how I might improve it so that it can append several flat files from one directory into the same database table in one fell swoop. These files are not named similarly, but they do have the same extension.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Not really. I awarded points the last time we visited this because I'm tired of being harassed by this site every time I have a question that's 5 seconds overdue. I wondered if this would be different because I was not going to give the files any name, nor was I going to use any variables.
The short answer is that you set up the container, point to a directory with the files, and then drag and drop a data flow task into the container that writes one of the files into a table.
For someone new to this paradigm, describing setting up a data flow task inside the container would lead many to double-click the container and look for prompts that allow this. I realize now this is not the case.
I have it working fine with the simple drag and drop steps outlined above. Where do variables come in? I didn't see any reason to set up any variables.
The short answer is that you set up the container, point to a directory with the files, and then drag and drop a data flow task into the container that writes one of the files into a table.
For someone new to this paradigm, describing setting up a data flow task inside the container would lead many to double-click the container and look for prompts that allow this. I realize now this is not the case.
I have it working fine with the simple drag and drop steps outlined above. Where do variables come in? I didn't see any reason to set up any variables.
ASKER