how i set the schedule job to run dts job ??? i 'm the
beginner of sql server please help me

Hi,

In enterprise manager , Select Data transaformation services , right click
above your DTS package and select the "Schedule pakage" option.

Thanks
Hari
MCDBA

"Auddy" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Right click on the DTS package that you want to run and then select Schedule Package... Once the dialog box opens make the choices that you want for scheduling the package...

----- Auddy wrote: -----

how i set the schedule job to run dts job ??? i 'm the
beginner of sql server please help me

OK

Can you see the packages in Enterprise Manager?
If you can

Right Click on the one you want to schedule | Schedule | now enter the
details in there.

Once you have done that you can go to the Jobs section in Enterprose Manager
on that PC/Server | Refresh them and you should see your job there.

That's the easiest way of doing it

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Auddy" <anonymous (AT) discussions (DOT) microsoft.com> wrote

I have a DTS package that executes perfectly from SEM (Execute package) however it won't run when it is scheduled to run as a job the error message returned follows
The job failed. The Job was invoked by User sa. The last step to run was step 1 (Import Data)
Can you help me pinpoint why?

If you are looking in the Job properties there is a check box in the upper
right corner which allows you to see step details. ALSo make sure you
enable package logging in the package itself.

The usual problem though is this

http://support.microsoft.com/?kbid=269074

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"mbblue" <anonymous (AT) discussions (DOT) microsoft.com> wrote

returned follows:

Thanx for pointing out the MS reference... but this still does not solve the problem I've checked the logins and sysadmin roles and the owners of the package without success
So I saved the package onto the other server where I get the data from and tried running it there through DTS and it worked okay. Then the big test was to create a scheduled job to run the package and try running it
And guess what... it worked... although I really can't understand why it should work one-way and not the other

All that's left is for me to thank you for your response and help.

And the service accounts right ?

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"mbblue" <anonymous (AT) discussions (DOT) microsoft.com> wrote

package without success.
was to create a scheduled job to run the package and try running it.