Deploy a DTS package on a Web Server C#

Stephen Russell

I have the need to take an existing DTS package off my laptop SQL2000
Developer version and deploy it on a clients site in the near future.

What do I need to do to run this puppy? Can I script it out and run it as
an SP? Or is there a better way? Data was FoxPro going to MSDE.

TIA

__Stephen
--
Stephen Russell
S.R. & Associates
Memphis TN

901.246-0159

Nov 17 '05 #1

Subscribe Reply

1242

Ivan Demkovitch

This suits SQL NG more, but anyway:

Open DTS in EM and Save As "Structured Data Storage"

Take this file with you and on their system using EM

Right-click on "Data Trnsf Services" folder and "Open package"
This is weird hard to find place.

Also, I found it a problem when client has differnt DB name, because you
will need to edit DTS on their machine.,

Hope it helps

"Stephen Russell" <srussell@notat_lotmate.com> wrote in message
news:e$**************@TK2MSFTNGP10.phx.gbl...

I have the need to take an existing DTS package off my laptop SQL2000
Developer version and deploy it on a clients site in the near future.

What do I need to do to run this puppy? Can I script it out and run it as
an SP? Or is there a better way? Data was FoxPro going to MSDE.

TIA

__Stephen
--
Stephen Russell
S.R. & Associates
Memphis TN

901.246-0159

Nov 17 '05 #2

Similar topics

6704

How to Deploy SQL server Database to another PC while creating SetUP package in .Net VB

by: hitendra15 | last post by:

How to Deploy SQL server Database to another PC, How to create a package that craetes Database as well as ODBC driver for accessing data at enduser PC, using .Net VB

Microsoft SQL Server

2687

Problem with Deploy/Package on XP Pro

by: dmiodon | last post by:

Hi - I'm having a problem and hope someone can help me. I created an application in VB6 on a W2K machine. I used the package/deployment wizard to create a setup program. Installing my software...

Microsoft Windows

1760

Viewstate error when Deploy on Server

by: sarvjeet Saini | last post by:

My application is working fine on our local server.We tried on two local servers for testing purpose. But when we host on our main server ,we got the following error: some it work Fine but not...

ASP.NET

961

What do I need to deploy exe to 98/XP machines

by: Domac | last post by:

Just finished developing simple database access application, I get "Application failed ti initialize properly (0xc0000135). Click OK to terminate the application," message when I execute exe!

Visual Basic .NET

2924

General advice needed regarding MS Access, MS SQL Server, MySQL/PostgreSQL

by: Ted | last post by:

I am working on two versions of an application, one of which will be a windows forms application (which will need to be redistributable) and the other will be a web application. I have MS Visual...

Microsoft SQL Server

1081

deploy win2000 server

by: =?Utf-8?B?cm9kY2hhcg==?= | last post by:

hey all, i have an application i'm deploying to my win2000 server that has the same identical Application variables and session variables (because base on a template sort of) as another...

ASP.NET

6065

Sql Server express 2005 deployment

by: =?Utf-8?B?UHVuaXQgS2F1cg==?= | last post by:

Hi, I am developing a windows application in VS.NET 2005. The application is database driven and I need to deploy it on a client's pc. How should I go about developing such an application. I...

C# / C Sharp

1056

SSIS package configuration

by: AksIndya | last post by:

I want to know how I can configure packages (especially connection managers) so that I need not change connection information everytime I deploy package to dev, QA or production environment. I read...

Microsoft SQL Server

6544

Programmatically deploy SQL server 2005 reports and Datasource

by: balaki | last post by:

Hi, I am working on a Installer Project, which requires to deploy SQL Server 2005 Reports (.rdl files) and Datasource (.rds file). The datasource is common for all reports. The report files are...

.NET Framework

1001

MSI Deploy Package> Custom Action when clicking Next

by: azoapes | last post by:

Hi, I've made a Setup Project to my C# WinApp and added a custom dialog to it that asks for user/pass for a database server. Then I created a Custom Action class and override the Install() to check...

.NET Framework

7009

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

7390

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

5475

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

4919

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

4602

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

3103

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

3094

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

665

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

302

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General