Looks like the ForEach Loop is faulting.

But it is not possible for the file enumerator to continue past the number of qualified files.

I suggest you debug.

Put breakpoints and observe the variable values to determine what makes the package execute indefinitely.

Hi ,

i put breakpoints and checked because of foreach loop its running indefinitely.

how to run all packages without using Foreach loop.

Hmm... Sounds fishy

Is the for each loop itself nested? Is this package called from another master package?

hi visakh,

not this is single package its not called from any package.

for more information, kindly refer the below mentioned link

https://www.simple-talk.com/sql/ssis/executing-ssis-packages-/

you put two breakpoints whereas I asked for one.

The upper loop is suspended though, right?

So what are the variable values?

ya for each loop in process.

the variable are

name  => package to run

scope  => package1

data type => string

value    =>

then i called this variable in for each variable mappings and set index value is 0

in package execute task location is file system then created connection for current package

where scope?

I do not think you followed the blog post you mentioned.

hi arthurz,

is there any other method to run all the packages in a folder , if yes can you please share.

If I were you, I would elect to running them via DTEXEC.exe as a bat file e.g.

dtexec /f "c:\pkgOne.dtsx"
dtexec /f "c:\pkgTwo.dtsx"
dtexec /f "c:\pkgThree.dtsx"

simple and elegant IMO

• Edited by RyanAB Thursday, July 02, 2015 1:57 AM

hi,

i already tried DTEXEC.exe its so nice method, thank you so much for replying me,

in this DTEXEC have to specify package name. instead of each package i want to execute all the packages in a folder

example DTEXEC /f "C:/*.dtsx"  this is not working.

hi RyanAB,

yes the mainpackage is called in Loop.

hi RyanAB,

yes the mainpackage is called in Loop.

hi,

i dont know how to prevent can you explain briefly with screen shot it would be more helpful.

What I'd do, put in an expression task and disable it (it doesn't need to do anything but you need the link that follows)

Connect the expression task to the Execute Package Task

Double click the link to open the Precedence Constraints and add the expression @[User::PackageToRun] != @[System:PackageName]

(might have to be some fiddling there to get them matching)

ryan,

we are using SQL server 2008 R2 , expression task is not available .

ryan,

we are using SQL server 2008 R2 , expression task is not avail

hi,

i already tried DTEXEC.exe its so nice method, thank you so much for replying me,

in this DTEXEC have to specify package name. instead of each package i want to execute all the packages in a folder

example DTEXEC /f "C:/*.dtsx"  this is not work

hi arthurz,

its working in the below bat file,

for %1 in (D:\deletepack\deletepack\*.dtsx) do dtexec /F "%1"

in this code its showing error in last %%f

FOR %%f IN (C:\PackagesToExecute\*.dtsx) DO DTEXEC /f %%f

-----------------------------------

already i placed main package in the directory.

also i am having intermediate knowledge of ssis i dont know to write VB or C# code in inside of script task. so in script task can you please explain more.