I have a working solution. I imported the Excel data into a table with ntext fields for the address1 fields. I also had a second new column for each address1...

I did try the IMEX=1, but that didn't help at all. I"ll try that knowledge base article. Thanks!

That is what it SOUNDS like, but I reset and did it again. *I* changed only the Excel Source output External Columns, which is what is coming into Excel, and...

First I want to say that I'm not really familiar with the Advanced Editor, which you can tell since I completely forgot it even existed. Anyway, I'm now getting an...

Wow! That was fast. I should have posted yesterday! I see where you mean and will try that. Thank you VERY VERY much!

All I know is that the vendor didn't have rights to see the file groups, so when he got the error in his script saying that it already existed, he...

Thank you VERY much. The ADO is what I really needed. I think this is going to work - I just need to remind myself how to use an expression...

That is what I thought I needed to do - prime it. I was doing this on the Control Flow tab. I didn't think to use an ADO, as I'm...

I don't think that link helps, as it seems to send file names in a specific location to a variable. It also shows how to configure the loops as ForEach...