There are several ways you can do this. The way I usually do this is to FTP the file down to a working directory, and then use a ForEach...

It appears that you've covered your bases... can you post a screenshot of your ForEach loop settings?

Dak,

You can do this using the Error Output of the OleDB Destination. Open up the OleDb Destination and go to the Error Output tab. You'll see that the...

If you're getting that error when you create a new project in SSRS, SSIS, and SSAS, you've probably got an issue with your BIDS/Visual Studio installation. Try updating to...

OK, if I understand correctly, it runs fine when you run the packages serially (one after another) but it's not completing when they run in parallel. If that is...

You can skip n number of rows at the beginning, but there is no transformation that will allow you to skip every nth row. Is there anything in the...

When you run it from BIDS, are you running against the same database? Your post wasn't clear if you are using a separate testing environment. If the deployment...

Can you give some more information about your environment - what is the source of the data you're pulling? Are there any conditional splits, lookup transforms, etc., that could...

Are you running your TEST and PROD environments on the same hardware?

My understanding is that there are possible performance implications with runtime as well as design time. I haven't done any runtime comparisons, so I'm speaking purely academically on this,...

The short answer is that you can't keep people from doing dumb things; if you give people scissors, they're eventually going to run with them. However, there are some...

You should know that the FMTONLY option can cause a performance hit in the designer. If your stored procedure is a long-running operation, your package may appear to hang...

The fact that this community has reached such a milestone speaks to the hard work and foresight of the founders. You guys are to be congratulated and thanked for...

You can use an expression in your FTP Task to accomplish this. Open the FTP Task, and in the Expression Editor, select the Remote Path and use something similar...

I haven't worked with WinRAR, but I've done quite a bit of work with WinZip to automate zipping and unzipping files with SSIS. With the latter, the command line...