Post reply

SSIS 2014 - "Unable to retrieve column information from the flat file connection manager"

  • July 15, 2015 at 5:41 am

    #309817

    Hello Everyone,

    I've developed a package that is working well at development machine from VS 2013 for a sample flat file.

    Also, over development machine, I've deployed it to SSISDB catalogue and even from there also it is running well for the same file.

    When the same package is deployed to production server's SSISDB catalogue database, it throws following error while processing the same sample flat file,

    “Unable to retrieve column information from the flat file connection manager”

    Can anybody please advise how to trouble shoot this problem?

    Any help would be much appreciated.

    Thanks,

    Ankit

  • July 15, 2015 at 10:09 pm

    #1812839

    This is interesting.

    Have you checked your configuration values? Is it pointing to the same sample file you have used in your development environment.

    ____________________________________________________________

    AP

  • July 19, 2015 at 11:53 pm

    #1813572

    check your configuration file.

  • July 20, 2015 at 12:40 am

    #1813579

    Hello everyone,

    I've resolved this issue. It was due to incorrect version of Coyzeroc tool at production server. After installing the correct version, the problem gets disappeared.

    Thank you for the responses.

    Thanks,

    Ankit

  • July 20, 2015 at 12:55 am

    #1813581

    Hi Ankit

    :-). Carry on man

    Rambabu.

Viewing 5 posts - 1 through 4 (of 4 total)

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