Search
Active

1
Sign in to vote
0
Sign in to vote
Sign in
to vote
Type: Suggestion
ID: 508253
Opened: 11/4/2009 10:10:45 AM
Access Restriction: Public
1
Workaround(s)
Calling an SSIS package that requires execution with the 32-bit version of DTExec should be handled natively by the software in SQL Server Agent. Currently selecting Integration services as a job step will run a package in whatever platform (32/64) the SQL Server is.
Details (expand)
Product Language
English

Category

Tools (SSMS, Agent, Profiler, etc.)
Proposed Solution
Add an additional type "SQL Server Integration Services Package (32-Bit)" that for 32-bit servers is the same as "SQL Server Integration Services Package". But for 64-bit servers calls the 32-bit version of DTExec.
This would allow the user to continue to use the SSIS features in SQL Agent without losing functionality and should not require much in the way of effort. An additional entry in [msdb].[dbo].[syssubsystems] that contains the data for the sub-system that points at the 32-bit DTExec should be possible.
Benefits
Improved Reliability
Improved User Interface
Improved Administration
Other Benefits
 
File Attachments
0 attachments
Sign in to post a comment.