posts - 50,comments - 0,views - 20251

errorCode = c0209303, description='The requested OLE DB provider Microsoft.Jet.OLEDB.4.0 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode. Error code: 0x00000000.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered"'
22:31:50 W SsisError(errorCode = c020801c, description='SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "QCBackend_v2" failed with error code 0xC0209303. There may be error messages posted before this with more information on why the AcquireConnection method call failed'
22:31:50 W SsisError(errorCode = c0047017, description='OLEDB_Source_PreStage_QCAudit failed validation and returned error code 0xC020801C'

 

.mdb File Insert into DataBase,Use  Run64BitRuntime to False

 

 

If also Not Sucess,You must Chaged other Provider Microsoft Office 12.0 Access Database Engine OLE DB Provider

 

 

 

Show Variables to Check Read Config true or false

 

 

 

Modify .cs Code

public void Main()
{
StringBuilder myString = new StringBuilder();

foreach (Variable item in Dts.Variables)
{
myString.Append(item.Name + ": " + item.Value + "\n");
}

DialogResult result;
result = MessageBox.Show(myString.ToString(), "Are these parameters correct?", MessageBoxButtons.YesNo);

if (result == DialogResult.Yes)
{
Dts.TaskResult = (int)ScriptResults.Success;
}
else
{
Dts.TaskResult = (int)ScriptResults.Failure;
}
}

posted on   HuairongChen  阅读(165)  评论(0编辑  收藏  举报
编辑推荐:
· AI与.NET技术实操系列:基于图像分类模型对图像进行分类
· go语言实现终端里的倒计时
· 如何编写易于单元测试的代码
· 10年+ .NET Coder 心语,封装的思维:从隐藏、稳定开始理解其本质意义
· .NET Core 中如何实现缓存的预热?
阅读排行:
· 分享一个免费、快速、无限量使用的满血 DeepSeek R1 模型,支持深度思考和联网搜索!
· 基于 Docker 搭建 FRP 内网穿透开源项目(很简单哒)
· ollama系列01:轻松3步本地部署deepseek,普通电脑可用
· 25岁的心里话
· 按钮权限的设计及实现
< 2025年3月 >
23 24 25 26 27 28 1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30 31 1 2 3 4 5

点击右上角即可分享
微信分享提示