Thanks.

I am not able to change the logic of the query as here they follow the datavault philosophy to the teeth and I have no way around it.

My question was,...

thanks

Hi,

thanks for your reply.

I have given them only read access, so that permission to only read a specific database is not the problem.

have a great day!

astrid

Thanks but I am not sure what you mean.

it is a domain user, what details are we talking about?

Thanks for your reply.

I didnt mean that he is accessing the server itself.

I mean I want him on the SSMS to log and do his queries on my DEV enviroment,...

oh, I will look into it, thanks

Hi,

thanks for your reply, I do have the latest version according to this article, so I am not sure what the error means.

thanks

astrid

Thanks for your reply, each customer has one Expired on 2017 and that is the year I will be checking.

I am looking to do a sum that will not include...

I load two tables every time, and the reason I do so it is because when we were loading more, we were choking the server.

We load table by table, we...

I am not using the bulk option right now, as I am loading directly from Oracle.

I will try it to, but the big question is: How do you copy data...

Good morning.

Maybe I should detailed my process better.

The company I work for uses the Datavault methodology… that is another whole issues…

So basically, we take a table on SSIS add the...

• This reply was modified 5 years, 6 months ago by  astrid 69000.

i need to do it daily, that is why i was trying to so the ssma but the oracle database in on linux and you do need to install it...

125 gb of total data. I imagine around 973  tables. right now I have 80 tables and that take like 13 hours

• This reply was modified 5 years, 6 months ago by  astrid 69000.

I am confused, I have a date table, but I am not sure how to join it. that is my problem, now i see that cte, it is not my...