INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

SSIS Package Works in BIDS Don't work SQL Server Agent Job HELP!!!!!!!

SSIS Package Works in BIDS Don't work SQL Server Agent Job HELP!!!!!!!

(OP)
I have a SSIS Package that works in BIDS and it works by double clicking the SSIS package. But when I schedule Job using SSIS package i get an error. Please let me know if you have any questions. thanks. Error is below:




Executed as user: SCONET\svc_BIGCCPRD84_SSA. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  9:14:46 AM  Error: 2012-04-25 09:14:48.50     Code: 0x00000001     Source: Unlock workbook      Description: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Runtime.InteropServices.COMException (0x8001010A): Creating an instance of the COM component with CLSID {00024500-0000-0000-C000-000000000046} from the IClassFactory failed due to the following error: 8001010a.     at ST_22080cd5ccf5484fa05df02546b8d5de.vbproj.ScriptMain.Main()     --- End of inner exception stack trace ---     at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)     at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)     at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)     at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)     at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)     at System.Type.InvokeMember(String name, BindingFlags invokeAttr, Binder binder, Object target, Object[] args, CultureInfo culture)     at Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTATaskScriptingEngine.ExecuteScript()  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  9:14:46 AM  Finished: 9:14:48 AM  Elapsed:  1.921 seconds.  The package execution failed.  The step failed.  

RE: SSIS Package Works in BIDS Don't work SQL Server Agent Job HELP!!!!!!!

What bit is your two versions?  Is SSIS 64 bit and SQL Server DB 32 bit?  If so, you need to call the package a different way. Try this:

CODE

"D:\Program Files (x86)\90\DTS\Binn\dtexec.exe" /SQL "\mySSISpackage" /SERVER myservername /MAZCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E

Hopefully that works for you.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875: What should I know before I post?

RE: SSIS Package Works in BIDS Don't work SQL Server Agent Job HELP!!!!!!!

(OP)
Hello SQLBILL,

Thanks for responding back. My environment is SSIS 32 bit and SQL Server Db 64 bit. Their is a selection within sql server agent job that runs SSIS package in 32 bit mode. I already have that selected. But still get error above. If any suggestions please let me know.

Thanks

RE: SSIS Package Works in BIDS Don't work SQL Server Agent Job HELP!!!!!!!

Have you tried calling the package the way I suggested?  We have found that the setting you refer to doesn't always work like it should.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875: What should I know before I post?

RE: SSIS Package Works in BIDS Don't work SQL Server Agent Job HELP!!!!!!!

(OP)
Thanks SQLBill for all your help. It works now. Have a great day.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close