Absolutely, the package flow would resemble as below:

Original data --> Derived Column Task --> Pivot Task --> Destination

You must understand that implementing a MDM or CDC is far superior than batch loading...the CDC actually tries to eliminate the batch window(15 day in your case)

Give some time and...

It is always better to load only the changed data to the warehouse. Yes your "BOSS" stands correct!!!:-)

wcwarner (9/16/2010)

---

Hello,

I have a very simple pkg that truncates a table and pumps fresh data into the table nightly. I have been able to capture the errors in an event...

What is the meaning of applications?

As suggested in the earlier post you may understand or manage to get a gist of all your doubts by reading the relevant content

This really shouldn't blow your brains off when...

Also these days everybody is talking a lot about Change Data Capture...which is also a worth time for this issue

imani_technology (10/5/2010)

---

And so on. If there is a row in the destination that was not in the source, then the row should be DELETED from the destination. If...

Even better!!:-):-):-)

You might want to implement the Type1 SCD Transformation:-)

My best bet would be that since all these variiables are in the FEL the best would be to assign the value of ZipFileName variable to a fourth variable -...

lolZZZZ:-):-)

da-zero (10/4/2010)

---

Raunak Jhawar (10/4/2010)

---

Lookup is always in favour for the reason that no explicit sort is mandatory and the prior to join and check data can be created on the...

Lookup is always in favour for the reason that no explicit sort is mandatory and the prior to join and check data can be created on the fly while pacakage...

Scott Tobias-328717 (7/14/2006)

---

Can SSIS be used to import and export information to and from LDAP directories?

CanI use SSISto add information to Active Directory? How about other LDAP directories?

If so,...