dbTalk Databases Forums  

SQL Server 2005 SSIS - sql server destination

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss SQL Server 2005 SSIS - sql server destination in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Mark
 
Posts: n/a

Default 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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.