Hello,

I've created simple SSIS package based on:

http://www.sqlservercentral.com/arti...ervices/63382/

It works great from Business Intelligence Studio,
but doesn't work from SQL Agent Job

--------------
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.3042.00 for 32-bit Copyright

Code:
0xC0014023

Source:
Foreach Loop Container

Description:
The GetEnumerator method of the ForEach Enumerator has failed with error
0x80004005
"Unspecified error". This occurs when the ForEach Enumerator cannot enumerate.
End Error DTExec: The package execution returned DTSER_FAILURE (1).
--------------

SQL 2005 SP2 x86

--
Regards,
anxcomp

Can you give us a little insight into the ForEach enumerator? (The link
provided required password access.)

My off-hand guess is that you are trying to access some resource that YOUR
account has access to but the Service Account for SQL Agent does NOT.
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"anxcomp" wrote:

Can you give us a little insight into the ForEach enumerator? (The link
provided required password access.)

My off-hand guess is that you are trying to access some resource that YOUR
account has access to but the Service Account for SQL Agent does NOT.
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"anxcomp" wrote:

Can you give us a little insight into the ForEach enumerator? (The link
provided required password access.)

My off-hand guess is that you are trying to access some resource that YOUR
account has access to but the Service Account for SQL Agent does NOT.
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"anxcomp" wrote:

Can you give us a little insight into the ForEach enumerator? (The link
provided required password access.)

My off-hand guess is that you are trying to access some resource that YOUR
account has access to but the Service Account for SQL Agent does NOT.
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"anxcomp" wrote:

Can you give us a little insight into the ForEach enumerator? (The link
provided required password access.)

My off-hand guess is that you are trying to access some resource that YOUR
account has access to but the Service Account for SQL Agent does NOT.
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"anxcomp" wrote:

Can you give us a little insight into the ForEach enumerator? (The link
provided required password access.)

My off-hand guess is that you are trying to access some resource that YOUR
account has access to but the Service Account for SQL Agent does NOT.
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"anxcomp" wrote:

Can you give us a little insight into the ForEach enumerator? (The link
provided required password access.)

My off-hand guess is that you are trying to access some resource that YOUR
account has access to but the Service Account for SQL Agent does NOT.
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"anxcomp" wrote:

Can you give us a little insight into the ForEach enumerator? (The link
provided required password access.)

My off-hand guess is that you are trying to access some resource that YOUR
account has access to but the Service Account for SQL Agent does NOT.
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"anxcomp" wrote:

Hello,

Thanks for answer, yes of course the same article, without password:

http://davefackler.blogspot.com/2008...databases.html

SQL Service Agent account is member of domain admin group, it has unlimited
access

--
Regards,
anxcomp