The results look good to me.

I just wanted to make sure the final version does not contain any weird stuff...

By the way can you suggest any good site or book...

Lynn,

Of course final version would look like you suggested.

It's just a raw code that I throw into the board.

So based on Matt's suggestion

here is my final version.

It runs 15 sec....

Lynn Pettis is closer to the truth.

I am running it now.

It's already 25 min and not finished yet.

But it could be wrong indexes.

mst.CICS_DIM has 745,752 records

stg.STG_CUSTOMER_INTEG has 28,000 records

Lynn,

Can i...

NULL,

How about my main issue? INNER JOIN OR...

That's where the problem is.

Your query handles only one scenario.

STG_CUSTOMER_INTEG.CUST_CIS_ID = mst.CICS_DIM.CUST_CICS_ID

I have 5 scenarios.

I need to do something like

...

INNER JOIN...

Thank you very much Bob.

This is a really good stuff.

Here is my schema:

create table stg.STG_CUSTOMER_INTEG1

(

RECORD_ID int identity(1,1),

CUST_ID int,

CUST_NAME varchar(100)

)

CUST_IDRECORD_IDCUST_NAME

----------------------------------

NULL 493164RBC Group

NULL 865669CIBC

NULL ...

Resolved myself.

Apparently when I expanded Sequence Container

I saw some orphan connectors. Just connectors, no tasks.

When I removed those I was able to delete Sequence Container.

Figured out myself.

It should be:

SELECT

IG_SRC_SYS_KEY = CASE

WHEN LEFT(ci.IG_CD,1) = 'D' THEN (SELECT SRC_SYS_KEY FROM SOURCE_SYSTEM_REF WHERE SRC_SYS_ID = 'DDA')

WHEN LEFT(ci.IG_CD,1) = 'G' THEN (SELECT SRC_SYS_KEY FROM SOURCE_SYSTEM_REF WHERE SRC_SYS_ID =...

Yes.

Data access mode "SQL command" is a really bad option.

Once I switched to "table or view - fast load"

it took 30 sec to insert 200,000 records.

It's good enough for me.

So...

I tried SQL Server Destination component

and got an error:

Could not bulk load because SSIS file mapping object 'Global\DTSQLIMPORT ...

I also noticed in my OLE DB Destination

in "Data access mode" I used "SQL command" option to make mapping easier so that

I only see the columns to which I insert....

GSquared,

Thank you for a good idea!

BETWEEN, of course! That's what will help.

I was planning to do the same thing.

But how about INT or SMALLINT, for example?

There is no such thing as IsSmallint()

I tried to do it in a function

but without TRY/CATCH...

noeld,

Your example will only insert XML document into "BulkColumn" (XML data type)

column of table T1.

That's not what I'm looking for.

What I'm looking for is to transfer XML data into SQL...

It's a COM object.

But I was looking for a simple BCP command

using format file. Similar to BCP text file to SQL table.

I understand maybe BCP can not be used

with...