I have a query that pulls from 4 tables. Each table is very large, over 1 million records each. I need to combine them with left joins; however,...

Steve Jones - SSC Editor (8/26/2013)

---

You could parameterize this path, so the package reads something from the local instance at runtime. That way if you have the local instance with...

Alexander Suprun (6/7/2013)

---

How existence of different files in a folder can impact anything?

[/Quote]

It doesn't. That isn't the problem.

[Quote]

Do you load all the files into a staging table and...

Anyone? Bueller?

Phil Parkin (4/23/2013)

---

A possible problem for you is where your input file suddenly contains durians and kumquats and you have not built the conditions for directing these new fruits into...

Phil,

I would tend to agree with you, the the practice has been in place for a while now. The main reason is that they are using VM instances of...

Phil,

As always, thanks for your input, or.... Conditional Input... BUAH!!! LOL...

I checked this out and its totally cool; however, I have another question (just like a 6...

Hey Phil!

Flow is as follows:

Text File --> Raw Table --> Staging Table --> Production Staging Table (Different VM) --> Production Table.

A lot, if not all of the Transformations happen in...

I'm not a .Net developer and have very little familiarity with creating utilities so this option wouldn't work for me with out turning it into a project that would require...

Phil Parkin (2/26/2013)

---

What version of SSIS are you using?

I THINK the answer is 2005, or Visual Studio 2005, pkgs save as DTSX

I sympathise. Can you confirm that...

Phil,

Here's what I got:

Before...

Phil, I will Phollow your advice, although I think I did number 1 already...

Thanks

Crusty

Oh.... Wow... I have a friend that can't stop his team in India from calling him Brain.... I'm sure you can figure that one out...

I'll have to tell...

Lewis / Gail.

Thanks Bunches for your help. Yes, I'm a dork, but I'm an appreciative dork.

I used the ITVF and discovered that my dataset has some alpha characters as...

You guys...(gals) is da bomb...(sniff sniff)... I'm going to name my next kid after you two....