Link to home
Create AccountLog in
Avatar of Srirampriya
SrirampriyaFlag for India

asked on

Creating SSIS package dynamically using Stored Procedure

Hello

I have a requirement to create dynamic SSIS packages using sp's. this is due to the fact multiple databases will be create dynamically and each Dynamic SSIS package needs to be attached to one DB.

or some script which can do this, I have little exp in scripting

Please share your thoughts

Regards
Avatar of Saurabh Bhadauria
Saurabh Bhadauria
Flag of India image

Why don't you Create a single package and create your DB connection string expression based ..

Through this  you can pass your Database name as parameter dynamically...


Or your purpose is to attach a similar package to each dynamic database  then this also achievable in same way.....
Avatar of Srirampriya

ASKER

Can this then run multiple packages dynamically?
Running multiple package dynamically is possible but it depends how you want to run ?

One way is Wrap all packages with in a parent package and execute parent package.
as suggested by you, if I update dynamically the connection string pointing to a DB execute and immediately update the connection string pointing to another DB will bot run parallely
There is one single SSIS package
ASKER CERTIFIED SOLUTION
Avatar of Saurabh Bhadauria
Saurabh Bhadauria
Flag of India image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account