SQL 7.0 Question

#1

I'm having to retrofit some of my SQL 2000 DTS packages back to SQL 7.0 for a
different environment.

In SQL 7.0 Is there any way to get values from the database into Global
Variables? In 2000 I would just use output parameters in an Execute SQL task,
but obviously this is not possible in 7.0.

For example I store the current directory information in a database field.
How would I get that back so I could use it in an ActiveX script?

Thanks,

Andy C

#2

Use a DataPump task. It works a treat

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know

"Andy C" <AndyC (AT) discussions (DOT) microsoft.com> wrote

Quote:

I'm having to retrofit some of my SQL 2000 DTS packages back to SQL 7.0
for a
different environment.

In SQL 7.0 Is there any way to get values from the database into Global
Variables? In 2000 I would just use output parameters in an Execute SQL
task,
but obviously this is not possible in 7.0.

For example I store the current directory information in a database field.
How would I get that back so I could use it in an ActiveX script?

Thanks,

Andy C

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL 7.0 Question

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

SQL 7.0 Question - 06-15-2005 , 04:56 AM

Re: SQL 7.0 Question - 06-15-2005 , 03:13 PM