USE MSDB;
GO
UPDATE MSDB.dbo.sysjobs
SET Enabled = 0
WHERE Enabled = 1;
GO
GO
UPDATE MSDB.dbo.sysjobs
SET Enabled = 0
WHERE Enabled = 1;
GO
Friday, August 23, 2013
Friday, August 9, 2013
SSIS Package Runs Fine in Integration Server but Fails From SQL Agent Job
SSIS Package Runs Fine in Integration Server but Fails From SQL Agent Job:
This is the most common issue faced when we deploy packages in 64 bit system. When we create any package with Run64bit set as false, this issue occurs.
In order to overcome the 32\64 bit environment issue, it better we use command line in our job to execute the packages.
Use the below command:
C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\dtexec /DTS "\MSDB\ETLFolder\ETLExtractMaster" /SERVER DW01P /CHECKPOINTING OFF /REPORTING V
This is the most common issue faced when we deploy packages in 64 bit system. When we create any package with Run64bit set as false, this issue occurs.
In order to overcome the 32\64 bit environment issue, it better we use command line in our job to execute the packages.
Use the below command:
C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\dtexec /DTS "\MSDB\ETLFolder\ETLExtractMaster" /SERVER DW01P /CHECKPOINTING OFF /REPORTING V
Subscribe to:
Posts (Atom)