SSIS JOBS error(in ssms2008) - SQL Server Forums

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 2008 Forums

SSIS and Import/Export (2008)

SSIS JOBS error(in ssms2008)

Author

Topic

kond.mohan
Posting Yak Master

213 Posts

Posted - 2012-01-03 : 00:26:18

Hi,

i am running the job daily basis to fetch the incremental data from remote location to my server

Remote location : Oracle
my server :Sql server

the error is
:TCP Provider: An existing connection was forcibly closed by the remote host.

when i executed the report job i got this error in job activity

if any body knows the sol pls reply me

I AM ABLE TO CONNETING ORCLE SERVER THROUGH OPENQUERY AND IMPORT AND EXPORT WIZARD

Sachin.Nand

2937 Posts

Posted - 2012-01-03 : 00:51:03

Are you able to connect to the oracle server ?

After Monday and Tuesday even the calendar says W T F ....

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources