anyone knows how to setup the dts run options to:

Source:
Server: remote
auth Mode: SQL
Username: xxx
Password: yyy
Database: bbb

Destination:
server: local
auth mode: sql
username: sa
password blank
database bbb

Copy objects anda data between sql server databases

Create destinantion objects
drop destination objects first
include all dependent objects

Copy data
replace existing data
Copy all objects

So far it's default,
In the default options, i uncheck all the security options.


with this, I wanna create a batch to backup my databases every week...

any hint? links? ebooks?

tks...

On Jul 2, 3:47 pm, "Christiano" <cdo... (AT) digiexpress (DOT) com.br> wrote:
You cannot.
You must first build the package, save it and then run it with dtsrun.

DTSRUN /N"PackageName" /S"server on which you stored your package" ...
etc.

For a detailed syntax take a look here: http://msdn.microsoft.com/en-us/libr...7(SQL.80).aspx

On Jul 2, 3:47 pm, "Christiano" <cdo... (AT) digiexpress (DOT) com.br> wrote:
You cannot.
You must first build the package, save it and then run it with dtsrun.

DTSRUN /N"PackageName" /S"server on which you stored your package" ...
etc.

For a detailed syntax take a look here: http://msdn.microsoft.com/en-us/libr...7(SQL.80).aspx

On Jul 2, 3:47 pm, "Christiano" <cdo... (AT) digiexpress (DOT) com.br> wrote:
You cannot.
You must first build the package, save it and then run it with dtsrun.

DTSRUN /N"PackageName" /S"server on which you stored your package" ...
etc.

For a detailed syntax take a look here: http://msdn.microsoft.com/en-us/libr...7(SQL.80).aspx

On Jul 2, 3:47 pm, "Christiano" <cdo... (AT) digiexpress (DOT) com.br> wrote:
You cannot.
You must first build the package, save it and then run it with dtsrun.

DTSRUN /N"PackageName" /S"server on which you stored your package" ...
etc.

For a detailed syntax take a look here: http://msdn.microsoft.com/en-us/libr...7(SQL.80).aspx

On Jul 2, 3:47 pm, "Christiano" <cdo... (AT) digiexpress (DOT) com.br> wrote:
You cannot.
You must first build the package, save it and then run it with dtsrun.

DTSRUN /N"PackageName" /S"server on which you stored your package" ...
etc.

For a detailed syntax take a look here: http://msdn.microsoft.com/en-us/libr...7(SQL.80).aspx

On Jul 2, 3:47 pm, "Christiano" <cdo... (AT) digiexpress (DOT) com.br> wrote:
You cannot.
You must first build the package, save it and then run it with dtsrun.

DTSRUN /N"PackageName" /S"server on which you stored your package" ...
etc.

For a detailed syntax take a look here: http://msdn.microsoft.com/en-us/libr...7(SQL.80).aspx

On Jul 2, 3:47 pm, "Christiano" <cdo... (AT) digiexpress (DOT) com.br> wrote:
You cannot.
You must first build the package, save it and then run it with dtsrun.

DTSRUN /N"PackageName" /S"server on which you stored your package" ...
etc.

For a detailed syntax take a look here: http://msdn.microsoft.com/en-us/libr...7(SQL.80).aspx

On Jul 2, 3:47 pm, "Christiano" <cdo... (AT) digiexpress (DOT) com.br> wrote:
You cannot.
You must first build the package, save it and then run it with dtsrun.

DTSRUN /N"PackageName" /S"server on which you stored your package" ...
etc.

For a detailed syntax take a look here: http://msdn.microsoft.com/en-us/libr...7(SQL.80).aspx