DTS Remote Scheduling

Hello all,
I am moving data from sql to sql.
I have created my packages (structured storage files) via my computer
these packages are stored on the sql srever and I access them remotely
via my own computer.
My question is
1. How can I also REMOTELY schedule these packages or create jobs s
that these packages run out of office hours.
This is what I tried but it failed to work...
I open enterprise manager and clicked on to the server in question
I then clicked on 'MANAGEMENT' and 'JOBS'
I right clicked 'jobs' and clicked 'NEW JOB'
I then completed the four tabs (general, step, schedules
notifications).
After the package was supposed to have run, I viewed the job histor
and found out that it failed.
is there a way to be able to schedule a package (structured storag
file) from another computer
--
newomog
----
newomoge's Profile: http://www.msusenet.com/member.php?userid=253
View this thread: http://www.msusenet.com/t-187055672Why did it fail? The general reason that a DTS package will work when you
run it but fail when scheduled is due to permissions, specifically because
when run by a job (assuming the job is owned by a sysadmin) it will run as
the SQL Agent Service Account. Have a look at
INF: How to Run a DTS Package as a Scheduled Job
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q269074
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"newomoge" <newomoge.1r1e0s@.no-mx.msusenet.com> wrote in message
news:newomoge.1r1e0s@.no-mx.msusenet.com...
> Hello all,
> I am moving data from sql to sql.
> I have created my packages (structured storage files) via my computer.
> these packages are stored on the sql srever and I access them remotely
> via my own computer.
> My question is
> 1. How can I also REMOTELY schedule these packages or create jobs so
> that these packages run out of office hours.
> This is what I tried but it failed to work...
> I open enterprise manager and clicked on to the server in question
> I then clicked on 'MANAGEMENT' and 'JOBS'
> I right clicked 'jobs' and clicked 'NEW JOB'
> I then completed the four tabs (general, step, schedules,
> notifications).
> After the package was supposed to have run, I viewed the job history
> and found out that it failed.
> is there a way to be able to schedule a package (structured storage
> file) from another computer?
>
> --
> newomoge
> ---
> newomoge's Profile: http://www.msusenet.com/member.php?userid=2530
> View this thread: http://www.msusenet.com/t-1870556724
>sqlsql

DTS Remote Scheduling

Hello all,
I am moving data from sql to sql.
I have created my packages (structured storage files) via my computer.
these packages are stored on the sql srever and I access them remotely
via my own computer.
My question is
1. How can I also REMOTELY schedule these packages or create jobs so
that these packages run out of office hours.
This is what I tried but it failed to work...
I open enterprise manager and clicked on to the server in question
I then clicked on 'MANAGEMENT' and 'JOBS'
I right clicked 'jobs' and clicked 'NEW JOB'
I then completed the four tabs (general, step, schedules,
notifications).
After the package was supposed to have run, I viewed the job history
and found out that it failed.
is there a way to be able to schedule a package (structured storage
file) from another computer?
newomoge
newomoge's Profile: http://www.mswebservertalk.com/member.php?userid=2530
View this thread: http://www.mswebservertalk.com/t-1870556724
Why did it fail? The general reason that a DTS package will work when you
run it but fail when scheduled is due to permissions, specifically because
when run by a job (assuming the job is owned by a sysadmin) it will run as
the SQL Agent Service Account. Have a look at
INF: How to Run a DTS Package as a Scheduled Job
http://support.microsoft.com/default...;en-us;Q269074
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"newomoge" <newomoge.1r1e0s@.no-mx.mswebservertalk.com> wrote in message
news:newomoge.1r1e0s@.no-mx.mswebservertalk.com...
> Hello all,
> I am moving data from sql to sql.
> I have created my packages (structured storage files) via my computer.
> these packages are stored on the sql srever and I access them remotely
> via my own computer.
> My question is
> 1. How can I also REMOTELY schedule these packages or create jobs so
> that these packages run out of office hours.
> This is what I tried but it failed to work...
> I open enterprise manager and clicked on to the server in question
> I then clicked on 'MANAGEMENT' and 'JOBS'
> I right clicked 'jobs' and clicked 'NEW JOB'
> I then completed the four tabs (general, step, schedules,
> notifications).
> After the package was supposed to have run, I viewed the job history
> and found out that it failed.
> is there a way to be able to schedule a package (structured storage
> file) from another computer?
>
> --
> newomoge
> newomoge's Profile: http://www.mswebservertalk.com/member.php?userid=2530
> View this thread: http://www.mswebservertalk.com/t-1870556724
>

DTS Remote Scheduling

Hello all,
I am moving data from sql to sql.
I have created my packages (structured storage files) via my computer.
these packages are stored on the sql srever and I access them remotely
via my own computer.
My question is
1. How can I also REMOTELY schedule these packages or create jobs so
that these packages run out of office hours.
This is what I tried but it failed to work...
I open enterprise manager and clicked on to the server in question
I then clicked on 'MANAGEMENT' and 'JOBS'
I right clicked 'jobs' and clicked 'NEW JOB'
I then completed the four tabs (general, step, schedules,
notifications).
After the package was supposed to have run, I viewed the job history
and found out that it failed.
is there a way to be able to schedule a package (structured storage
file) from another computer?
newomoge
---
newomoge's Profile: http://www.msmcse.ms/member.php?userid=2530
View this thread: http://www.msmcse.ms/t-1870556724Why did it fail? The general reason that a DTS package will work when you
run it but fail when scheduled is due to permissions, specifically because
when run by a job (assuming the job is owned by a sysadmin) it will run as
the SQL Agent Service Account. Have a look at
INF: How to Run a DTS Package as a Scheduled Job
http://support.microsoft.com/defaul...b;en-us;Q269074
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"newomoge" <newomoge.1r1e0s@.no-mx.msmcse.ms> wrote in message
news:newomoge.1r1e0s@.no-mx.msmcse.ms...
> Hello all,
> I am moving data from sql to sql.
> I have created my packages (structured storage files) via my computer.
> these packages are stored on the sql srever and I access them remotely
> via my own computer.
> My question is
> 1. How can I also REMOTELY schedule these packages or create jobs so
> that these packages run out of office hours.
> This is what I tried but it failed to work...
> I open enterprise manager and clicked on to the server in question
> I then clicked on 'MANAGEMENT' and 'JOBS'
> I right clicked 'jobs' and clicked 'NEW JOB'
> I then completed the four tabs (general, step, schedules,
> notifications).
> After the package was supposed to have run, I viewed the job history
> and found out that it failed.
> is there a way to be able to schedule a package (structured storage
> file) from another computer?
>
> --
> newomoge
> ---
> newomoge's Profile: http://www.msmcse.ms/member.php?userid=2530
> View this thread: http://www.msmcse.ms/t-1870556724
>

Dts Package Execute Problem

Hi all,

I run a dts from my aspx page. It works on my computer (win xp) fine, but it does not start to work when i deploy project to server 2003.

In my computer sql 2000 is installed but it is not installed on win2003 server. So my error's cause is this. My error is :

Retrieving the COM class factory for component with CLSID {10020200-EB1C-11CF-AE6E-00AA004A34D5} failed due to the following error: 80040154.

I could not solve it. I look atthis topic but i got the same errors.

Can i run dts without installing sql server on win2003 machine anyway?

Extra "dtspkg.rll" file and files onthis topic must be registered.

Regards..

DTS package

I am tring to back up my remote site's data to my computer here at home.

I use DTS wizard from EM and copy objects and data (is this correct?)

Then I choose to save the package as SQL package, give it a name and times to run etc.

However I can't find where it has saved if indeed it has.
I've looked under SQL server agent jobs and management local packages but it's not there.

I'm sure I'm doing it all wrong!

Thanks for any advice.

JBDid you create the package on Your computers Sql Server or on the Remote Server? I am sure that is the problem. Check both locations.|||Thanks Wes,

But.. how on earth do I create this on the remote Database?

JB