by

Vb6 Missing Microsoft Dts Package Object Library

'DTS.Package' is not defined.

Oct 03, 2012 05:02 AM|Kenny_I|LINK

Vb6 Missing Microsoft Dts Package Object Library Access

I have custom web application built with VS2005 and .Net framework 2.0. It can be built with VS and application works fine. The application has used SQL Server 2008 R2 in past and also in future. Our application should run SSIS via web application. VS2005 is installed to different windows server than the following scenario.

Oct 26, 2016 Microsoft DTS Custom Tasks Object Library. Converting DTS to vb.net. The code was in vb6. Although SQL Server 2000 Data Transformation Services (DTS). And Integration Services packages that use the Execute DTS 2000 Package task to run. And then download and install the Microsoft SQL Server 2000 DTS Designer. Packages that were created.

Vb6 Missing Microsoft Dts Package Object Library Free

I have now converted with Wizard the application to VS2010 and .Net framework 4.0. I get now errors related to DTS: I don't find such file when checking whare referenced can be added. What should I do? Anything file missing that I should add to the VS project or the server?

ERROR:

  1. The Microsoft.SqlServer.Dts.Runtime.Wrapper namespace provides the classes and interfaces used to create Control Flow components in the runtime. This assembly is a Primary Interop Assembly (PIA) for the namespace Microsoft.SqlServer.Dts.Runtime, which is the assembly Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll).
  2. All tasks in the package are reviewed for appropriate settings during validation, and all objects in the package are reviewed, including the package, containers, and other components in the package. If there are no problems encountered in the validation phase that would cause the package to fail, the package object proceeds to call the Execute.

Type 'DTS.Package' is not defined. 'DTS' is not declared. It may be inaccessible due to its protection level.

Vb6 missing microsoft dts package object library free

CODE:

Object

Option Strict On

Imports System.Data.SqlClient

Imports Microsoft.SqlServer.Dts.Runtime

Partial Public Class LoadData Inherits System.Web.UI.Page

Vb6 Missing Microsoft Dts Package Object Library Download

Public WithEvents mobjPkgEvents As DTS.Package

Can i play my xbox on my mac. Public goPackageOld As New DTS.Package 'ERROR= 'DTS.Package' is not defined

Public goPackage As DTS.Package2 'ERROR= 'DTS.Package2' is not defined

Contents of BIN folder:

LibraryVb6 Missing Microsoft Dts Package Object Library

Interop.DTS.dll (dated with 17.6.2010)

Microsoft.SqlServer.DTS.RuntimeWrap.dll (dated with 14.10.2005)

Vb6 Missing Microsoft Dts Package Object Library Download

SSIS in my machine:

Microsoft Vb6 Runtime

SQL Server 2008R2 SSIS is installed.