dtexec passing variable

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GE - 24 Jun 2009 21:05 GMT

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,

Reply to this Message

Todd C - 26 Jun 2009 13:47 GMT

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

> 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
[quoted text clipped - 14 lines]
> Any help will be apreciated.
> Thank you,

Reply to this Message

GE - 02 Jul 2009 15:36 GMT

it is using a stored procedure to create the table

> Sounds like it is not properly using the variable in the package.
>
[quoted text clipped - 21 lines]
> > Any help will be apreciated.
> > Thank you,

Reply to this Message