Is there any way to do the sub-directory search inside SSIS package without having to involve database? Thanks!

I got it now. Thanks a lot for your help, Bob!

Thanks for the reply!

Sorry that I couldn't quite make out of the example. My ### is random as tbl###.

Could someone shed some light for me please?

Basically my question is how to dynamically loop through a list of tables?

e.g. select * into #mytemp from tablexxx

where I have a...

Got it. Thanks a lot, Phil!

Thanks for the suggestion! Would you please elaborate a little more?

I couldn't figure out how to set the "Enumerator configuration" in the Foreach Loop (Foreach File Enumerator) container using variables....

John, Thank you so much for taking your time to write the detailed instruction! It worked great! I had no idea that you could directly set variables like that!

Thank you...

Thanks, John! Sorry for the late reply. I had been on vacation.

The reason I used the Script component is because the file is not delimited. It's a text log file....

Thanks a lot for the replys!

I couldn't believe that I forgot about ReadOnlyVariables and ReadWriteVariables and spent hours of debugging inside the script task. It's my second time using...

Wayne, I added "select * from @Tmp" at end of your code. And here is the result I get from.

ColumnAColumnBTmpCol

a11:3:5:61356

a22:4:5245

Does this match the expectation?

By the way, i am using SS2008 Management Studio. Don't know if that would make any difference.

Jeff, thanks for the pointer. Sorry that I missed it the first time. It sure is a great article! There is so much to learn for SQL server!

Wayne or anyone:...

Sorry, I got errors from both scripts. Would you please help again.

The first Flo's script, I got the following error:

Invalid object name 'Tally'.

Second Waynes script, I got empty output with...

Flo & Wayne,

Thank you so much! You guys are so quick and I'll try out both ways. Flo's way is more straight-forward to me. I appreciate Wayne's xml way and...

Thank you so much for all the help!

I will read those references.