No, we don't. Sorry for the late response.

Yes, you are right, it is a windows update.

But how it happens I don't think we set up to do the automatically update for servers.

We do it manually.

Thanks, that helps.

Thanks, yes, that makes sense.

So that means if I gives the MSA account the appropriate permissions to the databases on the other sevver, or file directory on the other server,...

attached is the table script

figured out, it seems it doesnot like inline comments

Thanks, will try that

You are right, although I have some reason but I think maybe I should keep it consistent.

A derived question, U use dt_numeric precision 38, scale 1, when I export I...

Thanks, all, you are right , I hope use that maintenance plan task as an easier way to do the clean up, now I got to know it doesn't work...

Thanks both of you

update:

Here is what I found out, after I need to restart SQl agent serivce, for I just installed oracle client on the server, and the SQl agent account does not...

Unless I miss my guess, the OP is importing the flat-file data into a staging table with studentID defined as varchar(9), even though he expects the values to be integers,...

Thanks Steve and Jeff.

I don't know if we can buy some tool now for this split. probably not at this time.

This looks quite complicated about spliting, I will look at...

Thanks much

Thanks all!