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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 DTS & XML

Author  Topic 

anagha
Starting Member

4 Posts

Posted - 2006-03-02 : 07:27:02
Hi,
Does anyone know how to fetch data through a dts package from a config(xml) file?
Normally, as we know we make use of Dynamic Properties task to set the values for global variables from ini/txt file...
but as i said above i want to take it from config..
i feel what can be done is we can specify a Query in the dynamic properties task to make it fetch the element values from xml..
but dunno what that query is..??

Kindly reply asap..

Anagha.
   

- Advertisement -