75783

SSIS documentation Reference

Question:

Where is the reference documentation for SSIS Script components? For example, Script Components inherit from a class called UserComponent and the overridden function has a local variable of type: input0buffer. I am struggling to find documentation that explains what these types are. I am new to SSIS.

I realise that SSIS packages are created in BIDS.

The Script Components I am using are written using VB.NET. Is SSIS Script Components an extension of VB.NET?

<strong>Update</strong> I now realise that the UserComponent class is generated at runtime as explained here: <a href="http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.dts.pipeline.scriptcomponent" rel="nofollow">http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.dts.pipeline.scriptcomponent</a>. I still don't understand hpw to find the functions that it implements e.g. Input0_ProcessInputRow.

Answer1:

Most of what you need to develop script components and tasks appears here: <a href="http://msdn.microsoft.com/en-us/library/ms136025%28v=sql.100%29" rel="nofollow">Developer's Guide (Integration Services)</a>

Recommend

  • Core Data vs SQLite [closed]
  • Python timer script doesn't run when set to long periods later
  • Retrieve Windows Update history using WUAPILib from a remote machine
  • R mlogit on my data giving error 'system is computationally singular?
  • Transforming multiindex to row-wise multi-dimensional NumPy array.
  • Finding an index in range of values between 0-100 in Python
  • Querying multiple tables
  • Storing a copy of a document embedded in another document in MongoDB via Mongoose
  • Msvcr71.dll Msvcp71.dll missing
  • Access the state of control in Winforms from another application
  • Change device language on Android 6.0 (Android M)
  • How to log in to an HTTPS website with Jsoup?
  • JSR-330 support in Picocontainer : @Inject … @Named(\"xxx)
  • Cast between interfaces whose interface signatures are same
  • Debugging VB6 Code From Visual Studio 2010
  • how does System.Web.HttpRequest::PathInfo work?
  • Insert new calendar with SyncAdapter- Calendar API Android
  • Ensure fsync did its job
  • Swing - Get new component under mouseReleased
  • Switching to Release Build causes runtime error in Web Reference
  • How to clear text inside text field when radio button is select
  • C++ Partial template specialization - design simplification
  • Javascript simulate pressing enter in input box
  • Launch Runnable Jar from Web Start
  • Why ng-show works with ng-repeat but ng-if doesn't? [duplicate]
  • Azure Cloud Service Web Role web pages do not load
  • Get object from AWS S3 as a stream
  • Cross-Platform Protobuf Serialization
  • Javascript Callbacks with Object constructor
  • Validaiting emails with Net.Mail MailAddress
  • Do I've to free mysql result after storing it?
  • VB.net deserialize, JSON Conversion from type 'Dictionary(Of String,Object)' to type '
  • How can I get HTML syntax highlighting in my editor for CakePHP?
  • How do I configure my settings file to work with unit tests?
  • IndexOutOfRangeException on multidimensional array despite using GetLength check
  • How can I remove ASP.NET Designer.cs files?
  • python draw pie shapes with colour filled
  • Is there any way to bind data to data.frame by some index?
  • Binding checkboxes to object values in AngularJs
  • How can i traverse a binary tree from right to left in java?