#temp_Mainhier contains around 500000 and #temp_SecondaryHierLeaf contains around 200000 records.

• This reply was modified 5 years, 6 months ago by  sqlenthu 89358. Reason: Rectified the numbers

Thanks for the information. This was helpful and u have gone through this page already. Got the objects involved in deadlock. My concern is why it may come at same...

I got it. The issue was that the check constraint defined on source target tables was not defined with "with check" condition. Once done it worked fine.

I am getting following error while switching partition:

Msg 4972, Level 16, State 1, Line 2
ALTER TAVLT SWITCH statement failed. Check constraints or partition function of source table...

I want to do it using t-sql and not SSIS. trying to do it using partition switch from 10 non partitioned tables to one partitioned table. Getting some roadblocks. Does...

It was awesome Chris and apologies for not able to reply back as I was on vacation. The code works like charm. Though I have one more connected issue. Please...

Also is there a way to handle UNC path configuration as source folder for picking up files to be loaded ? From my local path, package works wonder.