Please Help Solve Why SSIS Package Fails When Run as SQL Agent Job

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » SQL Server Agent » Please Help Solve Why SSIS Package Fails When...

13 posts, Page 2 of 2

««1 2

Please Help Solve Why SSIS Package Fails When Run as SQL Agent Job

Rate Topic

Display Mode

Topic Options

Author

Message

fellmeth

Posted Wednesday, January 19, 2011 10:50 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, March 19, 2013 6:59 AM
Points: 8, Visits: 68

Thanks, Grasshopper. I'd forgotten about this post. I'll keep your solution in mind for the future. What I discovered a few weeks ago was that we'd been copying existing working packages and then modifying them for the new server. SSIS really does not like this copying and modifying. When we finally gave that up and rebuilt the packages from scratch, all the problems we were having vanished.

Post #1050215

SQListic

Posted Wednesday, September 12, 2012 6:25 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 2:42 PM
Points: 193, Visits: 773

Hope this link helps you

http://sqlism.blogspot.com/2012/08/ssis-package-in-sql-server-agent-job.html

SSIS Package in SQL Server Agent Job Fails
Error:
Argument "xyz" for option "connection" is not valid. The command line parameters are invalid. The step failed.

Solution:

If your SQL Server is 64 bit

In SQL Server JOB-->Properties-->Steps--->

In the Execution Option Tab -- Check "Use 32 bit runtime"
In the Data Sources Tab -- Uncheck the checkboxes of the connection managers if already checked.
Schedule the Job and run it

Post #1358277

vani_r14

Posted Tuesday, October 02, 2012 11:25 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, May 06, 2013 10:48 PM
Points: 123, Visits: 399

Hi all

Not sure if any one is still having this issue but the one change below seemed to resolve the problem for me.

*** NOTE - I did not have to make any changes to the job properties etc ****

Follow below steps :

1. Right click Solution

2. Select properties

3. Go to Debugging tab

4. Set 64 Bit Run Time to False

5. click Ok and close out

6. Save package

7. Deploy / run package as per normal

Web site address if needed for above steps

http://social.msdn.microsoft.com/Forums/en-NZ/sqlintegrationservices/thread/71cd55a0-b32d-4b2f-99c8-52d5e3d8cd7c

Cheers
Vani Smile

Post #1367406

« Prev Topic | Next Topic »

13 posts, Page 2 of 2

««1 2

Permissions