Ah yes, those are UNION ALL components (designated by the (ALL) naming conventions).

I used "merge" in their names because they combine two streams of data together.

You hit F5 in BIDS.

Maybe instead of usinge the default columns code and name, you could just create two seperate attributes, StoreName and StoreNumber?

The code column could be autopopulated like an identity.

Easy one if you remember Toms explanation of the previous QotD:

DECLARE @i INT = 0;

equals

DECLARE @i INT;

SET @i = 0;

Thanks for the question!

What...

You do realize this is a forum with...

Neither.

Which number in the screenshot of the data flow are we...

Take a look at the article of Jeff Moden I linked to.

It's pretty easy to accomplish using some well established methods.

First you can split the data using the "-" as a delimiter using Jeff Modens splitter function[/url].

Then you can concatenate the...

Does SSIS have access and permissions to read the XML config file?

Is the XML config correctly configured? Is the password correct? (not *******, you need to replace it with...

Indu-649576 (8/18/2014)

---

Koen Verbeeck (8/18/2014)

---

This works fine:

DECLARE @b-2 INT;

DECLARE @action VARCHAR(100);

DECLARE @dbname VARCHAR(100);

DECLARE @a INT;

SET @dbname = 'adt';

SET @action = 'dfgf';

SET @a = 14;

SET @b-2 =12;

PRINT('SELECT CASE WHEN ''' + @action...

This works fine:

DECLARE @b-2 INT;

DECLARE @action VARCHAR(100);

DECLARE @dbname VARCHAR(100);

DECLARE @a INT;

SET @dbname = 'adt';

SET @action = 'dfgf';

SET @a = 14;

SET @b-2 =12;

PRINT('SELECT CASE WHEN ''' + @action + '''=''' +...

Which page?

Can you...

Ells (8/18/2014)

---

For the SSIS peeps:

Would a lookup task be perfomant on that size data set. I am not sure of its limits. I was hoping to use the lookup on...

Ells (8/18/2014)

---

From what I have read Partial cache may not be a good option. I am considering Merge Join which will make the inserts and updates on the limited set...