Post reply

SET PACKAGE VARIABLES FROM RESULTS OF SQLDATAREADER

  • February 20, 2008 at 6:29 pm

    #124035

    I have an SSIS script task in which I am first capturing data from an SQL server table by using ado.net and a SQLDataReader into declared variables.

    I am them trying to assign those variables to the value of the dts.variables for the package, but continue to get an error.

    Please advise

  • February 21, 2008 at 3:03 am

    #780555

    Hi,

    Have you added the name of the package variables you wish to set within the script task into the ReadWriteVariable property of the script task?

    Regards

    Daniel

  • February 21, 2008 at 8:29 am

    #780680

    Yes. There are 2 of them, separated by a comma and each with a data type of int32.

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

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