Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server DTS
Reload this Page Problem loading a saved DTS package
|
SQL Server DTS Discussion specific to Data Transformation Service with SQL Server. General SQL Server discussions should use the general SQL Server forum. Readers of the book Professional SQL Server 2000 DTS with questions specific to that book should post in that book forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server DTS section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 31st, 2006, 05:08 AM
Registered User
  
Join Date: Sep 2005
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default Problem loading a saved DTS package
I have saved a DTS package using the Save As facility within DTS Design and saved with a Location of 'Structured Storage File'.

I now need to restore this into SQL Server but I cannot find a Load or Open option and dragging and dropping doesn't work.

I would be grateful for any help.

Cheers
Adrian
 
Old June 1st, 2006, 04:30 AM
Registered User
  
Join Date: Sep 2005
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default
My apologies, I was right clicking everywhere except the Data Transformation Service link, where on doing so I noticed the Open option.

Sorry guys.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with DTS PACKAGE mxwebb SQL Server DTS 1 November 28th, 2007 05:16 PM
DTS PACKAGE QUESTIONS girl SQL Server DTS 0 June 6th, 2007 02:58 AM
scheduling a DTS package psugak SQL Server DTS 3 March 29th, 2007 01:26 PM
DTS Package Export Data to XML Problem kwilliams SQL Server DTS 1 January 3rd, 2006 02:22 PM
Problem Scheduling a job on DTS package. pooh2323 SQL Server DTS 2 February 12th, 2004 02:12 PM




Contact Us - Wrox - Privacy Statement - Top

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.