what type of errors we will get while executing the packages in ssis and ssrs [Resolved]

Posted by Sudheep.Grandhe under Sql Server on 2/4/2015 | Points: 10 | Views : 333 | Status : [Member] | Replies : 3
Hi Team,

In real time projects,what type of errors we will get while executing the packages in ssis and ssrs.Please help me to reply for this answer.

Regards,
Sudheep.G.

Best,
Sudheep.



Responses

Posted by: Bandi on: 2/4/2015 [Member] [MVP] Platinum | Points: 50

Up
0
Down

Resolved
It depends on the package logic, frequently we may get OLE DB connection errors, Time out errors, deadlocks and so on

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Sudheep.Grandhe, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sudheep.Grandhe on: 2/5/2015 [Member] Starter | Points: 25

Up
0
Down
Hi,

Thanks for your prompt reply. can you explain the deadlock and timeout errors with one example. so that it could be very helpful for me to understand.

Regards,
Sudheep.G.

Best,
Sudheep.

Sudheep.Grandhe, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bandi on: 2/5/2015 [Member] [MVP] Platinum | Points: 25

Up
0
Down
refer this link for deadlock example
http://blog.sqlauthority.com/2015/02/02/sql-server-how-can-deadlock-happen-on-same-table/

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Sudheep.Grandhe, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response