Sample Header Ad - 728x90

Run SSIS Package but the package path will be decided runtime

0 votes
1 answer
386 views
I have to import 16 Excel files into 16 tables through agent. The agent will process the data further. I have created a SSIS package for each . I don't want to create 16 jobs to do same steps. My idea : 1. Pass the SSIS package to Job (Looping the path in procedure and call the job) 2. Once the data is imported , on success / failure : different steps will be processed . 3. Once success , the next Package will be processed (Step 1) Can this be done without Bulk Insert
Asked by Lakshmi R (119 rep)
Feb 6, 2023, 10:30 AM
Last activity: Apr 23, 2025, 02:05 AM