Dts Package Error

Hi,
I intend to export an entire SQL Server DB from one Server to another.
I am not sure abt the best way to do the same, but I tried diong it using a
DTS package. However the package failed to complete with the following erro
r msg
"The login 'anderson' does not exist"
Can anyone help me out in identifying the prob & also ways to have it solved
.
Thanx in anticipation,
Debs.medebayan,
Why not use backup/restore, or detach/attach? They are much simpler ways
of accomplishing this.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
medebayan wrote:
> Hi,
> I intend to export an entire SQL Server DB from one Server to
> another. I am not sure abt the best way to do the same, but I tried
> diong it using a DTS package. However the package failed to complete
> with the following error msg
> "The login 'anderson' does not exist"
> Can anyone help me out in identifying the prob & also ways to have it
> solved.
> Thanx in anticipation,
> Debs.
>
> --
> medebayan
> ---
> Posted via http://www.webservertalk.com
> ---
> View this thread: http://www.webservertalk.com/message464954.html
>