May 6, 2008 at 1:11 pm
Hi All, Here is the scenario:
I have developed a basic SSIS package, SQL 2000 as db.We don't have SQL 2005 yet. I can run the package in the IDE. Is there a way that i can call this package in c#. I tried but it always says in compatible version. I am thinking i can not call an SSIS package in c# that connects to SQL 2000. So i have developed DTS package and was able to call the package in C#.
Is it necessary that i need SQL 2005 to call SSIS package in C# ?
Any input would be really helpfull.
Thanks in advance.
May 6, 2008 at 1:22 pm
You can add references to the "DTS Runtime libraries" and get to the packages from there (it's the SSIS runtime as well, just under the "old" name).
How did you develop this? SQL Server 2000 doesn't use SSIS - that's the "new name" (among other things) for SQL 2000's DTS. (actually SSIS is much more than just a new name for DTS, but it's what replaced it in 2005).
Now - you COULD run SSIS without a 2005 server but you would need some 2005 components installed (at very least the client tools). You could also make some type of install package to your C# program to install and register the right SSIS libraries if you so desire.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
May 6, 2008 at 1:36 pm
I have actually installed sql 2005 express on the local box along with sql management studio. But our main daatabse is sql 2000. I am connecting to sql 2000 box(dev server) using SSIS developed on the local box. Now it is time for moving code to production. There is windows service that runs in our app server. I will have to integrate this package with this service using c#. I was thinking i need sql 2005 otherwise c# will not execute the package. You are saying i can call the ssis package(sql 2000 db), thats some good news. I need to find what need to be registered on the app server box.
May 6, 2008 at 1:48 pm
As far as I know - all you need are two references (that can be set to "copy local" during your project setup):
Microsoft.SQLserver.DTSRuntimeWrapper
Microsoft.SQLServer.ManagedDTS
Assuming those are there I don't think you need anything else installed.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply