RE: Transformation service export

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Sunny (sunny_at_newsgroups.nospam)
Date: 10/22/04 

Date: Fri, 22 Oct 2004 09:18:55 -0500

Thanks,
exactly what I needed.

Cheers
Sunny

In article <mlMKyo$tEHA.2092@cpmsftngxa10.phx.gbl>, v-
mingqc@online.microsoft.com says...
> 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

  • Re: multiple excel file import
    ... Remember DTS packages ... >file here but when executing it says the directories are bad? ... then use on task and a loop in the package. ... global community for SQL Server professionals ...
    (microsoft.public.sqlserver.dts)
  • Re: Is it ok to leave connection standing alone?
    ... DTS packages to copy daily production files from one area to another and then ... When I try to run the package I get an error message saying that their is no ... "Microsoft OLE DB Provider for SQL server" connection. ...
    (microsoft.public.sqlserver.dts)
  • Re: DTSRun Command Line
    ... it runs from the location where the package is ... try testing by logging onto the server and executing ... >SQL Server and SQL Server agent run as SQLAgtSA. ... >about running DTS packages and it seems to me everything is OK. ...
    (microsoft.public.sqlserver.dts)
  • Re: How can I change DTS owner
    ... > I have written a whole series of DTS packages for a client that I wish to ... > with my logon as the owner and I do not have the necessary permissions ... > owner of the package to someone who does have rights? ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ...
    (microsoft.public.sqlserver.dts)
  • Re: Can you use osql in DTS?
    ... This sounds simple enough to do in a single package. ... ActiveX Script task to build the date and time strings to populate the ... Data Pump task that executes a proc that populates a table and then ... Columnist, SQL Server Professional ...
    (microsoft.public.sqlserver.dts)