Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
 Posted - 2006-05-01 : 16:30:28
|
| I just ran across this the other day in the SQL 2000 BOL. You can use a DTS package as a datasource for OPENROWSET or setup a DTS package as a linked server.I have been playing around with it, and it does work. I was wondering if anyone else has used it, and what kinds of problems they had with it?From BOL:"Querying a DTS Package from External SourcesData Transformation Services (DTS) package data can be made available to an external source, such as SQL Query Analyzer, by: Querying a package step associated with a transformation with the Transact-SQL OPENROWSET statement.Defining the package as a linked server and joining package data in a distributed query. When querying package rowset data, the following conditions apply: The package supplying the data must be launched by the application getting the package data. You do not execute the package to send the data to the requesting application or process.You can only query a package step associated with a Transform Data task."CODO ERGO SUM |
|
|
|
|
|
Querying a DTS Package from TSQL