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
Last activity: Apr 23, 2025, 02:05 AM