Ok, I will work on it.

cheers.

Yep, that's already in place.

The only thing which I am concerned about is running multiple packages in parallel. I have 16 processors running on my server and I want to...

There are various interfaces which are independent, so they would be executed in parallel. However, we've a changing req. and in future there would be more interfaces coming and we...

You have to do it at SQL level only, perform data validation check and move that row to another table which will store bad records.

Sorry, I don't have the deadlock graph available.

In JOB1 - I have a file to table load via SSIS (fast table load)

In JOB2 - I am fetching some data from...

I've created this query, it is giving me desired results, but I am not sure if it is correct.

;WITH CTE AS

(

SELECT *

,NTILE(2) OVER (PARTITION BY id,rn ORDER BY descr DESC)...

Keeping amount as individual sets

AMOUNT | STAGE

10 | 4 } 1st SET

10 | 3...

This is because.

One process for amount 10 was started @ 3 and ended @ 4.

But, for another amount 10 process started @3 and has not ended yet. So the latest...

Actually the data comes in sets.

1 set contains two...

Here's a simple one -

select AttribName AS Attribute

,CASE WHEN ISNUMERIC(AttribValue)=1

THEN 'NUMERIC'

WHEN LEN(ATTRIBVALUE) = 1 AND ISNUMERIC(AttribValue) = 0

THEN 'ALPHABET'

ELSE 'ALPHANUMERIC'

END

from #Test123

Load all data to your destination server and then use MERGE there.

I hope it would be faster and easier to use.

vipin_jha123 (7/30/2015)

---

Hi Becouse As I explained earlier I am having 2 source connection for US .

Out of 3 DFT 2 DFT have sourceA and Last DFT have difrent source.

For each...

It seems none of the queries are correct. Correct one is:

ALTER DATABASE AdventureWorks2012

MODIFY FILE (NAME=AdventureWorks2012_data, NEWNAME=AWD2012 );

I guess using a foreach loop will do.

1>Fetch conn string, table names from master_table.

2>Foreach

[

Your DFT's here.

]

You can use a CTE if required. If you can provide some more...