Post reply

SSIS Error Message - screenshot attached

  • October 25, 2015 at 11:28 am

    #312451

    For the below query in an SSIS package(In data flow task) I get the following error as in the attachments.

    SELECT value,

    cast(@@servername as varchar(255)) as Servername,

    cast(SERVERPROPERTY('Collation')as varchar(255)) as Collation,

    cast (SERVERPROPERTY('BuildClrVersion') as varchar(255)) BuildClrVersion

    FROM sys.configurations

    --WHERE name = 'backup compression default'

    When I click OK I get to see the query results in preview mode.How do I fix this.

    Responses are appreciated.

    Thanks

  • October 25, 2015 at 12:15 pm

    #1835426

    It's a warning, not an error. If you're happy with the suggested alternative, just go ahead.

    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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply