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

    #1231584

    sqlusers (10/5/2010)

    Phil Parkin (10/5/2010)

    Why does your data source contain a WHILE loop?

    Actually, i need to get the data's according to From and To Date from a table. So for that i used this while loop.

    Even i used NOCOUNT ON. But sorry i didn't get the columns yet.

    Why not a WHERE clause? Sounds like you're getting the records one at a time?