Download Import Using SQL Server Integration Services API

Description

System which imports data into a SQL Server database by creating and executing SSIS packages programmatically. Makes use of: Data Flow Task, Flat File Connection, OLE DB Connection, Flat File Source, Excel Source, XML Source, Data Conversion Transformation, etc.

Source Files

The download file ssis.zip has the following entries.


App.Config//from ww  w. j  a  v a  2s .c o  m
BuildProcessTemplates/DefaultTemplate.11.1.xaml
BuildProcessTemplates/LabDefaultTemplate.11.xaml
BuildProcessTemplates/UpgradeTemplate.xaml
ClassDiagram1.cd
Constants.cs
DelimitedGenerator.cs
Events/ComponentEvents.cs
Events/ImportMessages.cs
Events/PackageEvents.cs
ExcelGenerator.cs
FixedWidthGenerator.cs
FlatFileColumnManager.cs
FlatFileGenerator.cs
Helpers/FlatFileColumnReader.cs
Helpers/SchemaGenerator.cs
Helpers/TableCreator.cs
Helpers/TransformationGeneratorHelper.cs
ImportDirector.cs
ImportOptions.cs
Junk/PackageRunner.cs
Junk/Sample.cs
Model1.Designer.cs
Model1.edmx
NonFlatFileGenerator.cs
PackageGenerator.cs
Program.cs
Properties/AssemblyInfo.cs
SSISFromCode.csproj
SSISFromCode.csproj.vspscc
SSISFromCode.sln
SSISFromCode.vssscc
XMLGenerator.cs

Download

Click the following link to download ssis.zip.

ssis.zip




















Home »
  C# Free Code »
    Database »




ADODotNet
CSV
Database
EntityFramework
JSON
LINQ
LINQPad
Memcached
MongoDB
MySQL
NHibernate
Oracle
ORM
SQL
SQLite
SQLServer
SSIS