When I used the File System task to delete my file in the Control Flow, the DataFlow errored telling me that the file was not found??!!

It's...

I follow what is being said, but I still get errors.

I need some way to overwrite the data in my Excel worksheet each time the package runs...

Do I need to...

Okay, Maybe I am just having a true blonde moment here, but I don't understand. I do have a delete table task but that is what is...

AS for steps, the wizard created two simple steps. First a delete and second the import. Run the very first time works fine but it is after...

I have checked the settings - It is set to Microsoft Excel 97 - 2005 and I am working with Excel 2000. I am guessing this is correct??...

When I clicked on remove, it removed my .NET 2.0 and I had to re-install it.

BTW, it still did not resolve the original problem....

Dumb question - how do you run a repair in the Add/Remove Programs?

I am having trouble with Excel exports as well. I want to be able to run the same export more than once without intervention and I want each...

Okay, I have tried to re-install the client tools three times now and still continue to get the same problem.... Anyone have any other ideas? Is...

I was afraid you were going to say something like that. 🙂

I will give that a try - thanks.

mlj

No, I haven't done anything with the SSIS...Logging but I didn't have to for any of my other DTS jobs that I brought over - they just create the...

Thank you Adam, This is the type of stuff I was looking for!

Grateful,

MJ

Thank you for the information Michael (and the prompt reply!) I will give that a try.

MJ

---update: Using the ForEach Loop Container worked wonderfully for this! Thank you...

This worked beautifully for us as well. Many thanks for the script and instructions! This saved me LOTS of time trying to figure out how to integrate mail...

Thank you Cath. I feel like a fool as I finally found that. I knew it was pretty easy but I was just overlooking it and it...