3

I am trying to set a job step that executes a package to use the 32-bit runtime, as it uses the SQL 10 driver against a SQL 2000 database. The job is running on SQL Server 2012. I see all kinds of examples of how to do this, where the job step properties page has 9 tabs (Set Values, Verification, Command Line, General, Configurations, Command Files, Data Sources, Execution Options and Logging). Execution Options has a checkbox for 32-bit mode.

When I look at my job step, logged in to the server as an Admin, running SSMS as administrator, all I see are two tabs: Package and Configuration. I deployed the packages using the Project Deployment method. How do I get those other tabs to show up?

1 Answer 1

5

It's on the Configuration which then has 3 subtabs: Parameters, Connection Managers and Advanced

enter image description here

Advanced allows you to specify 32 bit vs 64 bit runtime, change the logging levels, dump on errors and override package properties.

enter image description here

1
  • Wow, that seems embarrassingly simple! I'll check it on Monday. Jun 22, 2013 at 23:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.