Active Directory 1000 rows limitation

we are using

select distinguishedname, employeeid, sn, middlename, givenname, displayname, samaccountname, mail, cn, telephonenumber
from OpenQuery( ADSI, 'SELECT telephonenumber, distinguishedname, employeeid, sn, middlename, givenname, displayname, samaccountname, mail, cn, telephonenumber
FROM ''LDAP://DC=domain,DC=xxx,DC=xxx''
WHERE objectCategory = ''Person'' AND objectClass= ''user''

But it only returns 1000 rows which i read all around that is the default.

How do you set this to be higher.

Thanks

Try adding the connection attribute "Page Size" to your connection string and specify higher value. By default, the ADSI search API restricts the first result set size to 1000 rows and the rest of the rows have to be paged one by one. There are probably other connection string attributes that needs to be specified for the search result to be expanded. I do not know the exact details so you will have to check the ADSI OLEDB provider documentation.

Actions not appearing in Cube browser

Hello,

I'm reading AS 2005 step by step and have set up two url actions but none of them appear in the context menu when i click on the rows.

I've also tried setting up an URL action which points to http://google.com and I Would presume it would appear when i right clicked on a cell in the cube but nothing appears.

side note: I created a drillthrough action and that works.

please help

Hi,

try to have a look here:

http://www.databasejournal.com/features/mssql/article.php/10894_3647056_1

Francesco

|||Hi,
read it already. didn't help me with anything.

accessing the same database using multiple threads

hi,

do i need to use specially synchronized code if i have multiple threads inserting, updating and reading rows to and from the same database? in this case, i know that no 2 threads will try to insert or update the exact same row into the DB, however, multiple threads might try to read the same row from the database.

thanks!

No, if the threads are using different conenction objects you can use your code as you already might have implemented it. In case of reusing a SQLConnection object (using an instance or a singleton object) you will have to make sure that the connection does not already has an open transction as parallel transactions are not allowed (if you

are using explicit transactions9

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

ok cool fanks!!

Accessing table cell

I have a simple table that has a couple of fixed number of columns and the
rows are populated from the database. I have a need to get the value from the
cell which i know will always be the second column and third row. Is there a
way to access that cell by maybe using indexes or is this even possible?
Any help or guidance would be greatly appreciated.But if you know the value is coming from some field in a table, why can't you
use that instead of getting the value of the field from the cell which is not
possible.
Amarnath
"appu" wrote:
> I have a simple table that has a couple of fixed number of columns and the
> rows are populated from the database. I have a need to get the value from the
> cell which i know will always be the second column and third row. Is there a
> way to access that cell by maybe using indexes or is this even possible?
> Any help or guidance would be greatly appreciated.|||I need to access that cell because the report will be exported to excel and
the user will enter a number in that cell. The value from that cell will act
as a denomiator to calculate other cells in the table.
"Amarnath" wrote:
> But if you know the value is coming from some field in a table, why can't you
> use that instead of getting the value of the field from the cell which is not
> possible.
> Amarnath
> "appu" wrote:
> > I have a simple table that has a couple of fixed number of columns and the
> > rows are populated from the database. I have a need to get the value from the
> > cell which i know will always be the second column and third row. Is there a
> > way to access that cell by maybe using indexes or is this even possible?
> > Any help or guidance would be greatly appreciated.

Accessing specific rows within a dataset

hi guys!

i need to access a specific row within my dataset.
how can this be done within a report?

my dataset looks like this
1 asdf
2 qwer
3 yxcv

now i need to get the value for the 3rd row ("yxcv") or the value of row x
i can only acces the first and last row by using First() and Last()
but how can i access the rows inbetween?

Thanks,
Gerhard

Is there a reason you can't do a filter on the report based on the values that you are looking for, or in the query itself? Otherwise the only other way I can fathom doing this is using the code module and writing a script that will manage which row/value you are looking at and only display it if it is equal to x.

Although it might be interesting to use the RowNumber("Scope") in an IIF statement to do what you are looking for....

Hope that helps,

Josh

Accessing rows of a table using script task

Hi all,

Can anyone tell me how to access all the rows in a table using script task?

I want to access each row in a table get their values and put it in a global variable. Can anyone hwlp mw with this please.

Thanks in advance,

Why do you want to use the Script Task for this? You could just use an OleDBSource and push it to a DataReaderDestination (DataSet)

What datatype will you be using for your global variable? Will it be a single variable, or multiple variables?

|||

Hi,

Thank you Sean

I am actually logging all the status information of my package at each stage into the table which has about 20 columns and on the completion of the package i wanted send an email which gets its information from the columns values of the table.

Thanks,

|||

if you want to send 1 email for each row of the table, then you could make a dataflow that uses your logging table as a source and uses a recordset destination. then use a foreach loop (containing the sendmail task) over the recordset to send 1 mail per row. this is if you want to send the emails at the end of all other processing, when the status table is filled up.

Accessing Null UDT's from TSQL

I created a UDT in C# that is working fine except when I request rows where the type is null.

If I use SELECT Film.ToString() FROM ImageData it works fine, or any property they return Null as expected

but if I use SELECT Film FROM ImageData it produces the error below

An error occurred while executing batch. Error message is: Data is Null. This method or property cannot be called on Null values.

I looked through all the examples in C# and my code matches the pattern for nulls exactly. Can anyone shead some light on what attribute I may have to add or method I should override which is not documented.

Could you please check the following topics in BOL?

http://msdn2.microsoft.com/es-es/library/ms131069.aspx

http://msdn2.microsoft.com/en-us/library/a8s4s5dz.aspx

When you query the column directly you should get either NULL for the NULL values or the binary representation of the UDT.

Can you check your code against the examples shown in the links above? There is a separate forum for SQL Server CLR that you can follow up also.

|||

This was a bugPlease see http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125552

Cheers,