Post reply

ResultSet as an Object Variable

  • August 13, 2008 at 1:19 pm

    #211234

    Hi,

    I need help understand how-to-read from an Object type Variable.

    In my package:

    Execute SQL Task 1:

    SELECT ID,Surname,Firstname FROM LOCALDB.dbo.USER_LIST

    Result Set maps to a variable:

    Name Scope DataType Value

    MyList Package Object System.Object

    (This task executes without a problem)

    Execute SQL Task 2:

    I want to achieve simply

    INSERT ID,Surname,Firstname FROM WEBDB.dbo.USER_LIST

    SELECT ID,Surname,Firstname FROM [User::MyList]

    How can I read from [User::MyList] variable to insert into WEBDB.dbo.USER_LIST ?

  • August 14, 2008 at 6:11 am

    #857981

    Why aren't you using a data flow task?

  • August 15, 2008 at 3:03 pm

    #859003

    OK.

    I need to append to WEB.DB.dbo.USER_LIST table (Server: WEB User ID: WebUser Pwd: WebPass)

    Reading records from LOCAL.DB.dbo.USER_LIST table (Server: LOCAL User ID: Local User Pwd: LocalPass)

    Here is my logic:

    1. Select max(ID) as maxID from WEB.DB.dbo.USER_LIST

    2. Select fields... from LOCAL.DB.dbo.USER_LIST where ID > max(ID)

    3. Insert WEB.DB.dbo.USER_LIST fields...

    I don't want to use explicit file to store new list in step2.

    What would you like to suggest?

    Thank you.

  • August 18, 2008 at 4:45 am

    #859346

    You should get a book or search around this site and search google for how to use SSIS to transfer data. What you are doing is fairly simple and should be covered by a basic example of how to use SSIS.

Viewing 4 posts - 1 through 3 (of 3 total)

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