解å³åæ³ï¼
1.æå¼Microsoft Visual Studio.
2.æ件-æ°å»º-项ç®-Integration Services 项ç®.
3.å称任æå®ä¹,å¨è¿éå称为:CsvImportSqlserver,å¾é"å建解å³æ¹æ¡çç®å½"
4.å¨"æ°æ®æµ"ä¸,ç¹å»é¡µé¢èè²åæ¯,è¿å
¥ç¼è¾åº.
5.éæ©å·¦ä¾§å·¥å
·ç®±,éæ©"å¹³é¢æ件æº"å"OLE DB ç®æ "æ§ä»¶æå¨å°ç¼è¾åº.
6.éä¸âå¹³é¢æ件æºâï¼å³é®éæ©ç¼è¾,å¼¹åºâå¹³é¢æ件æºç¼è¾å¨âçªå£.
7.å¨âå¹³é¢æ件è¿æ¥ç®¡çå¨âä¸ï¼ç¹å»âæ°å»ºâæé®ã
8.è¿æ¥ç®¡çå¨ï¼ImprotFileï¼ä»»æèµ·åï¼ï¼å¨å¸¸è§ä¸ï¼æµè§è¦å¯¼å
¥çcsvæ件çæå¨è·¯å¾ï¼å¦ï¼test_1.csvï¼ã
注æï¼å¾éï¼å¨ç¬¬ä¸ä¸ªæ°æ®è¡ä¸æ¾ç¤ºåå称ï¼
9.é»è®¤âåâç设置ï¼å¨âé«çº§âä¸ï¼å¹é
æ°æ®ç±»åä¸è´ã
ç®æ æ°æ®åºä¸ï¼intç±»åçå段-ãå¨é«çº§ä¸ï¼è®¾ç½®âååè带符å·çæ´æ° [DT_I4]â
varcharç±»åçå段-ã设置âå符串 [DT_STR]â注æï¼ç±»åç大å°ã
smallintç±»åå段-ã设置âååè带符å·çæ´æ° [DT_I2]â
decimalç±»åçå段-ã设置âå精度浮ç¹æ° [DT_R8]â
10.ç¹å»ç¡®å®ï¼éä¸âå¹³é¢æ件æºâï¼å³é®âæ·»å è·¯å¾âï¼è¿æ¥èªï¼å¹³é¢æ件æºï¼è¿æ¥è³ï¼OLE DBç®æ
è¾åºï¼å¹³é¢æä»¶æº ï¼ è¾å
¥ï¼OLE DBç®æ è¾å
¥ã
11.设置åï¼å¨ç¼è¾åºåç°æ个ï¼å¹³é¢æ件æº-ãOLE DBç®æ è¾å
¥ï¼çæåç®å¤´ã
12.æ¥ä¸æ¥ï¼éä¸ï¼OLE DBç®æ ï¼ï¼å³é®ç¼è¾ã
13.æ°å»ºOLE DB è¿æ¥ç®¡çå¨ã
14.æå¡å¨åï¼IPå°åï¼172.26.36.6ï¼
15.å¨éæ©æè¾å
¥ä¸ä¸ªæ°æ®åºåä¸ï¼éæ©è¦å¯¼å
¥å°çæ°æ®åºï¼å¦ï¼DWï¼
16.ç¹å»âæµè¯è¿æ¥âï¼æ示è¿æ¥æåï¼ç¡®å®å¹¶å
³éçªå£ã
17.æ¥ä¸æ¥ï¼å¨âæ°æ®è®¿é®æ¨¡å¼âä¸ï¼è¡¨æè§å¾ã
18.表æè§å¾å称ï¼æ°æ®åºä¸ç¸å¯¹åºç表ï¼teståºã
19.å¨âåºå°âä¸ï¼è®¾ç½®é个å段ä¸ä¸æ å°ã
20.ç¹å»ç¡®å®ã
21.ç¹å»F5ï¼è¿è¡è°è¯ï¼çæ°æ®æ¯å¦å¨æ£ç¡®å¯¼å
¥ã
(å¦ææ¥éï¼éæ°è®¾ç½®æ°æ®ç±»å)
22.ç¹å»âæ§å¶æµâï¼éä¸æ§ä»¶Foreach 循ç¯å®¹å¨ï¼æå°ç¼è¾åºã
23.æâæ°æ®æµä»»å¡âæ¾å
¥âForeach 循ç¯å®¹å¨âä¸
24.éä¸âForeach 循ç¯å®¹å¨âï¼å³é®ç¼è¾ã
25.å¨âéåâé项-æ举å¨é
ç½®ï¼éæ©csvæ件æå¨çæ件夹ã
26.æ件å以æ£å表达å¼çæ¹å¼è¾å
¥ï¼å¦(test_*.csv)
27.åéæ å°ï¼å¨åéåä¸æ项ä¸ï¼ç¹å»âæ°å»ºåéâï¼å称ï¼var_testï¼å
¶ä»é»è®¤ï¼ç´æ¥ç¹å»ç¡®å®ã
28.å¨ç¼è¾åºå·¦ä¸è-è¿æ¥ç®¡çå¨ä¸ï¼éä¸âImprotFileâå³é®å±æ§ï¼
29.ç¹å»expressionsåé¢çç¼è¾æé®ï¼å±æ§ï¼ConnectionStringï¼è¡¨è¾¾å¼ï¼éæ©âvar_testâåéï¼å¹¶æå®æå°â表达å¼âåºåã
30.ç¡®å®åï¼å¼å§F5ï¼å¼å§å¯¼å
¥éåä¸ææcsvæ件.
31.è³æ¤,ææ设置å®æ¯ã
åçï¼è¦æ³ææ°æ®åºè¡¨ï¼å¯¼åºcsvæ件ï¼ä¹ä¸æ ·éçã
足ç å¦ï¼å½å¯¼å
¥ä¸ä¸ªcsvæ件æ¶ï¼å¯ä»¥æ ¹æ®sqlserver导å
¥å¯¼åºå导就å¯ä»¥ã
å
·ä½æä½å¦ä¸ï¼
1.éä¸æ°æ®åºtestï¼å³é®-ä»»å¡-导å
¥æ°æ®ã
2.ç¹å»âä¸ä¸æ¥âæé®
3.æ°æ®æºéæ©ï¼å¹³é¢æ件æº
4.å
¶ä»é项ï¼ä¸ä¸è¿°ä¸è´ãï¼æ°æ®ç±»åä¸å®è¦å¹é
æ£ç¡®ï¼
5.ä¸ä¸æ¥ï¼è¾å
¥æ£ç¡®çæå¡å¨å称ï¼æ°æ®åºå称ã
6.å¨â表åè§å¾âä¸ï¼âæºâä¸âç®æ âç表è¦æ å°æ£ç¡®ã
7.ä¸ä¸æ¥ï¼éæ©âç«å³è¿è¡âã
8.ç¹å»å®æï¼å¼å§å¯¼å
¥ã
温馨提示:答案为网友推荐,仅供参考