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:33:08
|
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. I was using Active-x script. How do I do parsing when I map the field to the table? 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. |
|
|
tm
Posting Yak Master
160 Posts |
Posted - 2008-04-01 : 09:58:58
|
| vl .. You double posted. Here it is again.vl .. You can use Derived Column data flow.Basically create a derived column from EmployeeNumber.In the Derived Column Expression you would need something like ..SUBSTRING(EmployeeNumber, 1, LEN(TRIM(EmployeeNumber)) - 1)The above expression have not been tested. |
 |
|
|
|
|
|
Parse flat file