cbrammer1219 (11/10/2014)

---

Hi I have a bit of a dilemma I am wanting to creating a column based on a value in a flatfile, and insert that value into the destination...

MMartin1 (11/6/2014)

---

There is also the 2208 SSIS book written by Knight and team. Professional Microsoft SQL Server 2008 Integration Services (Knight, Veerman, Dickinson, Hinson and Herbold) from Wrox. It is...

g.britton (11/6/2014)

---

The...

No problem, thanks for posting back.

Nasty.

I think I'd do it like this.

As your OLEDB source, have a query which gives you an ordered resultset

CompanyInfo1, CompanyInfo2, CustomerInfo1, CustomerInfo2 etc

order by Company, Customer

Of course, this is...

aarionsql (11/6/2014)

---

Thank you for your reply Phil ..

From your experience can you get Project Level parameters to be used in SSIS expressions along with other variables?

So you it be...

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...