Post reply

SSIS package fails when running from a command line or in SQL Agent

  • October 7, 2013 at 8:33 am

    #278709

    I have a SSIS package that runs great in BIDS and from dtexec gui with the package stored on the target server. But when I try to execute from a command line it fails. It gives me a whole bunch of errors saying the an item in my control flow task needs to be upgraded. The control in question is a Sharepoint connector (http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652). Which is all on the correct version.

    One issue I can think of. The package was made on a 32bit machine and the target is 64bit. But what puzzles me is that it runs with no errors from the dtexec gui while connected to SSIS on the server through SSMS.

    Any ideas/help is much appreciated.

    Thanks.

  • October 8, 2013 at 6:05 am

    #1656691

    Nevermind, I figured it out. I had to re-load the connector on the target SQL server. It must have loaded a different SQL verison in the default install. I Also had to tweak the security level set in BIDS to encrypt with password.

    Thanks for reading.

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

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