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:
11-27-2013-2-44-14-PM.png
Here's the step:
11-27-2013-2-58-08-PM-0001.png
and here's the mapping:
11-27-2013-2-58-24-PM-0000.png
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
LVL 9
Evan CutlerVolunteer Chief Information OfficerAsked:
Who is Participating?
 
reb73Commented:
Ordinal is the order of the parameter list starting from 0.

The suggested change is in the parameter screenshot above, change the question mark to 0.
0
 
Rainer JeschorCommented:
Hi,
which SQL Server version and edition?
32 or 64 bit?

Thanks.
Rainer
0
 
Evan CutlerVolunteer Chief Information OfficerAuthor Commented:
I'm using 2008 64 bit, with this particular job running in 32 bit
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
reb73Commented:
In the mapping try changing the value of 'ParameterName' from

?

to the ordinal

0
0
 
Evan CutlerVolunteer Chief Information OfficerAuthor Commented:
ok...what's an ordinal?
and what do I change in the line of the command?

Thanks.
0
 
Evan CutlerVolunteer Chief Information OfficerAuthor Commented:
Ok. Please give me until Tuesday to try it. Visiting family for turkey day. Thanks
0
 
Evan CutlerVolunteer Chief Information OfficerAuthor Commented:
don't know why this worked, but it did...
must be something I did...
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.