SSISDB

打印 被阅读次数

SSISDB catalog
deploy an SSIS project into SSISDB (3 ways)
data tools - BIDS ( in early version)
DTS (in earlier version) --> SSIS (08 or later version) (tasks/import or export...)
connection type (OLE DB, ODBC)

staging table

Hibernate insert
bulk insert with bulkadmin

con:
popular in legacy system, SP's logic is still on DB itself. 
SP increases the difficulty of deployment and maintenance, causes higer coupling. It is not suitable for agile stystem development.

ORM (Object-Relational Mapping), 
converting data between incompatible type systems
Hibernate ORM
NHibernate
ADO.NET
LINQ

MVC

crystal report for .net -- bank
lync

Sharepoint
Onedrive
Skydrive
Google Doc





登录后才可评论.