You have an answer to the original question but I would like to point out that it smacks of poor table design. Why do you have values in a...

How about an FTP client and a Run Process Task to call the shell script

Phil, Thanks but no thanks 🙂

I hate regex. The regex would need to treat it as a string (either explicitly or cast in a derived column) and then apply...

Im not clear on the requirement.

Are you saying that you have two files one English and one French

English:

Day|PartNo|Price

Monday|ABC|123.45

Tuesday|ABC|124.78

...

And in French

Jour|PartNo|Combien

Lundi|ABC|123.45

Mardi|ABC|444.55

If so, then firstly the files should not contain language specific...

Look at Slowly Changing Dimensions.

I scanned the thread but didn't see it mentioned. The SCD wizard will walk you through the steps required.

What is the source

What is the primary...

If there is no field on the table to identify the last time a record was changed, how do they expect you to define the delta.

Your options:

Full snapshot of the...

are you sure there isnt another process running in Oracle that is deleting the records (or perhaps locking the table)

Are you relying on a lookup table that is incomplete on...

What is the relationship between EMP, STO and PRT.

Can an EMP have more than one STO

Is EMP always followed by one and only one STO and is STO always followed...

Konesans file watcher allow the package to be permanently running and only triggers processing when the file arrives.

Have you investigated Konesans File Watcher ( you can get it from here)

http://www.sqlis.com/sqlis/post/File-Watcher-Task.aspx

It listens for files arriving in a directory. You could use any process you like...

depending on the version of SQL you could set the database up with an Exchange email box and have it monitor its emails on a scheduler but this would still...

sounds like a job for slowly changing dimensions

I would create a second flat file connection for the data source with a single column and then use conditional split to ignore all but first line.

Provided the format of...

I am guessing that becuase the source data structure is different for each table you can't just dynamically assign the ole data source because the metadata will be different for...

at the very least the front end app should be escaping strings. A typical attack occurs where you are running a script like

$SQL = "SELECT * FROM CUSTOMER WHERE...