DTS Packages Export in one step

#1

There are many Local Packages in the Data Transformation Services, in the SQL
Server 2000. How can I transform them and use in another SQL Server like the
other objects (tables, views, stored procedures etc.) ?
I want to export them in step like copying objects and data between SQL
Server databases or
using a query to specify the data to transfer.

#2

Hi Alur,
you could use a program called 'DtsBackup2000' very useful in these cases.
Regards,

--
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''s hard to provide information
without seeing the code. location: Alicante (ES)

"Alur" wrote:

Quote:

There are many Local Packages in the Data Transformation Services, in the SQL
Server 2000. How can I transform them and use in another SQL Server like the
other objects (tables, views, stored procedures etc.) ?
I want to export them in step like copying objects and data between SQL
Server databases or
using a query to specify the data to transfer.

#3

Hello Alur,

Have a look at our site for a reasonable solution or two

http://www.sqldts.com/default.aspx?204

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Quote:

There are many Local Packages in the Data Transformation Services, in
the SQL
Server 2000. How can I transform them and use in another SQL Server
like the
other objects (tables, views, stored procedures etc.) ?
I want to export them in step like copying objects and data between
SQL
Server databases or
using a query to specify the data to transfer.

#4

Thank you.

"Allan Mitchell" wrote:

Quote:

Hello Alur,

Have a look at our site for a reasonable solution or two

http://www.sqldts.com/default.aspx?204

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

There are many Local Packages in the Data Transformation Services, in
the SQL
Server 2000. How can I transform them and use in another SQL Server
like the
other objects (tables, views, stored procedures etc.) ?
I want to export them in step like copying objects and data between
SQL
Server databases or
using a query to specify the data to transfer.

#5

Thank you.

"Enric" wrote:

Quote:

Hi Alur,
you could use a program called 'DtsBackup2000' very useful in these cases.
Regards,

--
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''s hard to provide information
without seeing the code. location: Alicante (ES)

"Alur" wrote:

There are many Local Packages in the Data Transformation Services, in the SQL
Server 2000. How can I transform them and use in another SQL Server like the
other objects (tables, views, stored procedures etc.) ?
I want to export them in step like copying objects and data between SQL
Server databases or
using a query to specify the data to transfer.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS Packages Export in one step

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS Packages Export in one step - 04-05-2006 , 03:19 AM

RE: DTS Packages Export in one step - 04-05-2006 , 11:03 AM

Re: DTS Packages Export in one step - 04-05-2006 , 02:35 PM

Re: DTS Packages Export in one step - 04-09-2006 , 10:01 PM

RE: DTS Packages Export in one step - 04-17-2006 , 03:59 AM