SSIS ETL data from oracle to MS sql server

SamSam
2 min readMay 27, 2019

--

SSIS Visual Studio 2017
起初還以為這個選項很簡單咧… 誰知道M$自己弄的也是亂糟糟。提醒一下他們各位啊,今年是2019了。就這樣。

請把這邊看熟啊你各位

a. install SSIS 2017
b. install SSDT for SSIS 2017
c. new a project
d. choose integration service

e. in flow control, choose data flow

f. in data flow, choose ODBC source

g. pull ODBC source
h. new a ODBC connection in ODBC source editor
Remeber to use “32bit” driver using ETL tool

i. follow the instruction and complete your use case

Microsoft SQL Server Integration Services

--

--

SamSam
SamSam

Written by SamSam

用有限的資料知識探索無限的世界

No responses yet