Hi all

I would like to know what the easiest way is to set a SQL-parameter (prepar
it?) in a DTS ExecuteSQLtask
Normally when programming in Delphi I format the SQL-statement before I hoo
it up to the Query as SQL-statement with the Format-function, but ca
something like this be done for instance in an ActiveXTask or how should
do this inside a package

Any help appreciated

Franci

You do not mention which version of SQL Server you are using but personally
I would build the statement in an Active Script task. Your parameters to
the statement would be held in Global Variables.

You then build the statement before assigning it to the ExecuteSQL task

Global Variables and SQL statements in DTS
(http://www.sqldts.com/Default.aspx?205)

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"francis" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Hi

Seems there was an article "Global Variables and SQL statements in DTS
about this in www.sqldts.com, but failed to find it earlier. Sorry for the ignorance
Link to the article is
http://www.sqldts.com/Default.aspx?20

Will use this example

Greetings

Franci