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