Home Forums SQL Server 2005 SQL Server 2005 Integration Services SSIS - OLE DB Source task Error RE: SSIS - OLE DB Source task Error

  • September 27, 2012 at 3:11 am

    #1542764

    Phil Parkin (9/27/2012)

    Is the ResultSet property of the ExecuteSQL task set to SingleRow?

    Have you mapped 'TableExists' to your package variable on the Result Set property page?

    Yes Phil. It is SingleRow and result set mapped to package variable.

    Result set page setting:

    Result name: 0

    Variable Name: User::AccessTable

    Thanks