dtexec passing variable

[GE]

I have a simple ssis (it just creates a table). It has a variable tblName.
When I give a valid variable name, the ssis works fine. In the orignial ssis
package I have tblName set up as tblTest. I saved the ssis package in the
server.

I want it to work from dtexec:

EXEC xp_cmdshell 'dtexec /sql "ssisTest"
/set\Package.Variables[User::tblname].Properties[Value];"tblTest11111111111"'

The new variable, tblTest11111111111 is not getting used. If I drop tblTest
and run the above it creates tblTest. In other words this line does not work:
/set\Package.Variables[User::tblname].Properties[Value];"tblTest11111111111"

I tried removing quotes from tblTest11111111111 and that does not help either.

Any help will be apreciated.
Thank you,

[Todd C]

Sounds like it is not properly using the variable in the package.

By what method is the SSIS package creating the table? Can you give us a
sample of your code or T-SQL statement?
=====
Todd C

Post by GE
I have a simple ssis (it just creates a table). It has a variable tblName.
When I give a valid variable name, the ssis works fine. In the orignial ssis
package I have tblName set up as tblTest. I saved the ssis package in the
server.
EXEC xp_cmdshell 'dtexec /sql "ssisTest"
/set\Package.Variables[User::tblname].Properties[Value];"tblTest11111111111"'
The new variable, tblTest11111111111 is not getting used. If I drop tblTest
/set\Package.Variables[User::tblname].Properties[Value];"tblTest11111111111"
I tried removing quotes from tblTest11111111111 and that does not help either.
Any help will be apreciated.
Thank you,

[GE]

it is using a stored procedure to create the table

Post by Todd C
Sounds like it is not properly using the variable in the package.
By what method is the SSIS package creating the table? Can you give us a
sample of your code or T-SQL statement?
=====
Todd C

Post by GE
I have a simple ssis (it just creates a table). It has a variable tblName.
When I give a valid variable name, the ssis works fine. In the orignial ssis
package I have tblName set up as tblTest. I saved the ssis package in the
server.
EXEC xp_cmdshell 'dtexec /sql "ssisTest"
/set\Package.Variables[User::tblname].Properties[Value];"tblTest11111111111"'
The new variable, tblTest11111111111 is not getting used. If I drop tblTest
/set\Package.Variables[User::tblname].Properties[Value];"tblTest11111111111"
I tried removing quotes from tblTest11111111111 and that does not help either.
Any help will be apreciated.
Thank you,