SQL Server 2005 SSIS - sql server destination -
10-06-2005
, 07:50 AM
When creating a package in Integration Services, the data flow tab can use
controls like "sql server destination", "OLE DB Source", and "OLE DB
Destination". Two questions:
1. Why is there no "SQL Server Source"?
2. When you use the IS wizard to move data from one SQL Server database to
another, the saved package uses an OLE DB Source and OLE DB Desitination.
Why doesn't it use the "SQL Server Source"?
Thanks in advance.
Mark |