Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««12345

SSIS & Environment Variables Expand / Collapse
Author
Message
Posted Monday, March 18, 2013 5:20 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, September 4, 2014 6:14 PM
Points: 39, Visits: 86
One more question:

if a package runs successfully i want to move that package from that path automatically or it may be renamed.By doing this i believe this would eliminate the issue which i reported earlier.Because my master package will execute all the packages in the mentioned path and those packages which start with "T."
Is there a way that i can do it.
Post #1432405
Posted Tuesday, March 19, 2013 2:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, March 19, 2013 11:32 AM
Points: 3, Visits: 10
Do you have a definitive number of packages. If not, then execute each one in series connecting each one via an Success constraint. If one fails it should fail the parent package and the checkpoint will record the last point of execution.

Possibly, a foreachloop is not what you should be using.
Post #1432523
Posted Tuesday, March 19, 2013 10:50 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, September 4, 2014 6:14 PM
Points: 39, Visits: 86
i have around 140 packages
Post #1432778
Posted Friday, June 6, 2014 5:36 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 7:36 AM
Points: 5, Visits: 22
Using configuration in SSIS package is quite simple, Recently i created a document on enviornement variable type configuration, I tried to make it as prominent as possible -

This article is all about environment variable, Check here for more detail
Post #1578248
« Prev Topic | Next Topic »

Add to briefcase «««12345

Permissions Expand / Collapse