DBArtisan can manage 6.5, 7.0 & 2000

the user being a member of database owner role gives him permission to create and save DTS packages.  the problem you are having is that he can not update DTS...

sp_columns tablename

the following stored procedure will bcp out all user tables to separate text files with timestamp as part the file name

-- BCP out all user tables

-- Author       G. Hanson

-- Date...

try this.

1. create the missing logins

2. run exec sp_change_users_login 'report' on your user database that you just recovered to obtain a list of orphan logins

3. run exec sp_change_users_login 'update_one','login','login' where...

not sure this is best way to do it...but I have successfully ported our database over by.

1. create the logins in the new server

2. create the database on the...

the only problem with using the save as package to another server is the version dates of the package will be different on your development and production server.  I just...

I have changed my DTS to import it as an text file with comma dilimiters and it seems to be working.

uncname should work fine...

verify that \\servername\folder\filename is a valid path accessable by owner of the job and sql server agent account.

you may want try mapping to \\servername\folder\filename just...

sounds like its a permission problem...

a few things to look at:

1) when you export to the text file are you using UNC names or drive letters?

2) does the job owner...

Another way is to open the package on the your test server and save it onto your production server with the save as.

But when you have many DTSs to copy...

I suggest that instead of using mapped drives, use the uncname (ex. \\servername\foldername) and verify that the sql server agent account has permissions to the foldername.  As for the...

You may encounter orphaned logins whether you are attaching or restoring.

its not necessary to write an vbscript or a peril program, just use the store procedure xp_cmdshell to execute your dos command

look at blat...

example:

blat - -to userfname@somewhere.com -subject "subject" -body "body text"

there are other parameters available