August 25, 2010 at 6:11 am
Check the Files text area..(have provided any delimiter or any specific extension)
Chek the status of Traverse Sub Folders checkbox
Raunak J
August 25, 2010 at 7:11 am
Raunak Jhawar (8/25/2010)
Check the Files text area..(have provided any delimiter or any specific extension)Chek the status of Traverse Sub Folders checkbox
Traverse sub folders has no affect on the root folder.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 25, 2010 at 7:14 am
Alvin,
If the package is just reading the a single file then definately the remaining files must be in a folder structure.
Raunak J
August 25, 2010 at 7:21 am
Raunak Jhawar (8/25/2010)
Alvin,If the package is just reading the a single file then definately the remaining files must be in a folder structure.
The original post contains the following:
I Configured a For each loop container in order to read each of the files from a FOLDER and then process them using Data Flow/Script Component but is only reading ONE file from the folder.
hence Alvin's sensible message.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
August 25, 2010 at 7:23 am
Phil,
What do you suppose is the problem?
Raunak J
August 25, 2010 at 7:31 am
It's a puzzle that would probably be sorted out within five minutes if an experienced SSIS user had direct access to the package. I have nothing specific to add that has not already been suggested. I'm sure it will be something minor.
But one thing I try not to do is treat the OP in a patronising way by suggesting that the facts stated in their original post are actually incorrect.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
August 25, 2010 at 7:35 am
Phil Parkin (8/25/2010)
It's a puzzle that would probably be sorted out within five minutes if an experienced SSIS user had direct access to the package. I have nothing specific to add that has not already been suggested. I'm sure it will be something minor.But one thing I try not to do is treat the OP in a patronising way by suggesting that the facts stated in their original post are actually incorrect.
Well said. We'll just have to wait to the OP to reply or perhaps post his package so we can troubleshoot.
August 25, 2010 at 9:49 am
Even If a test selecting "Trasverse Folders"I get the same result, only one files is read.
My Enumerator configuration:
Folder: C:\txtSalida\PlantasR42
Files: *.txt (have tried already using *.*,*test.txt)
Files inside this folder are:
Test5.txt
Testing.txt
Variable Mappings":
User::FIlename
Expressions: No Expressions.
Only Testing File is showed in the pop up messagebox.
If I delete Testing file, then TEST5.txt is read.
-----------------------------------------------------
DataFlow:
Script Component:
Readonly variable= User::FileName
August 25, 2010 at 9:53 am
Please it would be great if you can see directly my package in my computer.
Let me know if anyone can so I can send you a link.
August 25, 2010 at 9:56 am
Can you post the package?
August 25, 2010 at 10:10 am
I don't see anything wrong.
Try this:
1 - Add a new For Each Loop to the package and configure it to read the same files. (DO NOT use copy and paste!!!)
2 - Add a VB Script task in this new container and have it display the file name using a MsgBox.
If this works, I'm guessing that the original For Each container was somehow corrupted or there's an issue with the tasks in the original container. if this worked then try adding the original tasks to this new container and delete the old one.
If this does not work, then ....... good question.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 25, 2010 at 10:50 pm
What's the scope of your User:filename? I've had bad results by not paying attention to that.
(edit) needs to be within the loop, and not a package-wide var.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
August 26, 2010 at 12:38 am
Thanks!! for all your help. I could not figure out the problem and I did not have much time, so I found another way (workaround) to do the package.
Also a friend of mine who is an SSIS expert tried to figure out the cause of the problem without success, it looks like it was a bug.
I am succesfully using a FOR EACH container, but not the same way.
thanks again to all for your help!
August 26, 2010 at 12:46 am
Matt!
I think the variable User::FileName is set to be used all over the package.
Idid not see your replays and I already found a workaround. I am going to check that just to know and let you know if that solve it!!!!!
I can't even plan!! cause I am new in this!! first time using a Script Component. but it is good to know you are not the loud-spoken end user or the project manager!! LOL
Thanks!!!!
August 26, 2010 at 12:51 am
Thanks Alvin
I already found another way to do it. But I am still wondering what was wrong.
Your suggestions sound very reasonable about that maybe the container is corrupted. I will try to find some time to try the things you just posted and let you know.
Thanks a lot for your help I really aprecciate it.
Regards,
ana
Viewing 15 posts - 16 through 30 (of 33 total)
You must be logged in to reply to this topic. Login to reply