sql server dts: Hi,
I created an Execute SQL task.
In the Editor / Parameter mapping,
I added the following parameter :
System::packagename ==> @PkgName

In the SQL text property of the task :
Select col1 From TableName Where PackageName = @PkgName

Parse the query. Got Error message:
"The query failed to parse. Must declare the scalar variable "@PkgName"."
Question : Why @PkgName is not recognized ?

Use question mark instead of the explicit parameter name, @PkgName.

i.e.
Select col1 From TableName Where PackageName = ?

when you do the mapping, use 0 instead of the actual parameter name.

Charles Kangai, MCT, MCDBA
Author of Learning Tree's 4-day course: "SQL Server 2005 Integration
Services" http://www.learningtree.com/courses/134.htm
Author of Learning Tree's 4-day course: "SQL Server Reporting Services"
http://www.learningtree.com/courses/523.htm
email: charles at kangai.demon.co.uk


[quoted text, click to view]