December 17, 2012 at 8:49 am
Hi All,
I have Foreach Loop Containter and it has the following items:
(1) Execute SQL Task - executes .sql scripts taken from a folder and
(2) File system task that has to archive the executed .sql files from (1).
When I run the container or the package the archiving is done, but the scripts didn't execute.
I tried changing some properties but didn't managed to achieve my goal.
Can anyone help or advise?
Thanks
IgorMi
Igor Micev,My blog: www.igormicev.com
December 17, 2012 at 9:15 am
Lots of possibilities here. Could be the scripts don't do anything because they aren't applicable (like Where clauses that cause no rows to be affected). Could be they aren't pointing at the right connection, and they're "doing something" but not where you expect. Could be lots of things. No way to tell without a lot more details here.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 17, 2012 at 9:30 am
GSquared (12/17/2012)
Lots of possibilities here. Could be the scripts don't do anything because they aren't applicable (like Where clauses that cause no rows to be affected). Could be they aren't pointing at the right connection, and they're "doing something" but not where you expect. Could be lots of things. No way to tell without a lot more details here.
Scripts usually update in tables, or create new objects. I firstly executed without archiving the files, and i passed well. Then I have to put all the files in Archive folder so that in case the container fails I can continue with it with just correcting the failing script or removing it temporarily. There are about 400 scripts.
Anyway I did logging I can see what failed ... however archiving helps me more.
Thanks
IgorMi
Igor Micev,My blog: www.igormicev.com
December 17, 2012 at 9:33 am
What you're doing makes sense. It's a good way to handle this kind of thing. I'm just not sure I can offer any help on debugging your loop without more details. Assuming it still needs debugging, of course.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply