Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 Error run job SSIS package.

Author  Topic 

hailuavitinh
Starting Member

3 Posts

Posted - 2013-07-16 : 03:38:50
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

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-07-16 : 04:23:53
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

3 Posts

Posted - 2013-07-16 : 05:04:36
I create job run SSIS package

hai
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-07-16 : 05:45:38
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

3 Posts

Posted - 2013-07-17 : 04:19:41
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

52326 Posts

Posted - 2013-07-17 : 04:55:31
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
   

- Advertisement -