使用脚本组件更新ssis中的odbc表? [英] Using script component to update odbc table in ssis?
问题描述
您好,
您可以为< g class =" gr_ gr_52 gr-alert gr_gramm gr_inline_cards提供脚本组件更新声明gr_run_anim Grammar only-ins doubleReplace replaceWithoutSep"数据-GR-ID =" 52" ID = QUOT; 52"> ODBC< / g取代;
table。
我正在将数据从Flat File加载到MySQL数据库表。
Flat文件包含以下列和数据。
日期 SiteID
LastSynch NET_SLS_AMT
2019-01-29 00:00:00 1
2019-02-05 22:11:26.713000000 45292.1700
2019-01-29 00:00:00 4
2019-02-05 22:11:26.713000000 26233.5000
2019-01-29 00:00:00 < span style ="white-space:pre"> 6
2019-02-05 22:11:26.713000000 37091.4200
2019-01-29 00:00:00 8
2019-02-05 2 2:11:26.713000000 43417.6400
2019-01-29 00:00:00 9
2019-02-05 22:11:26.713000000 46680.6700
2019-01-29 00:00:00 11
2019-02-05 22:11:26.713000000 47035.7900
使用来源:Flate文件
目的地:脚本组件(用于加载更新的数据)。
您能否提供更新的脚本组件 C#中的代码
谢谢,
Sreekanth
sreekanth kancharla
您好,Sreekanth,
请检查此链接:
Hi,
can you please provide the script component update statement for <g class="gr_ gr_52 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar only-ins doubleReplace replaceWithoutSep" data-gr-id="52" id="52">odbc</g> table.
I am loading the data from Flat File to MySQL database table.
Flat File having the following columns and data.
Date SiteID
LastSynch NET_SLS_AMT
2019-01-29 00:00:00 1
2019-02-05 22:11:26.713000000 45292.1700
2019-01-29 00:00:00 4
2019-02-05 22:11:26.713000000 26233.5000
2019-01-29 00:00:00 6
2019-02-05 22:11:26.713000000 37091.4200
2019-01-29 00:00:00 8
2019-02-05 22:11:26.713000000 43417.6400
2019-01-29 00:00:00 9
2019-02-05 22:11:26.713000000 46680.6700
2019-01-29 00:00:00 11
2019-02-05 22:11:26.713000000 47035.7900
am using Source: Flate file
Destination: Script Component ( to load the updated data).
Can you provide the Script Component updated code in C#
Thank You,
Sreekanth
sreekanth kancharla
Hi Sreekanth,
Please check this link:
这篇关于使用脚本组件更新ssis中的odbc表?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!