SSIS 脚本组件相关
在脚本组件里 设置一个object 类型的变量为只读,将此脚本组件设置为源(可以保证变量是有值的) 存的时候用的是DataTable类型
然后脚本里代码
public override void CreateNewOutputRows()
{
/*
Add rows by calling the AddRow method on the member variable named "<Output Name>Buffer".
For example, call MyOutputBuffer.AddRow() if your output was named "MyOutput".
*/
Debug.WriteLine("213123123");
var adapter = new OleDbDataAdapter();
var dt = new DataTable();
adapter.Fill(dt, Variables.DtChange);
foreach (DataRow dr in dt.Rows)
{
Debug.WriteLine(string.Format("order:{0} start.....",dr["ORDERNO"].ToString()));
OrderBuffer.AddRow();
OrderBuffer.FBillNo = dr["ORDERNO"].ToString();
OrderBuffer.FInterID = int.Parse(dr["k_id"].ToString());
OrderBuffer.FTranType = 71;
OrderBuffer.FBrNo = "0";
}
}
下面链接一个 oledb目标
设置好了相关操作。但是不能正常同步数据,是我缺什么设置吗