Thanks Luis it works fine

Hi Eirikur Eiriksson,

In out current t-sql we are using tvp, which is taking so much time to produce the o/p.

We are trying to reduce one to many relation in...

HI guys,

Below is the sample Query

--Table Script-----

CREATE TABLE TblMain

(

ID INT IDENTITY(1,1),

Value NVarchar(MAX),

business_unit_list NVarchar(MAX),

Region_list NVarchar(MAX),

category_key_list NVarchar(MAX)

)

INSERT INTO TblMain

SELECT 'Value1','2200,2201,2202,2203,2204','1,3,11,13,14,15,16,17,18','486750000001,486750000002,486750000003' UNION ALL

SELECT 'Value2','2208,2209,2210,2211,2212,2213','45,46,47,48,49,50,51,52,','486750000009,486750000010,486750000011,486750000012' UNION ALL

SELECT 'Value3','2217,2218,2219,2220,2221,2222,2223,2224,2225,2226,2227,2228,2229,2232,2235,2236,2237,223','56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,','486750000006,486750000007,486750000008,486750000009,486750000010,486750000011,486750000012,486750000013,486750000014,486750000015,486750000016,486750000017,486750000018,486750000019,486750000020,486750000021,486750000022,486750000023,486750000024,486750000025,486750000026,486750000027,486750000028,486750000029,486750000030,486750000031,486750000032,486750000033,486750000034,486750000035,486750000036,486750000037,486750000038,486750000039,486750000040,486750000041,486750000042'

-----------------------------------------Scrpit------------------------------------------

DECLARE @I INT=1,@MAX INT,@End INT,@offset...

Thanks for Ur reply MMartin1

I have tried with inner join also, still the same performance issues I am facing.

I have added clustered index on invoiceid,orderid,billid column on tbl_documentdetails...

Yes I have used execution plan and added missing index also.

The query is taking to much time in Nested Loops(Left outer join).

Hi,

The source query is taking very much time to produce the data.

below is a sample query used in source component.

tbl_documents table is having 700 rows and tbl_documentdetails table...

Thanks,

Those 500+ DFT are divided into total 6 packages.

I am looking for solution where we dont need to update the metadata in SSIS manually.

Is there any way if i am...

Thanks Phil,

I cant do find/replace 500 times.That why I am Searching for is there any way to Skip the case sensitivity in SSIS.

Hi Koen,

I have another Issue related to same.

In my SSIS package , I have changed one of table column name from upper case to lower case For Ex."EMPLOYEEID" to "employeeid".

After...

HI PSB,

Make sure that column sequence should be same.

Hi,

Thanks!!!. In my project column names of source and destination table are diffrent. So is ther any way to map individual column between source and destination...

Hi, Jason,

Can you please provide the table structure with data . As well as please explain why is these tow tables are used.

Thanks

Revan