29 questions
Score of 2
2 answers
103 views
Creating EzApi for SQL Server 2022
I used EzApi to generate SSIS (SQL Server Integration Services) packages programmatically in C#. Back then, I relied on the original Microsoft EzApi project from CodePlex, which has been discontinued ...
Score of 0
0 answers
21 views
ezAPI What is the correct format for EzExcelCM ConnectionString
I'm trying to create a EzAPI dataflow with an Excel Source but it keeps giving me a type error which I suspect has to do with the fact that I'm not sure how to create the EzExcelCM connection string. ...
Score of 2
1 answer
108 views
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 = ...
Score of 0
1 answer
130 views
Is there a way to provide IIS with the location of a DLL that your MVC solution depends on?
I am building an application that scaffolds a SSIS package using EzAPI (Version 0.8.5). The code runs perfect within visual studio, no errors or bugs until I publish the MVC application (.NET 4.5) to ...
Score of 5
1 answer
325 views
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 ...
Score of 1
2 answers
360 views
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 ...
Score of 0
2 answers
333 views
SSIS & EzAPI: Calling constructor of EzDerivedColumn results in HRESULT: 0xC0048021
I encountered an issue with SSIS & EzAPI. Here's the code
EzPackage package = new EzPackage();
package.Name = "[Insert My Table Name]";
EzDataFlow parent = new EzDataFlow(package);
dataFlow.Name =...
Score of 0
2 answers
159 views
Set DelayValidation property using EzAPI
I am using EzAPI to build an SSIS package.
FlatFileSource -> DerivedColumn -> ODBC Destination.
But I can't find where to set the Delay Validation property to true. It's not letting me do so in the ...
Score of 1
1 answer
255 views
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(...
Score of 1
3 answers
418 views
Warning messages with EZAPI EzDerivedColumn and input columns
When adding a derived column to a data flow with ezAPI, I get the following warnings
"Add stuff here.Inputs[Derived Column Input].Columns[ad_zip]" on "Add
stuff here" has usage type READONLY, but ...
Score of 0
2 answers
314 views
How to set Query Parameters
How to map the OLE DB source SQL command query parameters with variables using EzAPI ?
Basically I need to do something like below.
Thanks in advance.
Score of 0
1 answer
1400 views
How to add multiple DataFlow tasks to a Foreach container
How to add multiple data flow tasks to a single foreach container using EzAPI. Basicly I need to do as following.
I am new to EzAPI. Can anyone give me a code sample for this kind of scenario. Thanks ...
Score of 1
0 answers
475 views
Receiving warning messages with EZAPI EzDerivedColumn and input columns
I am working with EZApi to assist in creating a package to stage data for transformation. It is working in terms of data movement. When opening the package in the designer however there are warning ...
Score of 0
1 answer
390 views
How can I retrieve a package and use its executables/components to be attached to added components in EzAPI?
I have a package, containing a container, loaded from a file. I want to attach a new component to the container with EzAPI.
The component was added with the EzAPI, now I only have to retrieve the name ...
Score of 2
1 answer
819 views
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 ...