scheduled import/export

I used import/export in SQL 2000 to transfer one table from A server to B
server and save the package and schedule it. This works fine in SQL 2000.
However, when I try to do the same thing in SQL 2005 and after I save the
package, there is no way to schedule it. And I couldn't locate the package I
created in import/export. Does anyone know where I can find the package and
schedule it after the import/export? Is this very different way from
SQL2000? Please help. Thanks.Hi
"00kobebrian" wrote:

> I used import/export in SQL 2000 to transfer one table from A server to B
> server and save the package and schedule it. This works fine in SQL 2000.
> However, when I try to do the same thing in SQL 2005 and after I save the
> package, there is no way to schedule it. And I couldn't locate the package
I
> created in import/export. Does anyone know where I can find the package an
d
> schedule it after the import/export? Is this very different way from
> SQL2000? Please help. Thanks.
If you saved the task as a SSIS package on the server then you will need to
connect to Integration services to find and run the package.
To schedule a job to run the package copy the command line from the run
package dialog and use this as the parameters for DTEXEC.
>
John|||How can I connect to integration services? Thanks.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:94A2C248-9076-4126-9877-1BBFF1AB1FB2@.microsoft.com...
> Hi
> "00kobebrian" wrote:
>
> If you saved the task as a SSIS package on the server then you will need
> to
> connect to Integration services to find and run the package.
> To schedule a job to run the package copy the command line from the run
> package dialog and use this as the parameters for DTEXEC.
> John|||Hi
On Feb 5, 2:31 am, "00EricClapton" <E...@.yahoo.com> wrote:
> How can I connect to integration services? Thanks.
> "John Bell" <jbellnewspo...@.hotmail.com> wrote in message
> news:94A2C248-9076-4126-9877-1BBFF1AB1FB2@.microsoft.com...
>
If you open up object explorere (F8) then there is a large connect
button at the top of the pane. Alternatively you can use the file/
connect object explorer menu options. Choose integration services for
the service type and enter the authentication details.
HTH
John|||Sorry. Do you mean copy the content in "command line" tab in "execute
package utility"? and where is DTEXEC? Thanks.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:94A2C248-9076-4126-9877-1BBFF1AB1FB2@.microsoft.com...
> Hi
> "00kobebrian" wrote:
>
> If you saved the task as a SSIS package on the server then you will need
> to
> connect to Integration services to find and run the package.
> To schedule a job to run the package copy the command line from the run
> package dialog and use this as the parameters for DTEXEC.
> John