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