首页 > 其他 > 详细

SSIS Package Deploy ActiveBatch some error

时间:2020-12-01 12:28:14      阅读:39      评论:0      收藏:0      [点我收藏+]

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;
}
}

SSIS Package Deploy ActiveBatch some error

原文:https://www.cnblogs.com/HuairongChen/p/14066916.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!