My employer does not mind that I spend time on SQL Server Central because I learn things from this web site and I consider this web site is work related...

Just curious -

Can people ONLY post 'intelligent' question on this web site?

To me, there is no good or bad question, if you don't know the answer, it is better...

You should truncate the staging table first before the transfer data from excel to staging table.

A staging table is a permanent table in the database but acts like a temporary holder of the data.

So every time you delete all the record of the...

I would create a staging table and use DTS to copy the data from excel to this staging table. Then I would compare the data in the staging table...

I think in most cases companies try to put double duties on SQL Developers and now they have to do administrative work. It is definitely in my company, all...

I got it. I make the destination into user variable and make it as expression. Thanks

I totally agree with you !!!!!!

Yes I remote control to the server and run the package under my window logon and it is running fine.

Then I set up the job to run the package using...

Jeff

Don't even get me started with outsourcing. In my last company, I spent 4 days to finish a very complicated report. The outsourcing company had two developers...

It is a network account and it can access the file when I sign on using that account. But when I put it in the job and it failed...

There are a lot of activity in the tempdb.

Right now my plan is put OS in one disk, all data files in another disk and they both configure...

That guy's title is Senior DBA/developer. Obviously he does not know anything about SQL Server administration and I am very much doubted he is a good SQL developer. ...

Unfortunately most companies especially medium size companies do not think that way. They hire SQL developers and they are doing DBA duties which sometimes lead to disaster. However most...

Thanks everyone.