OK, have you tried pre-formatting the template? Which column will hold the currency values? Do you know how to write VBA?

I was advised that you shouldn't use your personal.xlsb file to do this. There are a couple of options that you could go with but it depends on the...

I don't know why your Excel file won't save the formats! I'm going to ask some Excel buddies/gurus that I know to see if they have any idea why...

For the layout I created in the Excel file, the currencies were placed in column B. I highlighted column B, right clicked, and then selected "Format Cells". I...

Alright so I formatted the columns that I am affecting with the data flow task and now it loads properly. Here's what I have done:

1. Created a simple table...

I just did as I suggested with my own starting Excel file and it didn't seem to have the proper effects. I'm going to keep trying though.

Alright I see what you mean.

Questions:

Is the Excel destination pre-existing or are you generating a new Excel file each time this particular data flow task is run?

If...

K, I'm currently trying to recreate the scenario but am having un-related issues at run time with my laptop. I'll get back to you in a bit or someone else...

Have you used the Data Conversion in your Data Flow Task? Perhaps this link will be of some help for you.

I figured this one out with some help. The following Try Catch worked to download 312 different zip files from our source.Try

...

Thanks Paul, I'm going to look into querying the whole table and see what I can do. Thanks for your explanation.

Hi Paul,

Can you explain that a little more or provide a link to your solution idea? I am attempting something similar in that I am running a Foreach Loop...

Alright, I am at a point now where this particular process completes (ie goes green) but all the files that are being downloaded are not there. The output window...

Are you using SSIS for your ETL purposes?

Hi derek.colley and thanks for the response. As it turns out, I performed a find/replace on what I thought was one column but instead replaced all "-" characters from...