Start Free Trial

asked on

for loop container in SSIS

I have an SSIS package in sql 2005. I have a for loop container that contains 3 tasks. One of the tasks is a file watcher that imports .mdb files. The other 2 parse out the data. I want this to run repeatedly until there are no more files, then it needs to execute 2 tasks that transform the data which are outside of the for loop...any thoughts?

the for each loop can do that... read each file (must specify file type) ...
Do you need an example? if yes... attach files here to make the example for you.
regards

ASKER

hi pedro - yes, I do need an example. What files do you need from me?

attach you project here and I'll complete with the solution you need
rename the package to TXT
Regards

ASKER

Pedro- here is the complete solution files.

ASKER

i had to add a .txt xtension because EE didnt like it.

ASKER

finally worked
LoadStudentAnswers.zip

Dear Friend,
I'm seing your project... You are using a component from Konesans... Are you sure you can use components from external suppliers?

Tell me to give you my solution!
Regards

ASKER

yes, we can use that third party tool. It is a free download that just watches a folder for files of a certain extension and then fires when a files is placed into the folder. If you know of a soultion without it I am open to any suggetions. Thanks for your help so far.

I know konesans... if you can use, ok!
But you can add the SSIS to inside a SQL Job and schedulle the SQL job to execute each 2 minutos or less...
I dont know the memory/hw resources that the konesans component spend... but I will use it in the package I will try to do today!
Regards

ASKER

thank you pedro, i appreciate the assist!

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

improvements?!
Regards!

ASKER

Hi Pedro-
I will be testing this on Tuesday night or Wednesday morning. I am on another project right now.

Ok PsychoDazey!
Give me feedback on thuesday!
Regards!

ASKER

I will, I appreciate the work you put into this.

ASKER

Hi Pedro - the package executes, but when it gets to the for each loop it just hangs... the tasks contained in the loop dont execute. It isnt throwing an error, it just sits there.

do you changed the path of access database inside For each loop?!
regards

ASKER

OK, now it executes that part but it doesnt look like it executes the last 2 tasks outside of the for each.

ASKER

I am also posting another question on this same dts task if youre interested.

I have put those 2 tasks disable... right click in each task and enable it..
I changed to disable the gray tasks because I dont have connection to database
helped?

send me the link! :-)
I will help you.. if I can of cource!
Regards

ASKER

I can enable the process each file task, but it will not allow me to enable the grade exams or perform summarization tasks for some reason...I get an error message saying "cannot get property for c-89-designer name cast is not valid"

link each connection of each task to the connection in the dropdown. I didnt change anything in the gray components, I only put ssis package reading all the MDB files you have in a specific folder. And the for each is working, correct? in last step, delete a create again the gray components and try again!
Regards!!
pedro

ASKER

ok, i'll try it. Here is the link to my new question, it just builds on this ssis package:
https://www.experts-exchange.com/index.jsp?qid=23779136

ok PsychoDazey!
:-)

ASKER

Which version of Konesans do you have? maybe thats the problem with the tasks...it is giving me a message saying it is not registered for use on my system

delete the task or install the latest version
I installed the latest Version 1.2.6.100
cheers

ASKER

my problem is that I dont know what those tasks do...this is a project I took over for someone that left. Oh well, you solved my original problem so thanks for the help! I'll figure this last part out on my own.

I can still help you. send me an email explain it better! is some confusion! :-)
regards

ASKER

Where do i send the e-mail?