• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 865
  • Last Modified:

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
0
Evan Cutler
Asked:
Evan Cutler
  • 4
  • 2
1 Solution
 
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
 
reb73Commented:
In the mapping try changing the value of 'ParameterName' from

?

to the ordinal

0
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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

Thanks.
0
 
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
 
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

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now