sql server dts: 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

In message <e7ETk5ILEHA.332@TK2MSFTNGP11.phx.gbl>, Ron Sissons
<RSISSONS@rcoe.k12.ca.us> writes
[quoted text, click to view]

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