2019年7月13日 星期六

SQL Server Integration Services學習資源

SQL Server Integration Services學習資源


SSIS How to Create an ETL Package
https://learn.microsoft.com/en-us/sql/integration-services/ssis-how-to-create-an-etl-package?view=sql-server-2017




SQL Server Integration Services Tutorial Videos
https://channel9.msdn.com/Shows/SQL-Server-Integration-Services-Tutorial-Videos?page=2
https://channel9.msdn.com/Shows/SQL-Server-Integration-Services-Tutorial-Videos
Last episode: Aug 11, 2015 at 10:04AM
Tutorial Videos of SQL Server Integration Services (SSIS).
Videos Created based on SSIS 2012, but it will apply on SSIS 2014.

Data Source Driver

MySQL

MySQL Connector/ODBC
https://dev.mysql.com/downloads/connector/odbc/
MySQL Connector/NET
https://dev.mysql.com/downloads/connector/net/

Oracle

Oracle Database Software Downloads
https://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
Oracle Database 19c Client (19.3) for Microsoft Windows x64 (64-bit)
Oracle Database 19c Client (19.3) for Microsoft Windows (32-bit)

沒有留言:

Copy or Backup Command - robocopy

  robocopy D:\Backup E:\Backup /MIR /MT:100 /LOG+:C:\Logs\robocopy.log /MIR  鏡像目錄樹(包含 空的子目錄 ), 確保目標目錄與來源目錄完全相符,並比對刪除目標中不存在於來源中的任何檔案或目錄, /MT:...