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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-05-17 : 09:47:37
|
| Jeff writes "Hello,I am using a DTS package to copy data to a SQL Server database from a non-SQL-Server datbase (specifically, I am pulling data from an Investran 5.2 Report Wizard report using Investran's proprietary OLEDB Provider). Almost everything works fine, however it won't allow me to use Copy Column for the data transformation tasks - I ended up having to use an ActiveX script.The only problem is, the ActiveX script is copying the ANSI padding as well as the data, and no combination of Trim, RTrim or other functions seems to get rid of it. Here is the ActiveX code for one transformation step (they are all similar):'**********************************************************************' Visual Basic Transformation Script'************************************************************************' Copy each source column to the destination columnFunction Main() DTSDestination("lecategory") = Trim( DTSSource("ClientID") ) Main = DTSTransformStat_OKEnd FunctionThe ClientID table in both the source and destination tables is defined as varchar(15), and I set ANSI_PADDING to OFF before creating the destination table. Any insight would be much appreciated!" |
|
|
|
|
|
ANSI Padding and ActiveX