PC Review


Reply
Thread Tools Rate Thread

Calling DTS package using C#

 
 
=?Utf-8?B?VmlyYWogUmFv?=
Guest
Posts: n/a
 
      3rd May 2007
Hi,

I am calling DTS package using C# in my current application on dev server.
The DTS package tranfers file from Excel to SQL Server table.

When i migrated the package from dev server to production server, i had
forgotten to change the server name in DTS package.

Is there any way i can pass the connection string to DTS package through C#
code, which will prevent rechecking the server name, when migrated from dev
to production server in future.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Wise Package Studio 5.1 - Calling an EXE from within an MSI The CQMMAN Microsoft Windows 2000 MSI 4 18th Jun 2004 09:41 PM
Calling a DTS Package Brennan Microsoft Access ADP SQL Server 1 10th Mar 2004 07:06 AM
Help in calling Oracle Package from aspx page Garfield Microsoft C# .NET 0 4th Mar 2004 07:25 AM
Help in calling Oracle Package from aspx page Garfield Microsoft ADO .NET 0 4th Mar 2004 07:25 AM
Help in calling Oracle Package from aspx page Garfield Microsoft ASP .NET 0 4th Mar 2004 07:25 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:15 PM.