Wow,

What through explanations from both of you. I will think about David's suggestion.

Brian, no wonder you are a columnist. I read some of the explanations in sql server online book...

Hi Greg,

That's good idea. But when I look at the drop.sql created by datanamic.

In drop column/table constaints area, it is empty, nothing there.

Maybe some other design tools will give some...

Hi, dcpeterson,

Good catch. I only noticed the order: OwnerOrderDetails-->OwnerOrders-->Owners, it's right order and I didn't pay attention to dependents table. Thank you so much.

It seems that auto generated script sometimes...

Hi David:

The error message is look like this: It seems that the row number is missing.

Any idea?

Error Detail Records:

Error:  -2147217913 (80040E07); Provider Error:  245 (F5)

   Error string:  Syntax error converting...

Hi David,

Thanks for your instructions. I used sql server agent to schedule the job.

Do you mean that in Step tab, we can click edit button of the Step, and there is...

Hi Phil,

Actually the import is failed. I don't do any validating after import. As long as it could be imported and I assumed the data is all right.

What I am...

Brian,

Thanks for your expert advise. It seems very efficient to get information from this discussion forum. Ever since I know this discussion forum, I got a lot from it. We...

Hi Brian,

Thanks for your advise and that's good information to me.

I have premium msdn subscription. It seems that I have two versions of sql server 2000 developer edition(1) and sql...

Hi mdaniel,

Good advice and resouce. I will take a look.

Betty

Erich,

Thanks for the idea. I guess I could put those task in a store procedure and let the DTS execute that store procedure. In that store procedure, just like you...

Hi Erich,

I don't know what is the easiest way to check if the rows in the table are valid(use script or DTS package?). If in the DTS package, there is...

Hi johnrowan,

Finally I figured out what went wrong. On Jobs-->DTS package-->General tab

There is select box for selecting owner, it somehow default to the user I used login. I changed the...

Yes, unfortunately, I am the administrator(entry level) in a very small company.

and I am this windows administrator too. I am just a programmer and don't know much about this set...

Don't know the number of limit DTS can handle.

My records is around 10,000 for now. It could grow to several ten thousand later on.

OK, good idea, initially, I didn't pay...

Hi Johnrowan,

In enterprise manager, Under Sql server group, we have two sql server instances, one is MSDE and one is sql server 2000.

When msde sql server groupe was registered, the...