how to schedule integration services package(SSIS) 2005 using Management studio?or is there any

Have anyone successfully accomplished scheduling integration services package using management studio? or is there any other way to do this?

i am scheduling the package to run from SQL SERVER Management Studio using SQL Server Agent,but it is not working.

Help is appreciated.Moving to SSIS forum from Bug Reports Forum.|||

devi_anitha wrote:

Have anyone successfully accomplished scheduling integration services package using management studio? or is there any other way to do this?

i am scheduling the package to run from SQL SERVER Management Studio using SQL Server Agent,but it is not working.

Help is appreciated.

Please provide more details about the error. In the mean time try seraching this forum

How to retain content of TempDB even if SQL Service restart?

Gurus,
I know if SQL Server / SQL Server Services are restarted, TEMPDB is recreated.
Is there any option / way to retain the content of TEMPDB even if SQL Server
/ SQL Server Services restarted?
Help much appreciated.
Thanks
Javed Iqbal
On Mon, 30 Jul 2007 12:32:01 -0700, Javed Iqbal
<JavedIqbal@.discussions.microsoft.com> wrote:

>Gurus,
>I know if SQL Server / SQL Server Services are restarted, TEMPDB is recreated.
>Is there any option / way to retain the content of TEMPDB even if SQL Server
>/ SQL Server Services restarted?
>Help much appreciated.
>Thanks
>Javed Iqbal
No.
Roy Harvey
Beacon Falls, CT
|||> Is there any option / way to retain the content of TEMPDB even if SQL
> Server
> / SQL Server Services restarted?
Yes, re-create the content manually in a startup procedure.
Or, store it in a "real" user database.
Aaron Bertrand
SQL Server MVP
|||Thanks Aaron,
This is what I was looking for...
Thanks a lot
Regards
Javed Iqbal
"Aaron Bertrand [SQL Server MVP]" wrote:

> Yes, re-create the content manually in a startup procedure.
> Or, store it in a "real" user database.
> --
> Aaron Bertrand
> SQL Server MVP
>
>

How to retain content of TempDB even if SQL Service restart?

Gurus,
I know if SQL Server / SQL Server Services are restarted, TEMPDB is recreated.
Is there any option / way to retain the content of TEMPDB even if SQL Server
/ SQL Server Services restarted?
Help much appreciated.
Thanks
Javed IqbalOn Mon, 30 Jul 2007 12:32:01 -0700, Javed Iqbal
<JavedIqbal@.discussions.microsoft.com> wrote:
>Gurus,
>I know if SQL Server / SQL Server Services are restarted, TEMPDB is recreated.
>Is there any option / way to retain the content of TEMPDB even if SQL Server
>/ SQL Server Services restarted?
>Help much appreciated.
>Thanks
>Javed Iqbal
No.
Roy Harvey
Beacon Falls, CT|||> Is there any option / way to retain the content of TEMPDB even if SQL
> Server
> / SQL Server Services restarted?
Yes, re-create the content manually in a startup procedure.
Or, store it in a "real" user database.
--
Aaron Bertrand
SQL Server MVP|||Thanks Aaron,
This is what I was looking for...
Thanks a lot
Regards
Javed Iqbal
"Aaron Bertrand [SQL Server MVP]" wrote:
> > Is there any option / way to retain the content of TEMPDB even if SQL
> > Server
> > / SQL Server Services restarted?
> Yes, re-create the content manually in a startup procedure.
> Or, store it in a "real" user database.
> --
> Aaron Bertrand
> SQL Server MVP
>
>

How to retain content of TempDB even if SQL Service restart?

Gurus,
I know if SQL Server / SQL Server Services are restarted, TEMPDB is recreate
d.
Is there any option / way to retain the content of TEMPDB even if SQL Server
/ SQL Server Services restarted?
Help much appreciated.
Thanks
Javed IqbalOn Mon, 30 Jul 2007 12:32:01 -0700, Javed Iqbal
<JavedIqbal@.discussions.microsoft.com> wrote:

>Gurus,
>I know if SQL Server / SQL Server Services are restarted, TEMPDB is recreat
ed.
>Is there any option / way to retain the content of TEMPDB even if SQL Serve
r
>/ SQL Server Services restarted?
>Help much appreciated.
>Thanks
>Javed Iqbal
No.
Roy Harvey
Beacon Falls, CT|||> Is there any option / way to retain the content of TEMPDB even if SQL
> Server
> / SQL Server Services restarted?
Yes, re-create the content manually in a startup procedure.
Or, store it in a "real" user database.
Aaron Bertrand
SQL Server MVP|||Thanks Aaron,
This is what I was looking for...
Thanks a lot
Regards
Javed Iqbal
"Aaron Bertrand [SQL Server MVP]" wrote:

> Yes, re-create the content manually in a startup procedure.
> Or, store it in a "real" user database.
> --
> Aaron Bertrand
> SQL Server MVP
>
>