Home Forums SQL Server 2005 SQL Server 2005 Integration Services How to store the Count(*) value fro datareader to int. SSIS 2005 RE: How to store the Count(*) value fro datareader to int. SSIS 2005

  • December 19, 2012 at 11:59 am

    #1570250

    10e5x (12/19/2012)

    Hi phil,

    I heed ur advice and did a debug. It was strange it doesnt return me any data. Hence i read through my script and realize it may be due to that the prog did not read it row by row even though i am only expecting 1 row with 1 column result. Therefore i added in a While(reader.read()).... cycle and it WORKS. although i do not uds why i need a loop when it is only one row, but it does solved my problem.

    Thanks for your help.

    Excellent - I should have noticed that, but well done.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.