Home Forums Data Warehousing Integration Services Any possibilities to save the message tab information in SSIS RE: Any possibilities to save the message tab information in SSIS

  • April 23, 2014 at 6:47 am

    #1708070

    Tony1234 (4/23/2014)

    Hi Lempster,

    Thank You very much for your replay.

    Exactly I am expecting row count. But the approach you have mentioned will not workout for my scenario because, I am executing query file (.sql) as SQLSourceType as File connection in my execute sql task.

    Thanks,

    Tony.

    I don't know a way of doing this directly. Maybe you can load the query from the file into a string variable, append SELECT @@ROWCOUNT, then execute that?

    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.