Thanks. I can't say if it will work or not b/c I've been pulled onto another project and I have to put this aside for awhile. I do...

Yes, you're both correct. I must have set something in the Flat File Connection manager incorrectly. Thanks

Thanks for your suggestion, Mark. After playing with it for awhile, I realized that it may not work using that method. I can't just use the output from...

Thanks for your suggestions. Actually, adding "Option Strict Off" worked for me. I've never seen that command, but it took away the error.

Regarding your 3rd suggestion, I didn't...

Thanks, Sean. Your video was excellent, and a great learning tool. It really helped in understanding how to formulate my solution.

I received one error that I was hoping...

I did a net search on the "OLE DB Source failed the pre-execute phase" error and found out that I need to set Nocount On if the query updates, deletes...

Thank you so much for your posts.

Regarding your post, born2bongo:

For #1, I made sure Query$ was selected in the ExcelDestination.

For #2, I decided to remove the Data Conversion step...

By removing the Execute SQL task, that leaves me with a Control Flow File System task (I forgot to mention this in my original post) in which I'm creating a...

Thank you for your suggestion. I tried to go back to square one but I think it made things worse. I'm going to start a new topic which...

Thanks for that explanation. As an SSIS beginner, that was very helpful. Unfortunately, I can't test it all the way through because the package keeps erroring out in...

To continue on this topic with a slightly different slant, I would like to create a new Excel file each time the package runs. It seems that I am...