Link to home
Start Free TrialLog in
Avatar of guitardg
guitardgFlag for United States of America

asked on

SSIS Combine projects into one

Hello,

I have multiple SSIS projects that have been developed to provide checking information to various banks in the form of csv files from a SQL database.  Each project is self contained and functions very similarly to each other.

Steps:
1. Run a SQL Task to retrieve bank account numbers
2. For Each Loop container With Data Flow.
3. Data Flow = SQL Task to format check register information into specific bank provided schema, export to Flat file and save in a specific directory with a specific naming convention.
4. SFTP Client to send files to bank for import.

We have added banks along the way and now that we have 5 or so I want to use one stored procedure and call the different formats based on the bank.  I have the sproc with IF statements to identify the bank format and it runs as expected.  Now, I need to have the sproc run in (I assume) another for each loop prior to the main routine in order to determine which format to apply but I'm having a hard time wrapping my head around the process.

There are other issues I need to deal with such as picking the correct subdirectory to place the flat file in based on the bank but I want to start by getting the control flow consolidated first.  Any help is much appreciated.

Thanks,
ASKER CERTIFIED SOLUTION
Avatar of Megan Brooks
Megan Brooks
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of guitardg

ASKER

Thanks for confirming Megan.