Executing a DTS package from Sql Server 2005

Posted by Doerr on Stack Overflow See other posts from Stack Overflow or by Doerr
Published on 2010-04-15T21:22:12Z Indexed on 2010/04/16 17:43 UTC
Read the original article Hit count: 346

Filed under:

dts

|

package

|

sql-server-2005

I am trying to run several DTS packages from a sql 2000 box. The DTS calls will originate from .net 2.0 - 3.5 code. I have been unable to find a good way to programmatically accomplish this. What I have read is running a sql job from a stored procedure that calls the DTS package. Does anyone has any experience with this or know of a good way to call the DTS?

Note: For the forseeable future these packages will remain DTS. Eventually we will convert them to SSIS.

Any insight or experience would be very helpful.

© Stack Overflow or respective owner

Related posts about dts

Using Find/Replace with regular expressions inside a SSIS package

as seen on SQL Blog - Search for 'SQL Blog'
Another one of those might-be-useful-again-one-day-so-I’ll-share-it-in-a-blog-post blog posts I am currently working on a SQL Server Integration Services (SSIS) 2012 implementation where each package contains a parameter called ETLIfcHist_ID: During normal execution this will get altered when… >>> More
creating objects in list

as seen on Stack Overflow - Search for 'Stack Overflow'
List myList = new List { new Users{ Name="Kumar", Gender="M", Age=75, Parent="All"}, new Users{ Name="Suresh",Gender="M", Age=50, Parent="Kumar"}, new Users{ Name="Bennette", Gender="F",Age=45, Parent="Kumar"}, new Users{ Name="kian", Gender="M",Age=20, Parent="Suresh"}, new Users{ Name="Nathani"… >>> More
group dynamic data from a List

as seen on Stack Overflow - Search for 'Stack Overflow'
public class SampleProjectData { public static ObservableCollection<Product> GetSampleData() { DateTime dtS = DateTime.Now; ObservableCollection<Product> teams = new ObservableCollection<Product>(); teams.Add(new Product()… >>> More
Remove DTS packages from SQL Server?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, What is the easiest way to remove multiple DTS packages from SQL Server 2008? Thanks. >>> More
Executing a DTS package from Sql Server 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to run several DTS packages from a sql 2000 box. The DTS calls will originate from .net 2.0 - 3.5 code. I have been unable to find a good way to programmatically accomplish this. What I have read is running a sql job from a stored procedure that calls the DTS package. Does anyone has any… >>> More

Related posts about package

PHP Pear Installation on CentOS

as seen on Server Fault - Search for 'Server Fault'
[root@ip ~]# yum install php-pear* Reducing CentOS-5 Testing to included packages only Finished Setting up Install Process Package 1:php-pear-1.8.1-2.el5.centos.noarch already installed and latest versio … >>> More
dbus dependency with yum

as seen on Server Fault - Search for 'Server Fault'
Whenever, I try and run yum update I get the following error: [root@server ~]# yum update Loaded plugins: dellsysid, fastestmirror Loading mirror speeds from cached hostfile * base: mirror01.idc.hinet.net * extras: mirror01.idc.hinet.net * rpmforge: fr2.rpmfind.net * updates: mirror01.idc.hinet… >>> More
RHEL 5.5 Yum Update Fails Dependency Error

as seen on Server Fault - Search for 'Server Fault'
I have 30 different RHEL 5.5 machines that will not update some 33 packages via Yum. Does anyone know why these packages will not install and how to correct this? Yum clean all does not fix the issue, however skip broken will allow other updates to install but I am really after a way to clear this… >>> More
dpkg: warning: files list file for package 'x' missing

as seen on Server Fault - Search for 'Server Fault'
I get this warning for several packages every time I install any package or perform apt-get upgrade. Not sure what is causing it; it's a fresh Debian install on my OpenVZ server and I haven't changed any dpkg settings. Here's an example: root@debian:~# apt-get install cowsay Reading package lists… >>> More
Problem with running open office from the command line

as seen on Super User - Search for 'Super User'
Yesterday I installed OpenOffice on my Linux server. But when I go to run it through the command line, it says command cannot be found. I've also tried other things like OOWriter, etc. Has anyone had this problem? Installation process went like below: root@aserver [OOO330_m20_native_packed-1_en-US… >>> More