Yes, thanks Greg, it is OPENROWSET. My former DBA refused to use linked server because of security reason. One time my co-worker asked me how to query a different database...

Can you use a job to run the procedure? I know it is a pain but then you don't need the sysadmin or bulk insert role.

It is not necessary to have server admin role. Can your DBA give you bulkadmin sever role so you have to have the right to do bulk insert? ...

How are you going to run the bulk insert? Do you put the bulk insert in a procedure or use DTS package?

I used DTS package to get data from AS400 to SQL Server 2000. It seems to work fine.

I used DTS package in SQL 2000 server connecting to SQL 2005 server and put data in the SQL 2005 box. I have to create a ODBC connection for...

I don't think you can use linkserver from 2005 to 2000. You either have to use SSIS in SQL 2005 or DTS in SQL 2000 to get data back and...

Typical 9 hour a day, unless there was problem in production.

I used to be on call years ago, we used mainframe and terminal at those good old days, I remembered...

Ninja,

Your example is not drilling. Your example is showing how to get information from client table to command table and from command table to product table.

Example of Drilling -

Client...

In your case, for example client is the dimension.

Client - Country, Region, State, City, zip code, client type, other client info the users want, name of the client.

I had built a data warehouse system doing this kind of drill down. Our company built it, we did not buy any outside vendor system because none of them...

They could not fire me because I could sue them since I did not do anything wrong.  Maybe that was the reason why they wanted me to resign.

Actually I was talking to the CIO not CEO.  The company is over 5000 employees.  It just made the fortunate 500 list. 

I was stunned by asking me signing the...

Are you looking for a candidate living in India or anywhere in the world?

Just curious! 

What company is it?  Maybe I should apply for a job there !