Recordset destination in SQL Server 2005

  • Hi, I am working on Recordset destination in SQL server 2005, But the problem is:

    Whenever I am trying to specify a variable name : "It says that variable name property is not set to the name of a valid variable. Need a runtime variable name to write to."

    Can anyone help in this regard.

    Thanks in advance.

  • Provide some piece of code. that would be better to understand the problem...

    "Don't limit your challenges, challenge your limits"

  • Hi,

    I am not using any code or script for this. I am trying to import multiple files for a folder using for eachloop container.

  • ruchi (6/4/2009)


    Hi, I am working on Recordset destination in SQL server 2005, But the problem is:

    Whenever I am trying to specify a variable name : "It says that variable name property is not set to the name of a valid variable. Need a runtime variable name to write to."

    Can anyone help in this regard.

    Thanks in advance.

    You have to use user variable of type Object.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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

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