 | |
Parameter don't work in TSQL
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Parameter don't work in TSQL -
04-01-2008
, 07:04 PM
#2
| |||
| |||
|
|
Hi, i'm tried use parameters in a sql statement but don't work. I don't know what happen, anyone help me please. information DTS: Variable Information Name * * * * * *Scope * * * * * Data Type * * * Value PackageName * * Package String * * * * *Package1 ... ... Execute SQL Task Connection: Ado.Net Parameter mapping Variable Name * * * * * Direction * * * Data Type * * * Parameter Name *Parameter size User::PackageName * * * * * * * Input * * * * * String *@PackageName * * * * * * * * 1 ... ... ... SQL = INSERT INTO PackageSystemAudit *(PackageName...) * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * SELECT @PackageName... [Execute SQL Task] Error: Executing the query "INSERT INTO PackageSystemAudit *( * * * * PackageName, * * * * CreationName, * * * * MajorVersion, * * * * MinorVersion, * * * * VersionGUID, * * * * MachineName, * * * * CreationDate, * * * * StartDate, * * * * PackageID *) *SELECT * * * * @PackageName, * * * * @CreationName, * * * * @MajorVersion, * * * * @MinorVersion, * * * * @VersionGUID, * * * * @MachineName,* * * * @CreationDate, * * * * @StartDate, * * * * @PackageID" failed with the following error: "must declare the variable scalar "@PackageName".". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. Regards... |
You need to change your SQL statement to:
"INSERT INTO PackageSystemAudit (PackageName, ...
SELECT ?, ?, ?, ?, ?, ?, ... "
Make sure that the column list in your Insert statement is in the
*same order* as the parameters in the parameter mapping tab.
Good luck!
J
#3
| |||
| |||
|
|
Hi, i'm tried use parameters in a sql statement but don't work. I don't know what happen, anyone help me please. information DTS: Variable Information Name * * * * * *Scope * * * * * Data Type * * * Value PackageName * * Package String * * * * *Package1 ... ... Execute SQL Task Connection: Ado.Net Parameter mapping Variable Name * * * * * Direction * * * Data Type * * * Parameter Name *Parameter size User::PackageName * * * * * * * Input * * * * * String *@PackageName * * * * * * * * 1 ... ... ... SQL = INSERT INTO PackageSystemAudit *(PackageName...) * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * SELECT @PackageName... [Execute SQL Task] Error: Executing the query "INSERT INTO PackageSystemAudit *( * * * * PackageName, * * * * CreationName, * * * * MajorVersion, * * * * MinorVersion, * * * * VersionGUID, * * * * MachineName, * * * * CreationDate, * * * * StartDate, * * * * PackageID *) *SELECT * * * * @PackageName, * * * * @CreationName, * * * * @MajorVersion, * * * * @MinorVersion, * * * * @VersionGUID, * * * * @MachineName,* * * * @CreationDate, * * * * @StartDate, * * * * @PackageID" failed with the following error: "must declare the variable scalar "@PackageName".". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. Regards... |
You need to change your SQL statement to:
"INSERT INTO PackageSystemAudit (PackageName, ...
SELECT ?, ?, ?, ?, ?, ?, ... "
Make sure that the column list in your Insert statement is in the
*same order* as the parameters in the parameter mapping tab.
Good luck!
J
#4
| |||
| |||
|
|
Hi, i'm tried use parameters in a sql statement but don't work. I don't know what happen, anyone help me please. information DTS: Variable Information Name * * * * * *Scope * * * * * Data Type * * * Value PackageName * * Package String * * * * *Package1 ... ... Execute SQL Task Connection: Ado.Net Parameter mapping Variable Name * * * * * Direction * * * Data Type * * * Parameter Name *Parameter size User::PackageName * * * * * * * Input * * * * * String *@PackageName * * * * * * * * 1 ... ... ... SQL = INSERT INTO PackageSystemAudit *(PackageName...) * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * SELECT @PackageName... [Execute SQL Task] Error: Executing the query "INSERT INTO PackageSystemAudit *( * * * * PackageName, * * * * CreationName, * * * * MajorVersion, * * * * MinorVersion, * * * * VersionGUID, * * * * MachineName, * * * * CreationDate, * * * * StartDate, * * * * PackageID *) *SELECT * * * * @PackageName, * * * * @CreationName, * * * * @MajorVersion, * * * * @MinorVersion, * * * * @VersionGUID, * * * * @MachineName,* * * * @CreationDate, * * * * @StartDate, * * * * @PackageID" failed with the following error: "must declare the variable scalar "@PackageName".". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. Regards... |
You need to change your SQL statement to:
"INSERT INTO PackageSystemAudit (PackageName, ...
SELECT ?, ?, ?, ?, ?, ?, ... "
Make sure that the column list in your Insert statement is in the
*same order* as the parameters in the parameter mapping tab.
Good luck!
J
#5
| |||
| |||
|
|
Hi, i'm tried use parameters in a sql statement but don't work. I don't know what happen, anyone help me please. information DTS: Variable Information Name * * * * * *Scope * * * * * Data Type * * * Value PackageName * * Package String * * * * *Package1 ... ... Execute SQL Task Connection: Ado.Net Parameter mapping Variable Name * * * * * Direction * * * Data Type * * * Parameter Name *Parameter size User::PackageName * * * * * * * Input * * * * * String *@PackageName * * * * * * * * 1 ... ... ... SQL = INSERT INTO PackageSystemAudit *(PackageName...) * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * SELECT @PackageName... [Execute SQL Task] Error: Executing the query "INSERT INTO PackageSystemAudit *( * * * * PackageName, * * * * CreationName, * * * * MajorVersion, * * * * MinorVersion, * * * * VersionGUID, * * * * MachineName, * * * * CreationDate, * * * * StartDate, * * * * PackageID *) *SELECT * * * * @PackageName, * * * * @CreationName, * * * * @MajorVersion, * * * * @MinorVersion, * * * * @VersionGUID, * * * * @MachineName,* * * * @CreationDate, * * * * @StartDate, * * * * @PackageID" failed with the following error: "must declare the variable scalar "@PackageName".". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. Regards... |
You need to change your SQL statement to:
"INSERT INTO PackageSystemAudit (PackageName, ...
SELECT ?, ?, ?, ?, ?, ?, ... "
Make sure that the column list in your Insert statement is in the
*same order* as the parameters in the parameter mapping tab.
Good luck!
J
#6
| |||
| |||
|
|
Hi, i'm tried use parameters in a sql statement but don't work. I don't know what happen, anyone help me please. information DTS: Variable Information Name * * * * * *Scope * * * * * Data Type * * * Value PackageName * * Package String * * * * *Package1 ... ... Execute SQL Task Connection: Ado.Net Parameter mapping Variable Name * * * * * Direction * * * Data Type * * * Parameter Name *Parameter size User::PackageName * * * * * * * Input * * * * * String *@PackageName * * * * * * * * 1 ... ... ... SQL = INSERT INTO PackageSystemAudit *(PackageName...) * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * SELECT @PackageName... [Execute SQL Task] Error: Executing the query "INSERT INTO PackageSystemAudit *( * * * * PackageName, * * * * CreationName, * * * * MajorVersion, * * * * MinorVersion, * * * * VersionGUID, * * * * MachineName, * * * * CreationDate, * * * * StartDate, * * * * PackageID *) *SELECT * * * * @PackageName, * * * * @CreationName, * * * * @MajorVersion, * * * * @MinorVersion, * * * * @VersionGUID, * * * * @MachineName,* * * * @CreationDate, * * * * @StartDate, * * * * @PackageID" failed with the following error: "must declare the variable scalar "@PackageName".". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. Regards... |
You need to change your SQL statement to:
"INSERT INTO PackageSystemAudit (PackageName, ...
SELECT ?, ?, ?, ?, ?, ?, ... "
Make sure that the column list in your Insert statement is in the
*same order* as the parameters in the parameter mapping tab.
Good luck!
J
#7
| |||
| |||
|
|
Hi, i'm tried use parameters in a sql statement but don't work. I don't know what happen, anyone help me please. information DTS: Variable Information Name * * * * * *Scope * * * * * Data Type * * * Value PackageName * * Package String * * * * *Package1 ... ... Execute SQL Task Connection: Ado.Net Parameter mapping Variable Name * * * * * Direction * * * Data Type * * * Parameter Name *Parameter size User::PackageName * * * * * * * Input * * * * * String *@PackageName * * * * * * * * 1 ... ... ... SQL = INSERT INTO PackageSystemAudit *(PackageName...) * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * SELECT @PackageName... [Execute SQL Task] Error: Executing the query "INSERT INTO PackageSystemAudit *( * * * * PackageName, * * * * CreationName, * * * * MajorVersion, * * * * MinorVersion, * * * * VersionGUID, * * * * MachineName, * * * * CreationDate, * * * * StartDate, * * * * PackageID *) *SELECT * * * * @PackageName, * * * * @CreationName, * * * * @MajorVersion, * * * * @MinorVersion, * * * * @VersionGUID, * * * * @MachineName,* * * * @CreationDate, * * * * @StartDate, * * * * @PackageID" failed with the following error: "must declare the variable scalar "@PackageName".". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. Regards... |
You need to change your SQL statement to:
"INSERT INTO PackageSystemAudit (PackageName, ...
SELECT ?, ?, ?, ?, ?, ?, ... "
Make sure that the column list in your Insert statement is in the
*same order* as the parameters in the parameter mapping tab.
Good luck!
J
#8
| |||
| |||
|
|
Hi, i'm tried use parameters in a sql statement but don't work. I don't know what happen, anyone help me please. information DTS: Variable Information Name * * * * * *Scope * * * * * Data Type * * * Value PackageName * * Package String * * * * *Package1 ... ... Execute SQL Task Connection: Ado.Net Parameter mapping Variable Name * * * * * Direction * * * Data Type * * * Parameter Name *Parameter size User::PackageName * * * * * * * Input * * * * * String *@PackageName * * * * * * * * 1 ... ... ... SQL = INSERT INTO PackageSystemAudit *(PackageName...) * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * SELECT @PackageName... [Execute SQL Task] Error: Executing the query "INSERT INTO PackageSystemAudit *( * * * * PackageName, * * * * CreationName, * * * * MajorVersion, * * * * MinorVersion, * * * * VersionGUID, * * * * MachineName, * * * * CreationDate, * * * * StartDate, * * * * PackageID *) *SELECT * * * * @PackageName, * * * * @CreationName, * * * * @MajorVersion, * * * * @MinorVersion, * * * * @VersionGUID, * * * * @MachineName,* * * * @CreationDate, * * * * @StartDate, * * * * @PackageID" failed with the following error: "must declare the variable scalar "@PackageName".". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. Regards... |
You need to change your SQL statement to:
"INSERT INTO PackageSystemAudit (PackageName, ...
SELECT ?, ?, ?, ?, ?, ?, ... "
Make sure that the column list in your Insert statement is in the
*same order* as the parameters in the parameter mapping tab.
Good luck!
J
#9
| |||
| |||
|
|
Hi, i'm tried use parameters in a sql statement but don't work. I don't know what happen, anyone help me please. information DTS: Variable Information Name * * * * * *Scope * * * * * Data Type * * * Value PackageName * * Package String * * * * *Package1 ... ... Execute SQL Task Connection: Ado.Net Parameter mapping Variable Name * * * * * Direction * * * Data Type * * * Parameter Name *Parameter size User::PackageName * * * * * * * Input * * * * * String *@PackageName * * * * * * * * 1 ... ... ... SQL = INSERT INTO PackageSystemAudit *(PackageName...) * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * SELECT @PackageName... [Execute SQL Task] Error: Executing the query "INSERT INTO PackageSystemAudit *( * * * * PackageName, * * * * CreationName, * * * * MajorVersion, * * * * MinorVersion, * * * * VersionGUID, * * * * MachineName, * * * * CreationDate, * * * * StartDate, * * * * PackageID *) *SELECT * * * * @PackageName, * * * * @CreationName, * * * * @MajorVersion, * * * * @MinorVersion, * * * * @VersionGUID, * * * * @MachineName,* * * * @CreationDate, * * * * @StartDate, * * * * @PackageID" failed with the following error: "must declare the variable scalar "@PackageName".". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. Regards... |
You need to change your SQL statement to:
"INSERT INTO PackageSystemAudit (PackageName, ...
SELECT ?, ?, ?, ?, ?, ?, ... "
Make sure that the column list in your Insert statement is in the
*same order* as the parameters in the parameter mapping tab.
Good luck!
J
#10
| |||
| |||
|
|
On Apr 2, 1:04*am, Francisco <Franci... (AT) discussions (DOT) microsoft.com wrote: Hi, i'm tried use parameters in a sql statement but don't work. I don't know what happen, anyone help me please. information DTS: Variable Information Name * * * * * *Scope * * * * * Data Type * * * Value PackageName * * Package String * * * * *Package1 ... ... Execute SQL Task Connection: Ado.Net Parameter mapping Variable Name * * * * * Direction * * * Data Type * * * Parameter Name *Parameter size User::PackageName * * * * * * * Input * * * * * String *@PackageName * * * * * * * * 1 ... ... ... SQL = INSERT INTO PackageSystemAudit *(PackageName...) * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * SELECT @PackageName... [Execute SQL Task] Error: Executing the query "INSERT INTO PackageSystemAudit *( * * * * PackageName, * * * * CreationName, * * * * MajorVersion, * * * * MinorVersion, * * * * VersionGUID,* * * * MachineName, * * * * CreationDate, * * * * StartDate, * * * *PackageID *) *SELECT * * * * @PackageName, * * * * @CreationName, * * * * @MajorVersion, * * * * @MinorVersion, * * * * @VersionGUID, * * * * @MachineName, * * * * @CreationDate, * * * * @StartDate, * * * * @PackageID" failed with the following error: "must declare the variable scalar "@PackageName".". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. Regards... Hi Francisco, You need to change your SQL statement to: "INSERT INTO PackageSystemAudit (PackageName, ... SELECT ?, ?, ?, ?, ?, ?, ... " Make sure that the column list in your Insert statement is in the *same order* as the parameters in the parameter mapping tab. Good luck! J- Hide quoted text - - Show quoted text - |
will be a problem with the above as columns can not be parameterised
in DTS/SSIS...
You'll need to build up your TSQL statement using a property
expression or script task.
Good luck!
J
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.