Well, I will provide my solution but like I've stated, it's VBA based but here it is:

Sub ProcessDataTransform()

'''''''''''''''''''''''''''''''''''''''''''''''''''''''''

'''This...

I decided to use VBA in Excel for each workbook who's data is being transferred into the csv. Thanks for the link and suggestions.

Hi Matthew,

I can't move the files after step 2 because the files aren't being referenced at this point. A csv is being connected to but not the Excel files....

Where do I set the default connection? I'm going to...

I only showed a small part of the For loop container. Check the new image out to see that I'm doing a fair bit in there and I'm still...

I've been working on a workaround for this. I've created individual connections for each CSV file. At a certain point in my package, and while using precedence constraints for...

If by format you mean the type of file then yes, they are all CSVs. If you mean the format in the csv then no, they all differ a...

Seriously? Darn! Now I'll have to make 11 different packages? Darn!

Thank you very much for that. Most of that was copy/pasted from MS Word, which seems to be why the quotes are all weird. I've learned a lesson...

Thanks so much as this worked quite well. The expression didn't like User:: so I went with @Table_Number=="3790027" which was accepted.

Hi Evil,

Thank you very much for that. I actually went into the precedence constraints before posting here but I didn't know what to do there. Now I know...

Mordred (11/23/2012)

---

@ learning_sql, I am going to give that a try and I thank you for that.

@ Jason, I would love to be able to do a bulk...

@ learning_sql, I am going to give that a try and I thank you for that.

@ Jason, I would love to be able to do a bulk insert...

Hi Jeff, I tried that yesterday and I still received truncation errors because SSIS is still trying to separate the columns where there are commas within the quotes. Thanks...

After all the Googling I've done today on this matter it seems like I am going to have to put each field value into a string, check it for a...