Hi Journeyman,

It worked out this time.

I delete the table data through sql command first then

I followed your instruction to manually recreated the DTS package through wizard, saved it and run...

what is .fmt file, I am just start to learn to use DTS. Is it generated SQL script, I saw somewhere can generate it. fotgot?

Betty

Yes, when I manually doing the import, I used wizard again.

DDL:

CREATE TABLE [TIS_StudyUSA_DataEase_test] (

 [AgentCode] [char] (8) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,

 [InsuredSurname] [char] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL ,

 [InsuredFirstname] [char] (20) COLLATE...

I used sql server user name and password.

I tried to use sa, but it gave me the sa login failed, don't how to reset sa account.

Betty

Hi Hourneyman,

I used the wizard. It use a format file. with the first row have column name and each column data is seperated(delimited) by "|".

Don't know if it makes any...

Hi milzs,

That's another good way to do it. I will try it too.

Thank you.

Carl,

That works (same table data). Thank you so much.

You know what I tried as follow before I saw your post.

update myTable set myNewColumn=(Select myOldColumn from myTable where ...)

it didn't work...

Sergiy,

I think this's a great idea. The the way I understand you is as follow:

I can add one more column masterAgentID in the VS table besides the origianl agentID.

It will...

Hi Sergiy,

How do I set up those rules in table. Can you give me an example?

Thanks.

Betty

Hi all,

The initial store procedure I want to write is: I need a list of agent sales during a certain period, from most to least. But among those agents, only...

Hi all,

Thanks all your input, this gets me very excited since this is my first post. I noticed that this is a very active forum. I will take a look...