dbTalk Databases Forums  

Foreach File enumerator missing in Foeach Loop containger after applying SP1

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Foreach File enumerator missing in Foeach Loop containger after applying SP1 in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Lorents Nord-Varhaug
 
Posts: n/a

Default Foreach File enumerator missing in Foeach Loop containger after applying SP1 - 09-26-2006 , 06:53 AM






Hi.

After applying SP1 on my SQL Server 2005 developer edition on my laptop,
there is no longer a File enumeratorin the Foreach Loop container.

I have found this problem described earlier, but not yet found any solution
for this problem:

http://groups.google.dk/group/micros...e489a55fd6add0

Have anyone found a solution for this porblem?

Best regards
Lorents Nord-Varhaug




Reply With Quote
  #2  
Old   
Charles Kangai
 
Posts: n/a

Default RE: Foreach File enumerator missing in Foeach Loop containger after ap - 09-26-2006 , 07:21 AM






Interesting. I applied SP1 and my File enumerator works as before. I did get
other problems with SP1 but not this one! You may want to install the
post-SP1 hotfix (build 2153). However, looking down the list of fixes in
hotfix 2153 it appears your particular problem is not listed. You might still
want to try and install it from here: http://support.microsoft.com/kb/918222
.. Even if the hotfix does not correct this problem for you, it corrects other
problems; for example, after you have installed SP1 and your computer is in a
domain, the SSIS service fails to start.

Charles Kangai, MCT, MCDBA
Author of Learning Tree's 4-day course: "SQL Server 2005 Integration
Services" http://www.learningtree.com/courses/134.htm
Author of Learning Tree's 4-day course: "SQL Server Reporting Services"
http://www.learningtree.com/courses/523.htm
email alias: charles
email domain: kangai.demon.co.uk


"Lorents Nord-Varhaug" wrote:

Quote:
Hi.

After applying SP1 on my SQL Server 2005 developer edition on my laptop,
there is no longer a File enumeratorin the Foreach Loop container.

I have found this problem described earlier, but not yet found any solution
for this problem:

http://groups.google.dk/group/micros...e489a55fd6add0

Have anyone found a solution for this porblem?

Best regards
Lorents Nord-Varhaug





Reply With Quote
  #3  
Old   
Lorents Nord-Varhaug
 
Posts: n/a

Default Re: Foreach File enumerator missing in Foeach Loop containger after ap - 10-03-2006 , 01:28 AM



Thanks Charles, for yor answer!!

I have upgraded to hotfix 2153, but this did not help.

I have also checked with some of my colleguues, and we are two having this
problem, and two which does not have this problem. Of those two not having
this problem, one has upgraded to SP1 and one has not.

The two of us having the problem, both have upgraded to SP1, and neither of
us have checked for the Fil enumerator before upgrading to SP1, so we can
not be sure the problem araised with SP1.

Regrds,
Lorents Nord-Varhaug


"Charles Kangai" <CharlesKangai (AT) discussions (DOT) microsoft.com> wrote

Quote:
Interesting. I applied SP1 and my File enumerator works as before. I did
get
other problems with SP1 but not this one! You may want to install the
post-SP1 hotfix (build 2153). However, looking down the list of fixes in
hotfix 2153 it appears your particular problem is not listed. You might
still
want to try and install it from here:
http://support.microsoft.com/kb/918222
. Even if the hotfix does not correct this problem for you, it corrects
other
problems; for example, after you have installed SP1 and your computer is
in a
domain, the SSIS service fails to start.

Charles Kangai, MCT, MCDBA
Author of Learning Tree's 4-day course: "SQL Server 2005 Integration
Services" http://www.learningtree.com/courses/134.htm
Author of Learning Tree's 4-day course: "SQL Server Reporting Services"
http://www.learningtree.com/courses/523.htm
email alias: charles
email domain: kangai.demon.co.uk


"Lorents Nord-Varhaug" wrote:

Hi.

After applying SP1 on my SQL Server 2005 developer edition on my laptop,
there is no longer a File enumeratorin the Foreach Loop container.

I have found this problem described earlier, but not yet found any
solution
for this problem:

http://groups.google.dk/group/micros...e489a55fd6add0

Have anyone found a solution for this porblem?

Best regards
Lorents Nord-Varhaug







Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.