I have been following the Video tutorial on creating Xquery.
But when I choose to create new query I get no option to choose relationalDB...???
All the others are there.. ie: webdav,ftp etc...
Please see attched for confirmation..
Subject:Xquery - No ReleationalDB option ?? Author:Ray Waldron Date:05 Apr 2007 05:36 AM
Thx for your help Ivan,
I have it now .
Just another quick question.
I have a DB to XML Datasource setup that shows my xml in preview mode.
But how do I now create this xml as a file and output to a directory that I can FTP
Then can I schedule this to run at certain times?
Or can I run this query in SQL Server?