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:44 am

    #1231600

    Leo Suresh (10/5/2010)

    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.

    ohh... yes, i use table variable inside. Let me check. Thanks Leo.