Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Connectivity Problems Expand / Collapse
Author
Message
Posted Monday, January 13, 2014 11:49 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, May 6, 2014 4:14 AM
Points: 17, Visits: 112
Hi,
I am Dharmendra Kumar, I am facing this problems, can any one help me to resolve this problems.

ABC\dmsadmin. Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 1:10:47 AM Error: 2014-01-07 01:49:31.05 Code: 0x00000000 Source: blankcashnet to Dummy_CASHNET Description: TCP Provider: The semaphore timeout period has expired. End Error Error: 2014-01-07 01:49:31.05 Code: 0xC002F210 Source: blankcashnet to Dummy_CASHNET Execute SQL Task Description: Executing the query "insert into SSIS_check (task_name) values ('ITM da..." failed with the following error: "Communication link failure". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 1:10:47 AM Finished: 1:49:31 AM Elapsed: 2323.46 seconds. Process Exit Code 1. The step failed.
Post #1530549
Posted Monday, January 13, 2014 11:59 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 11:26 AM
Points: 13,622, Visits: 10,514
At first sight it seems you're experiencing network issues.
Are you running the package on the same server where the database is?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1530554
Posted Wednesday, January 15, 2014 12:01 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, May 6, 2014 4:14 AM
Points: 17, Visits: 112
Yes Sir

Also using bulk insertion on a table
Post #1530951
Posted Wednesday, January 15, 2014 4:32 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 11:26 AM
Points: 13,622, Visits: 10,514
Dharmendra JKT (1/15/2014)
Yes Sir

Also using bulk insertion on a table


Maybe there is excessive locking? Any other processes accessing the tables?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1531015
Posted Thursday, January 16, 2014 1:42 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, May 6, 2014 4:14 AM
Points: 17, Visits: 112
No
Post #1531451
Posted Friday, August 8, 2014 1:37 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 11, 2014 4:34 AM
Points: 7, Visits: 11
your problem is too complicated for me also i am trying to resolve it through my programmers and developers hope they find solution soon. I will get you back in few days you just wait for my reply.

magento development india | web programming india
Post #1601060
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse