You might be able to use a conditional split transformation for this purpose. This object will take an input stream and will split it out to two or more...

If your package runs for several hours even in your local development environment, I assume that there's a lot of transformation or a huge number of records being affected. ...

You'll need to provide more details than simply "it's not working". What is the expected output?

You can set the data types in the flat file connection manager under the Advanced tab of that control. Clicking each column will allow you to view or change...

If your remote environment is the live environment, there may be an issue of resource contention. If you have a lot of users accessing the system while your SSIS...

When you run the package locally, are you accessing a different database than when you try to execute it in your remote environment?

Steve, I did receive your e-mail. I'll dig into it later today and see what I can find.

Thanks,

Tim

If the format of your input files is static and consistent, you could change the data types in your flat file connection rather than explicitly convert them later in the...

Sure - it's tdmitch [at] gmail [dot] com. The forum software won't allow you to upload a DTSX file, but I think it let's you load a zip file.

Interesting... I haven't encountered this behavior before. There's no requirement to explicitly release the file after processing in the data flow, so it's not clear to me why...

It looks like you've got the data flow objects set up correctly, but the behavior you describe sounds like both of the file system tasks are trying to run at...

Take a look at the attached and see if it might do what you need. Each quality check is done in turn, and the ones that fail the check...

You didn't mention what you're doing with the Derived Column transform for each data file. What is it that this transform is doing? How long does it take...

Can you attach the package, or a screenshot of your control flow?

A CSV file is, by definition, a file that separates distinct values with a comma. So any non-qualified comma marks the beginning of the next field.

So, for your expected...