Re: DTS Designer without a server.

You can design your DTS package locally (if it's a SQL to SQL
transformation, just create a copy of the databases on remote server, design
and test the package) and then simply save it - either as structured storage
file, or visual basic file. On the target server richt click Data
Transformation Services, choose Open package and select your saved DTS
package.


<shumaker@xxxxxxxxxx> wrote in message
news:1137542813.902442.61650@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>I have SQL 2000 client tools and SQL 2005 express installed. I no
> longer have access to the SQL 2000 server, but need to design DTS
> packages. How can I design DTS packages without access to a SQL server?
>


.

Relevant Pages

  • Re: DTS schedule problem
    ... I found out that the package, sql server agent were running under the SQL ... Who owns the scheduled SQL Agent job? ...
    (microsoft.public.sqlserver.dts)
  • Re: SSIS as part of scheduled job fails
    ... An SSIS package does not run when you call the SSIS package from a SQL ... Microsoft SQL Server Management Studio ...
    (microsoft.public.sqlserver.dts)
  • Re: Problems launching DTS package from Stored Procedure
    ... I cannot run enterprise manager on our server because it is not installed. ... I can post the SQL later if necessary. ... >>package name as a parameter, executes the package and continues on. ...
    (microsoft.public.sqlserver.dts)
  • Re: SSIS package wont run in production server
    ... I also would like to mention that on my production server, ... When you run the setup of SQL 2005, it is indeed possible to install only ... I have a package that I developed on my local machine and runs well. ...
    (microsoft.public.sqlserver.dts)
  • Re: SSIS as part of scheduled job fails
    ... deploying to SQL 2005. ... This server has SQL 2000 as the default instance and a ... Encryptall... ... when you installed the package on the server? ...
    (microsoft.public.sqlserver.dts)