Hi,
Could you please tell me how to add SCRIPT and LOOK UP component to a data flow using C# Also, is there any artilces/site which gives information about the SSIS programming
Regards,
Gopi
Adding SCRIPT and LOOK UP components using C#
Hot Topic
- check what table are lock by application
- Can NOT login in to SQL2005 with SQl Server Mangement Tool
- SQL Server 6.5 - 2000 Upgrade Tips
- MDX queries from Reporting Services
- ForceExecutionResult is ignored by parent
- Can I use SQL Server Management Studio Express to work with SQL Server Everywhere?
- Grouping in List Control
- Remove Numbers
- Cannot find either column "dbo" or the user-defined function or aggregate "dbo.FN_NIVELCOMPETENCIACARGO", or the name is ambiguo
- Proxy Account
SQL Server
- Writeback
- Bulk Insert won't compile if file doesn't exist, no Try Catch either
- Olap Restoration(Simple Question)
- How to extend existing FTP task ?
- nvarchar(max) to Excel Destination error
- How do I insert data from a flat file or .csv file into an existing SQL database???
- reports in rich client
- Cannot Load SQLSpars.dll
- Database create error due to folder access right.
- SQL Server 2005 Upgrade Advisor not detecting known issues.
Adding SCRIPT and LOOK UP components using C#
allen_xu
Ripley61
Douglas,
The bol link gives information about the basic components and tasks. I'm looking for more information related to the components like LOOK UP transerformation, SCRIPT componenet, Conditional Branching component. Could you please let me if you know where we get reference material
Regards,
Gopi
JV
Adding components programatically is pretty much the same for any component - you just need to be aware of specific properties for each, and they are described in BOL.
The exception is the script component which relies on the VSA project infrastructure - we are looking to improve this capability in the future. Having said that, if you can programatically create a package, you certainly have the skills needed to write a custom component rather than using a script component - custom components are more flexible and easier to reuse, especially programatically.
Donald