What tool should I use to run this script? Thanks.

Please help. Thank you very much.

No. This is not a trick question. I am new. That's why. May I know where do you set this up?Is it Business Intelligence Development Studio? I couldn't find it....

Is the Filesystem object script in the SSIS? I tried to find the overwrite property but cannot find it. Can you please tell me where it is? It will be...

Because I am running a daily job to do the export to a xls file. But I don't want to append everyday. Instead I want to overwrite and I don't...

Can anyone please help? Thanks.

I solved the problem by adding data conversion task between source and

destination. But this does only for append. How can I do it for overwrite?

Thanks.

What is the dbase datatype as corresponding to SQL server varchar datatype? Thanks.

There is a dbt file when doing import/export in sql2000 which I need. But if I do it with excel, then the dbt file cannot be generated. PLease help. Thanks.

Sorry.  I mean in SQL 2005, there is no such selection at all.

I read Q312995. What do I need to do in the registry? Please advice me. I don't think it mention explicitly. Thanks.

I solve the problem by running sp_changedbowner "sa" . Thanks to all who helps.

Supernova

Does anyone know how to solve this problem?

Hi Karen,

Thanks for the advice. Can you elaborate a bit on your advice? I don't understand. THanks.

Supernova

I typed the following command with sa login id:

exec sp_change_users_login "Update_One", "dbo", "sa"

Server: Msg 15287, Level 16, State 1, Procedure sp_change_users_login, Line 34

Terminating this procedure. 'sa' is a forbidden value...