did you mean to write

where d.collector is not null ?

it was 64bit to begin with.

how do i find out whats taking long, read from oracle or insert into sql? and yes i am writing bad records to a flat file.

attached is a screenshot..

its a stand alone table. i am using a data flow task.. which is pretty basic in design. it has a ole db source and ole db destination. nothing out...

did you mean sql 2005 backward compatibility?

well at some point I will have to add more memory. as I am bringing more and more databases online some with big users populations and large amounts of data....

Well avg life expectancy has been going down steadily. at this point its near 800. my db's are fully indexed. so again back to same question. how to estimate for...

thanks

this gives me the first period

2008-06-01 17:39:13.020 to 2008-06-15 17:39:13.020

how do you remove these timestamps?

thanks

well what I found out that I can convert variables to int using CInt. so I used that. but now running into another problem. When I try to compare the...

would it possible that you expand on your reply.. thanks

I think I am little confused about how this works.

If I was to rewrite the dts package that builds the cube I wouldnt be copying my current cube anyways...

thanks....

awesome.. thanks