How to use SQL Server Integration Services with DtsClient
In this article I will explain about Integration Services.
Introduction
SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks.SSIS is a platform for data integration and workflow applications.
Coding
VB.NET code
Imports Microsoft.SqlServer.Dts.DtsClient
Dim myConnection As DtsConnection = New DtsConnection;();
myConnection.ConnectionString = myConnectionString
myConnection.Open()
//execute queries, etc
myConnection.Close()
|
C# code
using Microsoft.SqlServer.Dts.DtsClient;
DtsConnection myConnection = new DtsConnection;();
myConnection.ConnectionString = myConnectionString;
myConnection.Open();
//execute queries, etc
myConnection.Close();
|
Connecting to a package located in the file system
/FILE "C:\folder\DtsClientWParamPkg.dtsx"
|
Connecting to a package stored in msdb
Connecting to a package in the Integration Services package store
/DTS \folderName\packageName
|
You may also want to read these related articles :
here
Ask Your Question
Got a programming related question? You may want to post your question here
Programming Answer here