Post reply

Grab value from a field into a variable

  • October 6, 2010 at 1:11 pm

    #148925

    I have a TempFile table that holds the fileId and EntId from separate tables.

    ex

    ID FileID EntID

    1 3 4

    2 4 5

    Here ID is identity(1,1)

    I want to grab this EntID for the corresponding FileId in SSIS through a variable . I want to pass this value from the variable in to other tables.

    I am inserting into the TempFile table using the sp given below through an execute sql task

    CREATE PROCEDURE [dbo].[usp_GEtAllIDS]

    (

    @CMD_File_ID BIGINT

    )

    AS

    BEGIN

    INSERT INTO dbo.GetIds (CMD_File_ID,Contract_Entity_ID)

    SELECT CF.File_ID ,

    CE.Entity_ID

    FROM dbo.Staging_Entities CSE

    INNER JOIN dbo.Files CF

    ON CF.File_ID = CSE.File_ID

    INNER JOIN dbo.Contract_Entities CE

    ON CE.Contract_Entity_Tax_ID = CSE.Entity_TIN

    END

    How do I get the EntID for each FileID ?

    Please help

  • October 6, 2010 at 1:23 pm

    #1232977

    Start by reading what's on this [url= http://www.sqlis.com/post/The-Execute-SQL-Task.aspx%5Dpage.%5B/url%5D


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply