RE: Transformation service export

From: Mingqing Cheng [MSFT] (v-mingqc_at_online.microsoft.com)
Date: 10/22/04


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!



Relevant Pages

  • Packages wont install
    ... I'm trying to install some packages that were built on a production ... performing a portupgrade -a on the test machine before upgrading ... Package 'OpenSSH-askpass-1.2.2.2001.02.24' depends on 'pkgconfig-0.15.0_1' with 'devel/pkgconfig' origin. ...
    (comp.unix.bsd.freebsd.misc)
  • Re: Installation instructions for Firefox somewhere?
    ... > happy build a package from it and add it to your production server. ... Currently my experimentation is limited solely to the test machine; ...
    (freebsd-questions)
  • Re: cannot resolve symbol error
    ... It should cause a compile time error (specially, ... > javax.sql.rowset resolves to a package"). ... > thinking that the code compiled on the test machine, ...
    (comp.lang.java.help)
  • Re: virtual machines
    ... > I have a test machine, on wich I use to package and test packages. ... No need to reboot, no need for virtual machines. ...
    (Debian-User)