we dont want to run a trace from SQL Profiler since it will slow down the server. Is there any query or ETL, so that we can get those details...

Hi All,

Both the ways suggested by Dave, like using script component and putting all the data to a table then applying XML Path option worked for me.

As suggested by...

Thanks All !!!

It works.... 🙂

Can you please explain how it can be achieved??

No.. On delete cascade option is not there with FK....

That table contains only 1lac rows.

Table PK:

Table_sr_key, table_eff_strt_dt

Table FK(10 Fks like same structure):

PRD_SR_KEY, EFF_STRT_DT

REFERENCES Product (PRD_SR_KEY, EFF_STRT_DT)

Table is refernced by more than 20 table.

yes... both the package are of same versions.

No.. Rows are not discarded by look up. Because this happened for initial load also. If rows are discarded by look up, then it should not get inserted for second...

By the name of peculiar error, I want to mean the valid records getting rejected and redirected to rejection table.

In the package we will fetch data from different database but...

We execute this package through job agent. Since rejected rows are redirected to a rejection table, so that we cant get proper rejection message. While re-executing that packages through debug...

Hi,

While inserting into destination table through SSIS, some times I am getting a peculiar error. Some times few rows are rejected without any reason. While re-executing those DFTs those rejected...

Thanks now its working.... 🙂

We have to load data from different region wise sources. We have to load all the data in a common DW,which is common for all the regions. Since we have...

If we did the partition then that will insert in different partitions.

My question is if we partition that table then both insertion can be simultaneous. Then table level...