For each Loop Problem in SSIS - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

For each Loop Problem in SSIS

Author

Topic

Trudye
Posting Yak Master

169 Posts

Posted - 2009-08-13 : 19:02:40

Hi Guys, I am using a For Each Loop to read Flat files. I have ck'd and dbl ck'd my file layout but I keep getting the following msg

Warning: 0x80070003 at Detail, DTL SOURCE [2895]: The system cannot find the path specified.
Error: 0xC020200E at Detail, DTL SOURCE [2895]: Cannot open the datafile "".

I know the path is correct because this is the 2nd For Each in this pkg and the other one is using the same path and it works fine.

What am I missing?

Thank you,
Trudye

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2009-08-14 : 05:02:26

Somethings to check:
Is the file path hard-coded? Or a variable/expression?
Could the path variable been changed by the first loop?
Is the variable only in the scope of the first loop?
Does the first loop delete/move/rename the file path?
Can you print/log out the file path? And check it's correct.

rdoda
Starting Member

1 Post

Posted - 2009-08-24 : 14:43:37

quote:
Originally posted by Trudye

Hi Guys, I am using a For Each Loop to read Flat files. I have ck'd and dbl ck'd my file layout but I keep getting the following msg

Warning: 0x80070003 at Detail, DTL SOURCE [2895]: The system cannot find the path specified.
Error: 0xC020200E at Detail, DTL SOURCE [2895]: Cannot open the datafile "".

I know the path is correct because this is the 2nd For Each in this pkg and the other one is using the same path and it works fine.

What am I missing?

Thank you,
Trudye

Have you tried to debug the package and see what filename does it pick up?

vmon
Yak Posting Veteran

63 Posts

Posted - 2009-08-31 : 13:13:34

I am having same problem. Path and filename are variables, the first task within For Each Loop is a Data Task and it imports the data. The second task is doing a move/rename of the file. There error I get is:
[File System Task] Error: An error occurred with the following error message: "Could not find file 'C:\Documents\Data\Inbound\ab3.txt'.".

I am not sure what to try now.

Any help would be really appreciated.

Thanks,
vmon

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources