Post reply

Capture value from INSERT statement in SSIS Execute SQL Task

  • January 18, 2013 at 1:04 pm

    #1578860

    As it turns out, this was so simple and obvious I'm embarrassed. :blush: Here's my code:

    DECLARE @EmployeeIDs TABLE(FirstName VARCHAR(30), LastName VARCHAR(30), PhoneNumber VARCHAR(50), Title VARCHAR(50), EmployeeID VARCHAR(6), Location VARCHAR(30))

    INSERT INTO @EmployeeIDs

    SELECT givenName,sn,telephoneNumber,title,cn,

    physicalDeliveryOfficeName

    FROM OPENQUERY(adlink,

    'select givenName,sn,telephoneNumber,title,cn,

    physicalDeliveryOfficeName,displayName,whenCreated

    from ''LDAP://myserver/dc=mydomain,dc=com''

    where userAccountControl <> 514

    and objectCategory=''user'' and objectClass=''user''')

    WHERE whenCreated >= getdate()-1

    INSERT INTO mobile.Employee

    (FirstName,LastName,PhoneNumber,Title,EmployeeID,Location)

    (SELECT FirstName,LastName,PhoneNumber,Title,EmployeeID,Location

    FROM @EmployeeIDs)

    Now I can add more T-SQL to do what I need from in my next two operations by pulling EmployeeID from @EmployeeIDs

Viewing post 1 (of 2 total)

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