The SQL Server Destination is an adapter for getting data into SQL Server really fast. However, it can only be used when the ssis package is being run on the same serverthat you are inserting into.
The Ole Db Destination loads data into a variety of ole db compliant databases using a database table or view or a SQL command.
No comments:
Post a Comment