Using SSIS data flow rows in external DLL

In many of our SSIS data flows across packages we call into a service of some kind from a script transform. I would like to promote reuse by eliminating web service related code and object creation/conversion code from the script tasks, and put it into a small set of reusable libraries.

I would like to pass the row data to the common methods, without having 20, 30, 40 etc. method parameters, and would like to hear from the community how to effectively pass row(s) from SSIS to external libraries.

-------------Problems Reply------------

If you go to the tools choose toolbox items, you can add specific DLLs to the toolbox in BIDS. Then you can use them like any other task. All of your developers would have to have the components you want to use added to their BIDS. We have done this with several locally created components and a few we got from other sources. Not knowing exactly what things you want to add, I can't guarantee you can add them, but it's what I woudl try first.

Category:c# Views:1 Time:2011-08-09
Tags: ssis

Related post

  • SSIS Data Flow overflowing on dates 2010-12-02

    I have a FoxPro data source, and the destination is SQL Server 2008. On the FoxPro side, I have a column with the Date data type. That's a width of 8, min value is 0001-01-01 and max is 9999-12-31. On the SQL Server side, I have a datetime. Also a wi

  • Remove duplicates in SSIS Data Flow 2011-06-21

    I am working on an SSIS data flow task. The source table is from old database which is denormalized. The destination table is normalized. SSIS fails because the data transfer is not possible because of duplicates (duplicates in primary key column). I

  • Dynamically create table in SSIS data flow 2011-08-29

    How can I have an SSIS data flow create a table that doesn't exist? Every time I try to run the package, it gives me an error saying that the destination table doesn't exist. --------------Solutions------------- Since you want your package to create

  • Identity Insert missing in all relevant SSIS Data Flow Transformation objects? 2009-05-12

    Am I the only person on this particular planet that is inconvenienced by the lack of Identity Insert, missing in all relevant SSIS Data Flow Transformation objects? Only the Bulk Insert Task supports Identity Insert, what about elsewhere in SSIS? Is

  • How can I better visualize the path that a value takes through an SSIS Data Flow and the operations that are performed upon it? 2010-02-12

    I find that I regularly need to track a value through an SSIS Data Flow. The process that I use to do this is manual and time consuming. Are there any techniques or tools that I can use to reduce the effort (and potential for error)? What I really ne

  • SSIS data flow Lookup fails but destination component still wrote rows 2011-06-27

    I'm using SSIS on SQL Server 2008. I have a data flow with a lookup component with the no matching entries option specified to "Fail component". I'm looking at the log of a previous execution of the package and I can see the following error message f

  • How to track status of rows successfully processed or failed in SSIS data flow task? 2011-07-19

    I have a very simple Data flow task reading data fromn a FF and inserting the data in a table. At the same time I would like to write in an Audit table, how many rows have been inserted, the created date,... How can I do that easily? Thanks in advanc

  • SSIS Data Flow changes order of records 2009-05-13

    I thought I asked a similar question in, but this is slightly different. I am getting data from another SQL-Server 2005 database, using SSIS, and a s

  • SSIS Data Flow Task Excel Source 2010-04-22

    I have a data flow task set up in SSIS. The source is from an Excel source not an SQL DB. The problem i seem to get is that, the package is importing empty rows. My data has data in 555200 rows, but however when importing the SSIS package imports ove

  • How to formulate conditional expression in SSIS Data Flow tab? 2010-08-21

    I am developing an SSIS 2008 package and I am trying to create a Derived Column transformation. But when I go to the Expression editor and try this expression it gives me alot of errors. I have tried various differentiations of this but all have resu

  • Generating Primary Key with Non-Zero Index (SSIS Data Flow) 2009-08-12

    I've got a data flow task that takes a pair of tables, mashes the relevant data together, and comes out with some results to be put into an indexed table. The indexed table already has data that I'm not getting rid of and for simplicity's sake should

  • SSIS Data Flow Task SQL 2008 2010-04-13

    I am wondering if it is possible to: 1) Develop SSIS Package for Data Flow Task I am aware of how to do this on a local or network SQLServer, However is it possible to create a package that uploads to a "remote" sqlserver, ie one that is not on site

  • How do I get SSIS Data Flow to put '0.00' in a flat file? 2010-05-19

    I have an SSIS package with a Data Flow that takes an ADO.NET data source (just a small table), executes a select * query, and outputs the query results to a flat file (I've also tried just pulling the whole table and not using a SQL select). The pro

  • SSIS Data Flow Conversion of Float to NVarchar importing null values 2011-06-28

    I am trying to import an Excel 2007 spreadsheet into a staging table and I am encountering issues with some of the column types. Some of my columns have a combination of numeric and text values i.e. A column called Customer No can have numeric values

  • Using dynamically named table in SSIS data flow task 2011-10-14

    I'm new to SSIS and am writing a package that includes moving data to a table that is created in a previous Execute SQL Task object. The issue that I'm encountering is that I am unable to create a data flow destination task that uses a dynamic destin

  • How can I use a Check Box List for custom property in a custom SSIS data flow component? 2011-10-31

    I think the title of the question says it all. I am developing a custom data flow component for SSIS. I would like to use a checkbox list that gets it's values from a collection (list, enum,... doesn't really matter) and gives the user the possibilit

  • Error in SSIS Data Flow when using Fast Load 2012-02-29

    When using SSIS to load data from a source table, we have a OLE DB Destination that uses a Data Access Mode of "Table or View - fast load" (which uses a BULK INSERT to do the work). When we try to execute the task, we get a very strange error message

  • Using Multiple Sources in SSIS Data Flow Task 2011-03-29

    For my data flow task I have a OLEDB Source. In the SQL command section of this I have compiled a select query based on tables from two different databases, held on the same instance. Every time I run this it errors, but when I moved the tables to th

  • SSIS: Data Flow stopping after 5000 rows 2010-12-15

    I have an oledb source which i have hooked up to a script component. The Script component is configured to the oledbdestination. There are 70 rows which I am importing to the destination. If i select the top 100 rows then I am able to succussfully im

Copyright (C), All Rights Reserved.

processed in 0.100 (s). 11 q(s)