Groups | Blog | Home
all groups > sql server dts > november 2005 >

sql server dts : Data Source Views


Imran
11/26/2005 5:38:04 AM
Hi,
I want to know the purpose and use of Data Source Views in Packages. Is
there some way to export data from the data source view to sql server table.
Thanks,
Allan Mitchell
11/26/2005 10:28:25 PM
Yes you can use them to export data in an SSIS package

http://wiki.sqlis.com/default.aspx/SQLISWiki/DataSourceViewsAndSourceAdapters.html


BOL has a good description of a Data Source View here

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/62bc2377-ed49-4ebc-a23e-718e0f9d8d60.htm



[quoted text, click to view]
Imran
11/26/2005 11:47:01 PM
Thanks

[quoted text, click to view]
AddThis Social Bookmark Button