Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vl
Starting Member
14 Posts |
 Posted - 2008-03-31 : 15:08:29
|
This package will do very simple thing. It will parse the file and load it into table.The format the file will be with fixed position:From position 1 to 18, I need trim all the ending space and map it to a field of base table.1. This is what I have done in the sql 2000 DTS package. How do I do the twist of data mapping on the SSIS?I was using Active-x script in the 2000 DTS package. EmployeeNumber = Trim(DTSSource(1)) EmployeeNumber = Left(EmployeeNumber, Len(EmployeeNumber) - 1)2. At the Contrl Flow tab, I only have "Data Flow Task". I don't see the place I can do expression.  Thanks. |
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2008-03-31 : 16:28:52
|
| Dup?http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=100012 |
 |
|
|
|
|
|
Parse Flat File