[quoted text, click to view] On 14 Aug, 22:47, "MS News" <osindiat...@gmail.com> wrote:
> Can someone reply?
>
> -KLN
>
> "klninc" <kln...@discussions.microsoft.com> wrote in message
>
> news:9CE52DC1-0A7B-4E82-A46F-C33DCF082C38@microsoft.com...
>
>
>
> > MS and DB gurus,
>
> > I have this scenario.
>
> > Source of Data:
> > Paradox Data using ODBC / Paradox Drivers
>
> > I need to send DYNAMICALLY built Queries to Paradox and grab the data.
> > Save
> > the data to the SQL Server table. The dynamic query building will happen
> > in
> > the Web Front end using ASP.net pages. Now how I can do this at a
> > realtime,
> > lets say when user clicks on Search. I also need to update the Paradox
> > table.
> > How I can make use of DTS here. I am sure I can access Paradox Data using
> > DTS. But not sure how to set it up in this scenario.
>
> > Is it possible at all? What are the steps? I am new to DTS. Any help would
> > be GREATLY appreciated
>
> > Thanks a lot
>
> > -KLN.- Hide quoted text -
>
> - Show quoted text -
Hi,
I'm going to assume you're using DTS 2000.
The generation of the Dynamic SQL statements can be done in any number
of ways (e.g. in the ASP, in the DTS or in a stored procedure) -
choose the one that you feel most comfortable with. You then need to
pass it into the DTS package - I'd probably pass the statement into a
global variable through the command line execution. Finally you'll
need to change the SQLStatement property of the task connecting to the
Paradox database using a Dynamic Properties task.
Check out
http://msdn2.microsoft.com/en-us/library/aa215023(SQL.80).aspx
for info on the Dynamic Properties
To pass the generated statements in to the package from ASP or
elsewhere, check out
http://msdn2.microsoft.com/en-us/library/aa224467(SQL.80).aspx
Good Luck!
J
