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.
| Author |
Topic |
|
ranvir_2k
Posting Yak Master
180 Posts |
 Posted - 2011-07-28 : 08:55:52
|
| I have a SSIS package which is connecting to a Sybase server to run some queries.However it seems to timeout after a certain amount of time. I have verified the connection and can select data from the sybase server machine.Is there anywhere I can increase the SQL Server query timeout value? |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-07-28 : 09:03:49
|
| Timeout is purely a client-side concept. How are you connecting to sybase?--Gail ShawSQL Server MVP |
 |
|
|
ranvir_2k
Posting Yak Master
180 Posts |
Posted - 2011-07-28 : 10:33:38
|
| We're using ASEOLEDB.1 provider to connect to sybase. There is a connection manager specified in the package to the sybase server. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-07-28 : 10:53:24
|
| Directly from SSIS?There's a timeout (or a default) somewhere in either SSIS or the connection manager that you'll have to find--Gail ShawSQL Server MVP |
|
|
|
|
|
|
SQL Server Timeout