I presume this is just an 'out of interest' type question, because when you're deleting exact duplicates from a heap, there is no real row number? You could not use...

Yes, a couple of major reasons come to mind:

* parameters can be at project level (so defined only once and shared by many packages).

* the values of parameters can be...

Ells (11/6/2014)

---

If they are 30 different structured files going to 20 different structured tables then as Phil said there is no magic wand for this in SSIS.

However there is another...

That all depends on how your data is structured.

People here will take the time to provide you with a working query, if you are prepared to take the time to...

previn1980 (11/4/2014)

---

thanks phil

yes, also I think that the DFT is better solution, but what do we use in the DFT to realize "Multiphase Data Pump"?

Do we need of other tasks...

Via a dataflow, but the structure is quite different from DTS, so you've got a bit of a learning curve.

kiran.vaichalkar (11/4/2014)

---

Hi Team,

I have updated the statistics of one of my Fact table containing 3lacs rows of data.

And The query was to join the fact table with other 4 dimension...

Can you just have two loops in series? As it's looping one file at a time, there's no real performance hit.

Or (more efficiently) use instead a script task with just...

TheComedian (11/3/2014)

---

Hi all,

I have about 30 different files and each have to be loaded into its own respective table. I have a Foreach Loop container which loops through the...

vs.satheesh (11/2/2014)

---

Hi

I am working University Automation Project.In this purpose i got a student physical photo in folder and sub folder structure.Now my...

jacksonandrew321 (10/30/2014)

---

Hi Experts

I have created table in which there are four columns (id, date, parcelname, parcelnumber) and 10 rows. I want to count record of the column parcelnumber but condition...

Maybe you could try putting the export to CSV in its own Sequence container?

Can you post a small sample of your data?

Yes – the clustered index or PK will be an important consideration. Will existing data pages need to be reshuffled on disk to accommodate the data being inserted?

That's a new one for me, but I hope I've learned my lesson in the process.

I just had to dig that file out of the original ISO archive and add...