SQLTeam.com | Weblogs | Forums

One SSIS Package with 2 Stored Procedures


#1

How do I add second Stored Procedure on the existing SSIS package? This new Stored Procedure is using the same data source but I am not sure how do I add on the currect SSIS Package.

Anyone know?


#2

What are you doing with the first stored procedure? Are you just executing it? If so, just drag another Execute SQL Task over and add the stored procedure to it. If it's using a data transformation instead, then you need to add that.

We need more info in order to help you.


#3

Hello Tara,

I figured it out. Basically what I did just add the sequence container. Thanks Tara for your responded.