Dts Package Error

Hi,
I intend to export an entire SQL Server DB from one Server t
another. I am not sure abt the best way to do the same, but I trie
diong it using a DTS package. However the package failed to complet
with the following error msg
"The login 'anderson' does not exist"
Can anyone help me out in identifying the prob & also ways to have i
solved.
Thanx in anticipation,
Debs
-
medebaya
----
Posted via http://www.webservertalk.co
----
View this thread: http://www.webservertalk.com/message464954.htmmedebayan,
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
>