Evan Cutler
asked on
MSSQL Job Agent running SSIS packages
Greetings, I have a SSIS Package with two variables. The variables are hard coded in a SSIS package. I have provided an image attached.
Here's the variables:
Here's the step:
and here's the mapping:
The package runs with no errors while in BIDS, but when I attach the package to SQL Server Agent, I get the error "Parameter name is unrecognized"
This is the first package I am deploying to MSSQL. However, I have looked at already deployed packages, and they have variables, but nothing in the Job Settings. The project works fine in BIDS.
What am I missing? Thanks
Here's the variables:
Here's the step:
and here's the mapping:
The package runs with no errors while in BIDS, but when I attach the package to SQL Server Agent, I get the error "Parameter name is unrecognized"
This is the first package I am deploying to MSSQL. However, I have looked at already deployed packages, and they have variables, but nothing in the Job Settings. The project works fine in BIDS.
What am I missing? Thanks
ASKER
I'm using 2008 64 bit, with this particular job running in 32 bit
In the mapping try changing the value of 'ParameterName' from
?
to the ordinal
0
?
to the ordinal
0
ASKER
ok...what's an ordinal?
and what do I change in the line of the command?
Thanks.
and what do I change in the line of the command?
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ok. Please give me until Tuesday to try it. Visiting family for turkey day. Thanks
ASKER
don't know why this worked, but it did...
must be something I did...
Thanks.
must be something I did...
Thanks.
which SQL Server version and edition?
32 or 64 bit?
Thanks.
Rainer