Forum Replies Created

Viewing 15 posts - 1 through 15 (of 233 total)

  • Reply To: Executing stored procedure from SSIS

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

  • Reply To: Executing stored procedure from SSIS

    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...
  • Reply To: Executing stored procedure from SSIS

    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...

  • Reply To: Updating a column value without intermediate column

    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, 11 months ago by  VSSGeorge.
  • Reply To: Clearing the data from all the tables

    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...

  • Reply To: Clearing the data from all the tables

    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

  • Reply To: Clearing the data from all the tables

    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...

  • Reply To: Executing stored procedure from SSIS

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

  • Reply To: Executing stored procedure from SSIS

    How can it be done? Please explain the steps.

  • Reply To: Executing stored procedure from SSIS

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

  • Reply To: Executing stored procedure from SSIS

    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 =...
  • Viewing 15 posts - 1 through 15 (of 233 total)