I am using the looping code by Allen Mitchell. The web link is below.
http://www.sqldts.com/default.aspx?246

I had a package running last night to load multiple files. It was
working beautifully. It uses the filesystem object to get all the
files loaded, then archives to another folder when complete. It timed

out last night, I am guessing because of a backup process. I am now
unable to run the package. I thought it might be because my original
connection was not present any longer because it was archived so I
copied it to the main folder and the package started again...but to my
disappointment once that file loaded it stopped again at the
transformation process and kept spinning its wheels.


Any ideas on how to troubleshoot problem?


I am a novice at sql server so bear with me.


Jen

Hello jennifer_kostuch (AT) yahoo (DOT) com,

So it does not error but it stalls?

When you say "Original Connection" do you mean the original file? This should
not matter. The connection is set through the task that begins the loop.




Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Yes, I mean the original file. I know it should not matter which is
why I am so confused. When I test just the transformation task it
appears that it is working. And yes it stalls. It does not error.

Allan Mitchell wrote:

Hello jennifer_kostuch (AT) yahoo (DOT) com,

Have a look at the workflow properties of the Transform Data Task and make
sure that the "Close Connection On Completion" property is checked.


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Yes the "Close Connection On Completion" property is checked.

Allan Mitchell wrote:

Figure out the problem. I thought the next file that was going to be
loaded may have an error in it. My assumption was the first file in
the folder was the next to be loaded which it was not it was the last
file in the folder. Anyways once I figured that out I checked the file
and it had a error in it which is why the process stalled. Thank you
for your help. I am still in the process of learning and will be for a
long time to come.

Jen

jennifer_kostuch (AT) yahoo (DOT) com wrote: