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.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  DTS Transformations

Author  Topic  hmusa Starting Member 36 Posts Posted - 2001-07-11 : 04:36:32 I am currently exporting data to a text file, I need to transform the data, basically trimming the fields so that the text file has no spaces in it. At the moment I am using the export wizard then transforming the data via VBSCRIPT within the wizard. if i need to cahnge the script I have to create the whole thing again because i cant access the script. 'm sure there is a way to export information to a text file and transforming the data so that I can trim and add additional pieces of info to the text file: here is a snippet of the script to transform the info : '********************************************************************** ' Visual Basic Transformation Script ' Copy each source column to the ' destination column '************************************************************************ Function Main() DTSDestination("Barcode") =trim("000") & trim(DTSSource("Barcode"))& "+" & trim("002") DTSDestination("Borrower_type") =trim("001") & trim(DTSSource("Borrower_type")) DTSDestination("College") =trim("003") & trim(DTSSource("College")) & "+" & trim("004") My question is, is there a way I can access the script using the method that i am using at the moment or is there a way I can do this in DTS designer so if I want to change the script I dont have to create the package again. any help would be appreciated. Thanxs