Hey Tim,

I was wondering if you could help me with the following.(re-post)

I need to use a For Each Loop Container to loop through and grab all the CSV files in...

Worked without a flaw.

I appreciate it man.

You saved me much needed time here. Was going haywire trying wildcards n stuff to figure this out.

Thanks again.

Have a very Good One !!

Thanks for your quick reply GSquared.

Yes, this will work. But, in the FullName field I have values like Ragan W Anderson and other values that will not be matched using...

Hi P. Jones,

I had three large Excel files to import. All Excel files had only one table but different names. For Each Loop Container was failing. So, I used UNION...

Those instructions are for looping within a single excel file and then importing data from the tables with different name in that Excel file.

Would that apply when we need...

I appreciate that. Maybe I can use some more of your help.

Now, I'm trying to do the same thing within For Each Loop Container.

About the package that I am...

Guess Today's lucky for me. Solved couple of problems which had me stumped.

Voila !!

Got this working.

I was checking the number of rows inserted which were 601 every-time instead...

Tim,

I appreciate your time and effort.

The connection is configured to connect to the Excel table name with $ sign and not the Range. And there's only one table.

What I...

Hey Tim,

Did you get a chance to look at the package? Please let me know if anything else is needed for your testing.

Thanks. 🙂

Tim,

I have no external configuration and other expressions as per my knowledge in this particular package. I have other packages(which do have configurations and variables and expressions for using For...

Thank You for your Advice. It was useful.

It is working but the results aren't as expected.

Here's what I did.

1. I used this expression for the Excel File Path Property:

"D:\\MyFile" +...

Hi Phil,

Actually it worked !! and left me amazed.

Here's what I did.

I edited the Registry value of TypeGuessRows to 0, Decimal this time and made sure that ImportMixedType is...

The excel file is part of the daily import process which is pulled from a FTP location. I think I shall give it a try using Flat File or like...

I changed it to nvarchar(255) but again with NO LUCK !!

Thanks for your reply.

SELECT DATENAME (dw, GETDATE())