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,

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


"GE" wrote:

it is using a stored procedure to create the table


"Todd C" wrote: