Thanks Phil !! Both the columns NodeID & QuarterID are having records starting from 1. Hence it won't be a issue.

Thanks for the reply. I changed my above query accordingly i.e. the way you have suggested. I hope it will work.

With ExpandedDataset as (
select NodeID, QuaterID
from Nodes
union...

When the above query in the ExecSQL task returns 0 rows, the task is getting failed due to 'Single Row' property.

What can be done to avoid this error & keep...

Table schema I have provided, is the one required. IDENTITY property is defined on that table. Hence I am using IDENTITY_INSERT ON.

Data is populated from the application & not inserted...

• This reply was modified 4 years, 3 months ago by  VSSGeorge.

Yes, I am replacing TRUNCATE with DELETE.  There are around 150 tables in total & for around 80 tables I have to reset the identity. Rest, of the tables, I...

Thanks for the replies. From your expert comments, I could reckon that the query I am using can be changed to the following one, which will serve my purpose.

            
January 10, 2020 at 9:27 am
            
#3714252

            
            
                                                
        

DELETE will be happening as TRUNCATE is not supported, even though I disabled the table constraints. Si I have replaced DELETE instead of TRUNCATE.

I have tested this script by executing...

Thank You Phil..It worked like charm. Both query tweak & SSIS tip worked great for me.

How can it be done? Please explain the steps.

Yes, this query returns a value 4. This value 4 needs to be passed as input parameter value for input parameter @QuaterID.

Thanks, I am using the OLEDB connection.

I want to pass the following query resultset value as input parameter value for @QuaterID.

SELECT QuaterID FROM Nodes WHERE NodeID =...