Post reply

Execution SSIS-package from SQL Server-Agent fails

  • May 27, 2013 at 5:17 am

    #394854

    Hi,

    there is a SSIS-package, that runs properly in Visual Studio.

    It has a for-each-container wich loops a file-directory within flat-files.

    There is a variable "fullpathsource" for a flatfile-connection, that is combined of (static) path and file-name from for-each-container.

    Before the for-each runs, variable "fullpathsource" contains only the path.

    That's what the 2012 Agent remarks: flat-file-connection is not valid.

    Thanks in advance for any hint.

    Regards

    Matze

  • May 27, 2013 at 8:52 am

    #1618799

    Hi again,

    I changed the ssis package property to "not save sensitive data", but thad didn't help.

    Still have to mention, that there are allready several packages running by SQL Agent - without any problems.

    Regards

    Matze

  • May 27, 2013 at 2:46 pm

    #1618822

    Have used a proxy-account. I did not help either.

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

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