I suspect it is 2003. This I can find out for sure. I do have some SQL Server knowledge and references.
>> -----Original Message----- > >Not really - although there's a chance that SQL DTS could do this (I _think_ >there's a method for data transformation from text files where you can >specify a masking structure). > >SQL Server 2005 allows for Stored Procedures to be written in many languages >(including, if I remember correctly, JavaScript). You might be more >comfortable doing your RegEx scripting there. > >If you can do everything in SQL Server you can then wrap everything up into >a re-runnable, SQL-schedule-able DTS package. > >(DTS in SQL Server is really powerful but often ignored.) > >You can also use SQL Scripts from the command-line using the OSQL utility. >You can use Windows Scripting Host to do a lot of the work - fetch the data >from the remote server, pull it, Reg-EX into a workable input file, etc. I >did a lot of this recently to pull log files from a AIX server and import >them into a SQL Server. > >Can you modify/adjust the HTML file? Getting a tab/comma separated list >instead would make your task significantly easier. > >Jim Davis ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:233502 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
