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 |
|
Ali Chadorbaf
Starting Member
44 Posts |
 Posted - 2007-09-21 : 14:06:11
|
| HiIn Design mode, I get lock because my "DataReader Source" tries to read millions of rows at a time. How can I get around of this? Anywhere to limit result set to read a lower number of rows at a time? Note that I need to read the whole table (select * from ...) so limiting rows in WHERE clause is not an option.Thanks |
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2007-09-21 : 14:43:04
|
| Where are you inserting this data to? |
 |
|
|
Ali Chadorbaf
Starting Member
44 Posts |
Posted - 2007-09-21 : 14:49:02
|
quote:
Originally posted by igorblackbelt
Where are you inserting this data to?
Data coming from Sybase(DataReader Source) and goes to Sql Server (OLE DD Destination)Thanks |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2007-09-21 : 15:52:14
|
| The only thing I could think of is setting the maximum number of "rows per batch" on your OLE DB Destination to something like 100,000, but it seems like the issue is not when the data is being insert and when the data is being pulled, so I'm not sure if that'll help you at all. |
|
|
|
bigbelly
Starting Member
39 Posts |
Posted - 2007-10-30 : 02:15:13
|
| I had same problem with getting data from mysql. http://sqlteam.com/FORUMS/topic.asp?TOPIC_ID=91683I think you can get around it by putting key word of the "limit 100" or "top 100" first(I don't know what's the key word for Sybase). After you finish configuring everything. Then remove the key word. |
|
|
|
|
|
|
SSIS result set?