SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 Error run job SSIS package.
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

hailuavitinh
Starting Member

Vietnam
3 Posts

Posted - 07/16/2013 :  03:38:50  Show Profile  Reply with Quote
When run jon SSIS package. I'm getting this error :

"Failed to execute IS server package because of error 0x80131904. Server: Package path: \SSISDB\F_M\F_SSIS\F__Pro1_Accounting.dtsx, Environment reference Id: NULL. Description: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Source: .Net SqlClient Data Provider Started: 10:20:28 AM Finished: 10:20:58 AM Elapsed: 30.25 seconds. The package execution failed. The step failed."

How can I fix this ?

Thanks advantge

hai

Edited by - hailuavitinh on 07/18/2013 03:38:24

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 07/16/2013 :  04:23:53  Show Profile  Reply with Quote
How are you executing the packages?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

hailuavitinh
Starting Member

Vietnam
3 Posts

Posted - 07/16/2013 :  05:04:36  Show Profile  Reply with Quote
I create job run SSIS package

hai
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 07/16/2013 :  05:45:38  Show Profile  Reply with Quote
Ok. Are you using DTExec? can you post the DTexec calling code?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

hailuavitinh
Starting Member

Vietnam
3 Posts

Posted - 07/17/2013 :  04:19:41  Show Profile  Reply with Quote
Hi visakh16

I execute SSIS package using SQL Server Agent Job.

Thanks

hai
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 07/17/2013 :  04:55:31  Show Profile  Reply with Quote
May be this?

http://support.microsoft.com/kb/2720171

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000