Processing text to a column of TEXT data type
-
Folks:
Today, we use a VB6 app to parse, process and load a 650MB ASCII text file to a MSSQL Server table. One of the columns the app processes targets a column in the table of the data type TEXT.
I want to eliminate the VB6 app and use DTS to process the orginial file. I have no experience processing data to a column of data type TEXT. I'm hoping that you will be able to provide me with some gotchas, headsup or other information that will help me implement the process.
Thanks in advance.
-
DTS is the way to go and it is very powerful. There is an excellent book called SQL Server 2000 DTS(Wrox) with lots of examples and code, and @850 pages of information.
As for DTS itself, like many apps, building the Transformations requires the biggest effort.
Dates like to load into DateTime fields with both Date & Time components, this is manageable within the transformation properties where you can tell the system which source fields map to which destinations, and any creative/corrective masking can be applied. Since DTS also supports Active X (if necessary since it is generally performance challenged...) you can parse and restructure the data almost any imaginable way.
The best thing to do - jump in - then come back and ask some specific questions. I've been blessed with some very helpful folks on this site and I'm sure you will be too.
There is one website specifically for DTS called, oddly enough: http://www.sqldts.com/
hth
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply