Hey,
In DTS it is possible to use ActveX script to identify transformation for every row
such as (for example) splitting, replacing characters and so on.
I have script(very complicated and written in VB) and I'd like to use it
in Data Flow Task. What should I use and how
Thanks.
Transformation in Data Flow Task
Hot Topic
- Time Dimension - Attribute Hierarchy
- [OLE DB] how can i use IRowChange::Insert() to insert data ?
- Server: Msg 107 - The column prefix xx does not match with a table name or alias name used in the query
- Use an In-Memory recordset as an input
- Reference to preceeding component from custom dataflow transformation component
- JOIN problem with time involved
- Web ReportViewer customize Export options?
- Analysis Services end-user frontend
- Using the same connection in multiple threads -> native exception
- Why... is it so difficult to schedule a job in 2005?
SQL Server
- Service Pack 1 Database Services Installation Failure
- Uninstall Microsoft SQL 2005 CTP
- IS_Member
- SQL Server Agent Jobs
- CLR SP to Transform Xml (SecurityException)
- Adding Subreport Total to Main Report Total
- How to parse field
- Numerous (every 10 minutes) Event log entries
- how to sum a column depending of another colum into different vars?
- cubes error
Transformation in Data Flow Task
pitatwork
It doesn't really work that way any more. You need to add input columns to be used, and new output columns using the Script Task editor, before opening the script environment.
I think this section in BOL explains it well : "Creating a Synchronous Transformation with the Script Component," but let us know if it does not help!
Unistoner
In SSIS you should use the Script component. This uses VisualBasic.net rather than ActiveX script, but you should be able to convert fairly easily.
Donald
zfjaj
t4urean
There is one thing. I'm not sure what namespace I have to include with Imports
keyword, in order to get access to source and destination fields (columns) in the transformation.