I had similar problem and found a workaround for that putting a Derived Coulmn task after the Flat File Source.

The following transorm for "sexcod" column should help - "N" -...

not sure if I understand your purpose. I was thinking about reading the current cycle only

anyway if you need to read data from previous cycles too:

how to do that may depend...

Hi,

have you thought of using a view that is dynamically modified after the load of data to always point to the table you want to report from?

Jakub

Hi,

I suppose the problem is with protection level you set in the package and that it is created with one account and executed with another (however the message you get is quite strange)....

Sarath

Looks that in SCD you can't set identity field as a Business Key what is even quite logical . Assuming you transfer data from OLTP to OLAP...

Sarath,

I don't know your database but seems to me you should forget identity columns when you want to update or insert records to your tables (assuming we talk about dimension tables). Just...

Sarath

But in this case it seems using SCD is not relevant or you should reconsider what in fact is your business key in this case. As per definition identity column...

you are welcome, Sarath

Hi,

this is quite a complex taks and you can do a lot with it. If you need to insert new records in your destination table and update existing ones (the...

use Slowly Changing Dimension. That should be what you are looking for.

Jakub

Please try to do the following - in parameter mapping replace "?" with "0". I did it like that with OLE DB data source and worked.  

Select ProductID, ProductName...