locked
SSIS Package is not running through code but runs successfully when executed by dtexec utility. RRS feed

  • Question

  • Hi,

        SSIS Package is 2008 , and after migration to sql server 2012 and  from 32 bit server to 64 bit server."Application is running as 32 bit ". After migration , Packages were running successfully except few packages prevalidation failure was seen.So server was restarted. After restart all packages throwing error of Catastrophic failure  when run through Application (BIDS)".But if the package is running sucesssfully if exceuted with dtexec utility. Please help ..


    • Edited by Fabcoder Wednesday, January 21, 2015 10:16 AM
    Wednesday, January 21, 2015 10:14 AM

Answers

  • issue resolved :  to run .dtsx  stored in file system in SQL Server  2012 , both 32bit dll and  64bit dll required.

    • Marked as answer by Fabcoder Friday, January 30, 2015 7:08 AM
    Friday, January 30, 2015 7:08 AM

All replies

  • I assume that you have already upgraded packages to SQL 2012. I had similar type of error and to resolve we had to upgrade package using SSDT and then re-deploying new compiled code solved problem.

    Regards,
    Vishal Patel
    Blog: http://vspatel.co.uk
    Site: http://lehrity.com

    Wednesday, January 21, 2015 12:44 PM
  • packages are not upgraded.
    Wednesday, January 21, 2015 12:56 PM
  • Please upgrade packages. Its recommended to upgrade packages when you move to newer version.

    Packages that are failing will have script task and it will not work until its upgraded.


    Regards,
    Vishal Patel
    Blog: http://vspatel.co.uk
    Site: http://lehrity.com

    Wednesday, January 21, 2015 1:04 PM
  • but packages are working successfully with  dtexec utility . Application exceutes the packages through services.

    Thursday, January 22, 2015 5:08 AM
  • issue resolved :  to run .dtsx  stored in file system in SQL Server  2012 , both 32bit dll and  64bit dll required.

    • Marked as answer by Fabcoder Friday, January 30, 2015 7:08 AM
    Friday, January 30, 2015 7:08 AM