在 MS SQL 2008R2 环境中执行简单的 ssis 包时生成异常 0x80040154 [英] Exception 0x80040154 generated while executing a simple ssis package in MS SQL 2008R2 enviornment

问题描述

您好，我尝试执行一个简单的 SSIS 包.基本上我正在读取一个平面源文件，根据 id 对其进行排序，然后再次写入一个新的平面源文件目标.但是当我执行我得到以下异常:

Hello I tried executing a simple SSIS package. Basicall I am reading a flat source file, sorting it on id and again writing in a new flat source file destination. But when I execute i get following exception:

启动项目失败

附加信息:

我浏览了很多论坛，他们大多关注 32 位 64 位问题，并坚持重新安装 MS SQL 服务器.我不确定这个异常，因为它是针对不同场景和问题的常见错误.只是想知道以前是否有人遇到过类似的问题?

I browsed through lot of forums and mostly they focused on 32-bit 64 bit issue and insisted on reinstalling the MS SQL server again. I am not sure about this exception since its a commonly generated error for different scenarios and issues. Just wanted to know if anybody has faced a similar issue before?

推荐答案

产生异常的主要原因是，我试图在 64 位环境中运行 32 位 SSIS 包.因此，解决方案是通过将其设置为 false 来简单地更改属性值之一Run64BitRunTime".您可以在解决方案资源管理器下的解决方案属性中找到这一点

The exception was being generated primarily because, I was trying to run a 32 bit SSIS package on 64 bit environment. So Solution for this to simply change one of the properties value "Run64BitRunTime" by setting it to false. You can find this in properties of solution present under solution explorer

这篇关于在 MS SQL 2008R2 环境中执行简单的 ssis 包时生成异常 0x80040154的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！