Stack Overflow
Stack Overflow

Questions tagged [ezapi]

EzAPI is a .NET library written in C# by Evgeny Koblov one of the testers on the SSIS team to abstracts away a lot of the cumbersome low-level coding needed to create SSIS packages XML directly in a programming language

EzAPI is a .NET library written in C# by Evgeny Koblov one of the testers on the SSIS team to abstracts away a lot of the cumbersome low-level coding needed to create SSIS packages XML directly in a programming language

First, it was published on Codeplex as a part of the SQL Server Integration Services community tools.

After Codeplex is turned into archive it was migrated to a separate project on GitHub:

There are many links on the internet that you can refer to in order to learn more about EzApi such as:

27 questions
10
votes
2 answers

What is the EzAPI equivalent for using an OLE DB Source command from variable?

tl;dr What is the EzAPI code to use an OLE DB Source with data access mode of "SQL command from variable" and assign a variable? Preamble Once a month, we need to refresh our public test site with subsets of production data. We have determined that…
billinkc
  • 59,250
  • 9
  • 102
  • 159
5
votes
1 answer

SSIS Package - Configure Format Version Programmatically

I have developed a custom application which is able to generate SSIS Packages automatically based on some settings which are stored internally in the application. This package used to have PackageFormatVersion (6), which is compatible with(from) SQL…
Stavros Koureas
  • 1,126
  • 12
  • 34
4
votes
1 answer

Flat file source with EzApi

Does anyone have any examples of using EzAPI with a flat file as the data source? All the examples in the documentation start with OleDB connections. Specifically I can't work out how to define input and output columns. Say, for instance, that I…
Dave K
  • 1,845
  • 1
  • 11
  • 9
4
votes
1 answer

How to create a SSIS 2012 Project using EzAPI?

I'm trying to create a SSIS 2012 project using EzAPI. However I'm unable to open my project file in Visual Studio after I've saved it to disk. The code im using to create a simple project containing one package is the following: EzProject MyProject…
Thomas van Bilsen
  • 71
  • 6
3
votes
2 answers

EzAPI OLE DB Destination

I've searched all over and I now have to ask SO. I'm trying to construct a simple dataflow using EzAPI. It's been anything but easy, but I'm committed to figuring this out. What I can't figure out is how to get the EzOleDBDestination working. Here's…
siride
  • 200,666
  • 4
  • 41
  • 62
2
votes
1 answer

EzAPI - SSIS Set EzOleDbDestination Error output configuration

I am creating a C# Program to generate a SSIS package, does anyone know how to set the ErrorOutput property of an EzOleDbDestination object to "Redirect Row"? Edit : EzOleDbDestination db_dest = new EzOleDbDestination(dataFlow) …
luc guerin
  • 59
  • 4
2
votes
3 answers

Creating SSIS package using EzApi

I am using EzApi for creating a SSIS package. However I am unable to create a package having multiple sources and single destination. For example two OLEDB sources and a single OLEDB destination. What exactly I want to know is how to add merge…
Apoorv k
  • 183
  • 1
  • 2
  • 8
2
votes
1 answer

Automatically mapping columns with EZApi with OLEDBSource

Using EZApi, an EzOleDbSource object is created, and assigned the Table property. Another task is added (EzDerivedColumn) and attached to the EzOleDbSource object. When I open the package, I need to click on the OLEDB source to get the column…
dirtyw0lf
  • 1,899
  • 5
  • 35
  • 63
2
votes
1 answer

VSTAScriptingLib for SQL Server 2012

I'm attempting to build the 2012 version of EzAPI for SSIS. I'm getting an assembly dependency error during the build: Error 1 Assembly 'Microsoft.SqlServer.TxScript, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' uses…
Chris Grenz
  • 161
  • 9
1
vote
4 answers

How do you map input to output columns in the MergeJoin transformation with EzAPI?

I'm in the process of programatically building a fairly complex SSIS data flow using the EzAPI library and have hit a snag. I've attached an image of what I'm trying to achieve. I've got the start (up to the merge join) working correctly but have…
Steve Homer
  • 3,852
  • 2
  • 22
  • 41
1
vote
1 answer

Can anyone provide an example of adding logging functionality to an SSIS package created through EzAPI

I'm currently generating a large number (100s) of SSIS packages from C# that are being used to import MS Access databases to a staging area on SQL Server. This is a first step to removing MS Access from this organisation. These packages are working…
Steve Homer
  • 3,852
  • 2
  • 22
  • 41
1
vote
2 answers

Automatically creating tables in an SSIS package with EzAPI

I wouldn't be suprised if this turned out to be a BIDS function rather than available through EzAPI. I've written some code using EzAPI to generate an SSIS package with an OLEDB source and destination. The Destination table however does not exist…
Steve Homer
  • 3,852
  • 2
  • 22
  • 41
1
vote
1 answer

How to Create and Execute an SSIS Package on remote sql Server source and destination using EzAPI

I need to create a Console application that can copy a table from one remote sql server instance to another remote sql server instance. I'm using a library called EzAPI Both connections (Source and Destinations) and table name will be provided as…
Mostafa Elmoghazi
  • 2,124
  • 1
  • 21
  • 27
1
vote
2 answers

EzAPI OLEDB Connection with SQL Authentication

I'm trying to create an SSIS package using EzAPI 2012. The templates and tutorials that I've found works fine but I am not able to find anything on creating a connection to a OLEDB with SQL Authentication (username and password). Here's part of…
AntT
  • 11
  • 1
1
vote
1 answer

Get Row Count for Data Transferred using EzAPI SSIS

I am transferring some data from one table to another using SSIS with EzAPI. How can I get the number of rows that were transferred? My setup is as follows EzPackage package = new EzPackage(); EzOleDbConnectionManager srcConn; …
daniely
  • 7,313
  • 5
  • 29
  • 46
1
2