SSIS & Environment Variables

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » SSIS & Environment Variables

43 posts, Page 5 of 5

«««1 2 3 4 5

SSIS & Environment Variables

Rate Topic

Display Mode

Topic Options

Author

Message

nishav2

Posted Monday, March 18, 2013 5:20 PM

Grasshopper

Group: General Forum Members
Last Login: Friday, May 17, 2013 2:51 PM
Points: 19, Visits: 31

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

Drndrb

Posted Tuesday, March 19, 2013 2:32 AM

Forum 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

nishav2

Posted Tuesday, March 19, 2013 10:50 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, May 17, 2013 2:51 PM
Points: 19, Visits: 31

i have around 140 packages Sad

Post #1432778

« Prev Topic | Next Topic »

43 posts, Page 5 of 5

«««1 2 3 4 5

Permissions