Home Forums SQL Server 2005 SQL Server 2005 Integration Services Not displaying Columns in OLEDB Source RE: Not displaying Columns in OLEDB Source

  • October 5, 2010 at 5:32 am

    #1231594

    I guess you are using table variable inside your SQL query. If that is the case, then OLEDB source task will not generate the columns.

    Use a stored procedure instead of the SQL script, this will generate the columns.