DTS problem\bug

We have a server W2k\SQL2k in which we are able to open a DTS designer, save
the package, but on refresh the DTS package is not listed. We rebooted the
server, and run set of DBCC’s which all came clean. Did anyone experience
similar issue?
Hi
I have not seen this behavour before and it's not listed on
http://www.sqldts.com/default.aspx?106
Are you saving the package into the database? If you save it into a
structured file, what happens if you try to import it and save it into the
database?
If this package is being imported from elsewhere, are you at the same
service pack and MDAC levels?
If all that fails you may want to run profiler to see that the package gets
inserted into msdb.
John
"MikeS" <MikeS@.discussions.microsoft.com> wrote in message
news:E60E3786-0D0D-4FA8-B169-4C8918C5DBED@.microsoft.com...
> We have a server W2k\SQL2k in which we are able to open a DTS designer,
save
> the package, but on refresh the DTS package is not listed. We rebooted the
> server, and run set of DBCC's which all came clean. Did anyone experience
> similar issue?

DTS problem\bug

We have a server W2k\SQL2k in which we are able to open a DTS designer, save
the package, but on refresh the DTS package is not listed. We rebooted the
server, and run set of DBCCâ's which all came clean. Did anyone experience
similar issue?Hi
I have not seen this behavour before and it's not listed on
http://www.sqldts.com/default.aspx?106
Are you saving the package into the database? If you save it into a
structured file, what happens if you try to import it and save it into the
database?
If this package is being imported from elsewhere, are you at the same
service pack and MDAC levels?
If all that fails you may want to run profiler to see that the package gets
inserted into msdb.
John
"MikeS" <MikeS@.discussions.microsoft.com> wrote in message
news:E60E3786-0D0D-4FA8-B169-4C8918C5DBED@.microsoft.com...
> We have a server W2k\SQL2k in which we are able to open a DTS designer,
save
> the package, but on refresh the DTS package is not listed. We rebooted the
> server, and run set of DBCC's which all came clean. Did anyone experience
> similar issue?

DTS problem\bug

We have a server W2k\SQL2k in which we are able to open a DTS designer, save
the package, but on refresh the DTS package is not listed. We rebooted the
server, and run set of DBCC’s which all came clean. Did anyone experience
similar issue?Hi
I have not seen this behavour before and it's not listed on
http://www.sqldts.com/default.aspx?106
Are you saving the package into the database? If you save it into a
structured file, what happens if you try to import it and save it into the
database?
If this package is being imported from elsewhere, are you at the same
service pack and MDAC levels?
If all that fails you may want to run profiler to see that the package gets
inserted into msdb.
John
"MikeS" <MikeS@.discussions.microsoft.com> wrote in message
news:E60E3786-0D0D-4FA8-B169-4C8918C5DBED@.microsoft.com...
> We have a server W2k\SQL2k in which we are able to open a DTS designer,
save
> the package, but on refresh the DTS package is not listed. We rebooted the
> server, and run set of DBCC's which all came clean. Did anyone experience
> similar issue?sqlsql

DTS packages on new SQL Server

We're building a new W2K server with the same name as the current one. We
are taking down the old server, moving all the datafiles to the new server,
installing SQL Server, Analysis Services and sp3. The last time we did this
we lost our DTS packages. Can I export them somehow and then import them?
Are they not stored in the system tables?
Thanks,
DougThey are stored in the MSDB database, but moving that database is always
trickey. You can load the DTS packages into Enterprise Mangler and save
them to the file system. You can then reload and resave them when the new
server is ready. If you have a lot of packages, you can write a script to
do that automagically using SQL-DMO and the Package2 object.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Doug Stiers" <stiers@.email.com> wrote in message
news:ehNaTDFDEHA.2308@.tk2msftngp13.phx.gbl...
> We're building a new W2K server with the same name as the current one. We
> are taking down the old server, moving all the datafiles to the new
server,
> installing SQL Server, Analysis Services and sp3. The last time we did
this
> we lost our DTS packages. Can I export them somehow and then import them?
> Are they not stored in the system tables?
> Thanks,
> Doug
>|||OK, I saved a package to a .dts file. How do I import/execute that file?
Thanks,
Doug
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:Ormd6IFDEHA.3568@.tk2msftngp13.phx.gbl...
> They are stored in the MSDB database, but moving that database is always
> trickey. You can load the DTS packages into Enterprise Mangler and save
> them to the file system. You can then reload and resave them when the new
> server is ready. If you have a lot of packages, you can write a script
to
> do that automagically using SQL-DMO and the Package2 object.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Doug Stiers" <stiers@.email.com> wrote in message
> news:ehNaTDFDEHA.2308@.tk2msftngp13.phx.gbl...
We
> server,
> this
them?
>|||I found out how to do this by right clicking on the DTS folder in EM
I should have posted my question in: microsoft.public.sqlserver.tools
"Doug Stiers" <stiers@.email.com> wrote in message
news:%231U091FDEHA.3064@.tk2msftngp13.phx.gbl...
> OK, I saved a package to a .dts file. How do I import/execute that file?
> Thanks,
> Doug
>
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:Ormd6IFDEHA.3568@.tk2msftngp13.phx.gbl...
new
> to
> We
> them?
>|||Don't worry about it. .Server is pretty much a catch-all anyway.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Doug Stiers" <stiers@.email.com> wrote in message
news:uIICb9FDEHA.2908@.TK2MSFTNGP09.phx.gbl...
> I found out how to do this by right clicking on the DTS folder in EM
> I should have posted my question in: microsoft.public.sqlserver.tools
>
> "Doug Stiers" <stiers@.email.com> wrote in message
> news:%231U091FDEHA.3064@.tk2msftngp13.phx.gbl...
always
save
> new
script
one.
did
>