Jeff

What is that meant? Yeck!!!

Adrian

Thanks a lot.

Rudy

I put a lot of post of my bad job experiences. I just wanted to get some advices or had someone listening to my problems,...

Instead of using Active X script, have you tried to use the FTP task in DTS?

I used it before and it seemed to work pretty good.

How did you design your DTS package?

How did you get the data from Ingres DB?

The first thing that came to my mind was using Dynamic Property Task.

my 2 cents

Are you looking for a tool to build data warehouse or report or ETL process?

Data warehouse includes a lot of things.

I read a lot of those motivational books, none had done me any good. I rather read Little Prince or speech from Dalai Lama.

I read that book long time ago.:exclamationmark::(

I should learn this from Einstein long time ago.

Albert Einstein

If A is a success in life, then A equals x plus y plus z. Work is x; y is play;...

I was a team player and I got along with everyone fine. I used to talk to my co-workers all the time and we had a lot of fun.

But...

I assume BusinessArea and Status in the main table, so why don't you put a CHECK constraint in the Status field based on BusinessArea

Status VARCHAR(1) NOT NULL CHECK ((BusinessArea =...

How did you set up the parameters? You cannot just pass the value from one database to another one.

You need to set up Dynamic property to set up a...

Actually I was starting writing an article about comparing building a house vs building data warehouse. Now I can scratch that article. I was thinking about the TV...

I assume the lowest interval you want to get is minute.

SELECT DATEDIFF(mi, starttime, endtime) FROM Table

DATEDIFF ( datepart , startdate , enddate )

Returns the number of date and time boundaries...

That sucks!!!! :angry: I am looking for a job ! :crying:

I could not tell you too much about on call DBA in my former company. Even the on call DBA supposed to be on call 7/24, first not...