RE: Transformation service export
From: Mingqing Cheng [MSFT] (v-mingqc_at_online.microsoft.com)
Date: 10/22/04
- Next message: Dejan Sarka: "Re: Sevice Pack 3A for SQL"
- Previous message: Mingqing Cheng [MSFT]: "RE: Installing Service Pack on multiple instance cluster"
- In reply to: Sunny: "Transformation service export"
- Next in thread: Sunny: "RE: Transformation service export"
- Reply: Sunny: "RE: Transformation service export"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 22 Oct 2004 05:43:47 GMT
Hi Sunny,
Thanks for your post.
>From your descriptions, I understood that you would like to move the
package from your test machine to your product machine. Have I understood
you?
However, what do you mean by transformation service package? Does it means
Data Transformation Services(DTS) package? If so, you could follow the the
steps below to save DTS packages into your product server.
1. Open each DTS package in the DTS Designer.
2. On the Package menu, click Save As.
3. Specify the destination SQL Server.
For moe detailed information, see the KB below
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/?id=314546#6
Additionally, I found Neil Pike had an excellent answer in the newsgroup
here
http://www.google.com/groups?hl=en&lr=&selm=VA.00004a9e.0c72d206%40compuserv
e.com&rnum=3
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---------------------------------------------------------------
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
- Next message: Dejan Sarka: "Re: Sevice Pack 3A for SQL"
- Previous message: Mingqing Cheng [MSFT]: "RE: Installing Service Pack on multiple instance cluster"
- In reply to: Sunny: "Transformation service export"
- Next in thread: Sunny: "RE: Transformation service export"
- Reply: Sunny: "RE: Transformation service export"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|