Assign SQL Script to global variable

#1

How do I assign the contents of a script.sql file to a global variable?
Do I have to read it in line by line? Can you show me the code to do it?

Ron Sissons, DBA
Information Technology Services
Riverside County Office of Education
3939 Thirteenth Street, Riverside, CA 92502-0868
Telephone: (909) 826-6471; FAX: [909] 826-6451

#2

In message <e7ETk5ILEHA.332 (AT) TK2MSFTNGP11 (DOT) phx.gbl>, Ron Sissons
<RSISSONS (AT) rcoe (DOT) k12.ca.us> writes

Quote:

How do I assign the contents of a script.sql file to a global variable?
Do I have to read it in line by line? Can you show me the code to do it?

You could do this in ActiveX Script Task using the text stream object
and Read and ReadLine methods, but easier still you can use the Dynamic
Properties Task.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

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

Assign SQL Script to global variable

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

Assign SQL Script to global variable - 04-27-2004 , 02:32 PM

Re: Assign SQL Script to global variable - 04-27-2004 , 04:01 PM