vb6 missing microsoft dts package object library

You either need to install SSIS on the machine where you are trying to run the package from, or run the package on the server machine. Starting a package in Object Explorer does not run the package on a different server machine - it runs it locally. When you run DTExec.exe or DTExecUi.exe (right clicking on a package to run it via Object Explorer) the packages runs on the machine where you start it. SSIS is installed on a server, and you try to run the package on a workstation, usually using SSMS). Why I'm still getting this error?Ī: Most likely, you try to run the package on a different machine (e.g. Q: I've installed SQL Server Enterprise/Developer edition, including SSIS. To run the package standalone (DTEXEC, as Agent Job, etc), you need the full SSIS installation.

When you install Workstation Components (including BIDS) you get a subset of SSIS that allows you to design and debug packages in BIDS. Q: But I can run the package inside Business Intelligence Development Studio - this means I have the SSIS installed, right?Ī: Not really. Go to Start menu > Run > Services.msc and look for 'SQL Server Integration Services 10.0' for SQL 2008 and 'SQL Server Integration Services' for SQL 2005 If this service is missing, SSIS is not installed on this machine.Ģ. If you've installed SSIS, there should be a service called SQL Server Integration Services. Open Computer Management or SQL Server Configuration Management, open SQL Server 2005 Services node. So there are two simple ways to check if you've installed SSIS and if the SSIS service is present.ġ. Q: How do I check if I've installed SSIS?Ī: One of the features installed with full SSIS, but not included in the Workstation Components setup is SSIS Service. So to correct the problem, you either need to install SSIS on the production machine where package runs, or move the package execution to the machine where the full SSIS version is already installed. running with DTEXEC, inside Agent or custom tools) require full SSIS installation. You can also run Import/Export Data Wizard and execute the resulting package inside the wizard. If you have installed Workstation Components, you can create, edit and debug packages in Business Intelligence Development Studio (BIDS). Fuzzy and Data Mining transforms require Enterprise or Developer edition.

Another possible reason is that the package uses components that require higher edition of SQL Server - e.g. The error tells you that you have not installed SSIS on the machine where the package is running, probably you've only installed SQL Server and Workstation Components. The hexadecimal value for this error number = 0xC00470FE. cannot run on this edition of Integration Services.

Vb6 missing microsoft dts package object library