dbTalk Databases Forums  

Error when running SSIS package via a job

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Error when running SSIS package via a job in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Mike
 
Posts: n/a

Default Error when running SSIS package via a job - 06-22-2006 , 06:41 AM






When I try to run a ssis package by right clicking and executing via my
desktop the package runs. If I run it via a job it fails. I looked in the
server app logs and see entries generated by the failure of the job but I'm
not sure what is happening. Can someone help? I was hoping the logs would
have specific info as to why the job/SSIS package is failing.

ERROR 1
Source SQLISPackage
Category (0)
Event 1073819651
User myAccount
Computer myServer

ERROR 2
Date 6/21/2006 2:01:25 PM
Log Windows NT (Application)

Source SQLSERVERAGENT
Category (3)
Event 1073742032
Computer myServer

Message
The description for Event ID '1073742032' in Source 'SQLSERVERAGENT' cannot
be found. The local computer may not have the necessary registry information
or message DLL files to display the message, or you may not have permission
to access them. The following information is part of the event:'<job name'>,
'0x1E58C8E591837F479D313B80BDF1DBE7', 'Failed', '2006-06-21 14:01:24', 'The
job failed. The Job was invoked by User <user name>. The last step to run
was step 1 (FTP Process).'
Message
The description for Event ID '1073819651' in Source 'SQLISPackage' cannot be
found. The local computer may not have the necessary registry information or
message DLL files to display the message, or you may not have permission to
access them. The following information is part of the event:'<package Name>'


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.