如何在SSIS中使用C#将文件加载到sql server中 [英] how to load fixed with file into sql server using C# in SSIS
问题描述
< g class =" gr_ gr_37 gr-alert gr_tiny gr_spell gr_inline_cards gr_run_anim ContextualSpelling multiReplace"数据-GR-ID =" 37 QUOT; ID = QUOT 37 QUOT; I标记< / g取代; < g class =" gr_ gr_38 gr-alert gr_gramm gr_inline_cards gr_run_anim Style
multiReplace"数据-GR-ID =" 38" id =" 38">拥有。< / g>固定宽度的DAT文件,如下所示。
<g class="gr_ gr_37 gr-alert gr_tiny gr_spell gr_inline_cards gr_run_anim ContextualSpelling multiReplace" data-gr-id="37" id="37">i</g> <g class="gr_ gr_38 gr-alert gr_gramm gr_inline_cards gr_run_anim Style multiReplace" data-gr-id="38" id="38">have .</g>DAT file with fixed width like below.
column1 &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;位置(1:8)INTEGER EXTERNAL,
column2 &NBSP; &NBSP; &NBSP; POSITION(450:457)DATE" YYYYMMDD",
column3 &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; POSITION(26:28)INTEGER EXTERNAL,
column4 &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; POSITION(10:15)CHAR,
column5 &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; POSITION(34:34)CHAR,
column6 &NBSP; &NBSP; POSITION(36:36)CHAR,
column7 &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; POSITION(38:38)CHAR,
column1 POSITION(1:8) INTEGER EXTERNAL,
column2 POSITION(450:457) DATE "YYYYMMDD",
column3 POSITION(26:28) INTEGER EXTERNAL,
column4 POSITION(10:15) CHAR,
column5 POSITION(34:34) CHAR,
column6 POSITION(36:36) CHAR,
column7 POSITION(38:38) CHAR,
我想用C#将此文件加载到sql server中。
i wanted to load this file into sql server using C#.
推荐答案
您好VSTODEv,
Hi VSTODEv,
SSIS有平面文件来源以外的适配器框来处理您的方案。不需要c#。
SSIS has Flat File Source Adapter out-of-the-box to handle your scenario. No need for c#.
请看这里:
SSIS - 如何将固定宽度文本文件加载到SQL Server表
SSIS - How to Load Fixed Width Text File to SQL Server Table
这篇关于如何在SSIS中使用C#将文件加载到sql server中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!