February 23, 2012 at 2:04 pm
I have basic knowledge of SSIS on how it works, i got an assignment where in i have to generate data into flat files from SQL Server Database.
Precisely, I have 8 tables in a db. My requirement is to generate 8 flat files ( 1 flat file per table) with full data and save these files over the network. InStraight, i can do this task.
What i wanted is how to do XMl configurations for DB connection and 8 flatfiles locations.
This way, it would be easy for me to change the server connection and path and filename of the 8 flat files when move from one environment to another.
hope you understand my issue?
Jus
February 23, 2012 at 3:33 pm
Actually that is really straightforward. Based on these assumptions:
1. You have one DB connection for the source (regardless of the number of tables at that source).
2. You have a flat-file connection for each file.
Depending on how complex you want to go you can and need to go you can do it with a single dtConfig file that contains 2-9 configuration settings. No problem.
The number depends on the complexity. If you go straight out then you have 9 settings, 1 for the source and one each for the destinations. If all the files go to the same place and their names are not gonna change then you can probably go for a somewhat more complex option that reduces the stored settings to 2. In that case you are storing the source connection and a variable that contains a path which would then be used in an expression to set the flat file location.
How do you want to proceed?
CEWII
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply