THNK YOU JEFF! It works great!  except the result returns only the applicant available for the job, I need it to display zero in 'Received Applicants' when this job doesn't...

Thank you.  I got it.

sorry that i didn't make it clear, but here is the example:

T1:

employid   Jobtitle

123456789   030

999999999   036

T2

employid    Paycode  Payrate

123456789   1135    10

123456789   7000    50.69

999999999   1200    50000

999999999   3200    146

There is no lookup table for...

All the employees have more than 1 record, and I only want to have one based on employid and I don't care which one I deleted.

However, the code I write...

can you guide me to it?

Infact, I am new to the DTS package.

I need to schedule the task to run for a monthly basis.  These 2 servers are linked already.

And actually, I inserted data already. ...

My source table is a summary table, which contains Store_number, TotalAmt, Sales_Month, and Sales_Year.  It doesn't have a Row_ID column.

The destination table is from database for a Real Estate application,...

I am sorry that I didn't explain it clearly.

The source table doesn't have ROW_ID column, so I have to create this Row_id dynamically.  

Please suggest me how to do it. ...

It's not an identity field. 

Actually, I am using DTS load the summary data into a table which contains the row_id column and I received an error:

Cannot insert the value...

Hi Jeff,

Thank you for your reply.  But I am sorry that I didn't explain my situation clearly.

The Location_2 has more than 40 different values and it can be changed/added/deleted anytime...

Thank you Andy.  I did test the connection and stop/started the service.

But I still not able to send attachment.

the two following TransactSQL show different

results:

1. with attachment

master..xp_sendmail

@recipients = 'xxx@company.com',

@subject =...

Thank you Carl.

I don't mind to loss job history, so I run the script again and re-created the jobs.  Now they are running perfectly.

Thank you Andrew.  It does work after I set originating_server to new server name and I checked the properties of all jobs, the source server did changed to the correct...

Carl, thank you so much.  It works perfectly.

well, I never used BCP utility. I am executing the following command in SQL Query Analyzer:

bcp "HRCHRIS.[dbo].[Mgmt_App_Resume_Table]" out "Resume.txt" -c -q -U"HRIS" -P"HRIS"

and here's the error message:

Server: Msg 179, Level...