HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

In Job Step > Properties, only see two tabs: Package and Configuration

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
packagepropertiesandseetwosteponlytabsconfigurationjob

Problem

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?

Solution

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

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

Context

StackExchange Database Administrators Q#45070, answer score: 5

Revisions (0)

No revisions yet.