There are many message boards controlling by some companies.  They constantly monitor what people write on the message board.  One time I went to one message board, I remembered  I...

Managing people is very difficult. Each person has his/her own opinion. In one company my team had 12 people, we argued about everything in every project and the manager did...

Learning the database means learning the business.  If you don't understand the business, it is hard to design a good database.  Also the management has to understand designing the database...

Congradulation!  I am sad but I am also happy for you guys.

I just hope Red Gate will not charge a subscription fee and it...

I am happy for you guys.  Congradulations.  It is a gread SQL Server website and I got so much out of it.

On the other hand, I feel sad because Red...

You can buy any software or you can even create your own data dictationary, but it is labor intensive to fill out the 'Description' of each field in each table....

In one of your thread, most DBAs are talking about telecommute and working at home. So the DBA car is just for show off?

(Just a joke - don't get...

I did this once - except it was the other way, I had to load data from text file into database.

I create a DTS package to load 1 file to...

What is the salary range?

 need to get data out first from TXT file before i try to put into Staging table.

I don't understand what you meant by get the data out before putting them...

Actually I would write a procedure instead of DTS package.

Step 1 - truncate table Staging Table

Step 2 - EXEC MASTER..xp_cmdshell 'bcp stagingtable IN text file...'

Step 3 - check if staging...

Can you give me an example?

SELECT t.pk_ticket, t.company, t.createdate

FROM hd_ticket t

        INNER JOIN (SELECT fk.ticket, MIN (createdate) firstCreateDate

                         FROM hd_communicationlist

                         GROUP BY fk.ticket) c

        ON t.pk_ticket = c.ticket

WHERE t.pk_ticket = '34950' AND DATEADD(hour, 24, c.firstCreateDate) >=...

If you want to know which step

You can put down

Msgbox(stp.Description)

try this.

Function Main()

dim pkg, stp

Main = DTSTaskExecResult_Success

set pkg = DTSGlobalVariables.Parent

For each stp in pkg.Steps

       If stp.ExecutionResult = DTSStepExecResult_Failure

          THEN

          Msgbox ("Error")

          Main = DTSTaskExecResult_Failure

          End If

          Exit For

Next

End Function