Getting close to figuring this out. Turns out when you use an event handler you need to explicitly change the property of 'FailPackageOnError' or 'FailParentOnError' to true. With...

I'm just tossing this out as a suggestion only because the file system task seems a bit finicky with me. Why not use a script task to rename the...

My vote is on using a stored proc. I find it much easier to manage any logic changes. I tend to use SSIS as a means of getting...

Can you post the package?

Phil Parkin (8/25/2010)

---

It's a puzzle that would probably be sorted out within five minutes if an experienced SSIS user had direct access to the package. I have nothing specific to...

Alvin Ramard (8/24/2010)

---

Then you might try to add a VB (or C#) Script Task a the first task to execute in the For Each container. Pass the file name...

When you check overwrite data, it will overwrite any data in the file. So you are correct in that you will have one file but it will only be...

Is it looping through all of the files and only processing one file or does it only loop through one file then exist? I always make the mistake of...

Ok folks... So I finally cracked the code on this. There were two issues. The first was:

Database mirroring connection error 4 'An error occurred while receiving data: '64(The...

I'm a sysadmin on the server I can see the results if I don't include the execute as. But once I add the execute as, I get the errors...

Can't help with the syntax. But when I have an issue where I have to do an execute process task that requires some arguments to be passed, I get...

I usually use the foreach loop and just specify a pattern (i.e. filename*.txt) and dynamically build the connection. Depending on the project I'll also store the filename in a...

It's interesting that you mention the WITH COMPILE option. I had to put that on a few months ago to get SP to use the right plan. I...

What da-zero said. In fact, I prefer using a table whenever possible since it scales much better and you don't have to worry about someone deleting files or changing...

Great article. Works like a charm. I do have some reservations using OLE Automation due to security concerns and the ability to troubleshoot when something goes wrong.

Google will...