How to change encoding in Visual Basic Transformation Script?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: marcin@xxxxxxxxxxxx
Date: 24 Oct 2005 11:12:36 -0700

Hi.

I am importing data from a Unix database to a SQL Server Database and I
would like to change text encoding (from latin2 to utf8 or cp1250) in
the transformation script. Is it possible to achieve w/o any external
tools - just SQL Server Enterprise Manager and editing the
transformation script?

The default transformation script is very simple:

Function Main()
DTSDestination("field1") = DTSSource("field1")
DTSDestination("field2") = DTSSource("field2")
(...)
Main = DTSTransformStat_OK
End Function

Unfortunately I found no way of changing the encoding. I tried to
google through VB tutorials but I found only System.Text.Encoding
samples in VB.NET which is probably out of the scope here.

Marcin

.

Prev by Date: RE: SQL query to do a Http Post record by record
Next by Date: Re: Microsoft OLE DB Provider for ODBC Drivers error
Previous by thread: RE: SQL query to do a Http Post record by record
Next by thread: ODBC Error with Sybase from Win2K Server (but works from WinXP!)
Index(es):
- Date
- Thread

Relevant Pages

Re: SQL server question
... Microsoft is deprecating it even for new development, ... An Access project is an Access file that provides a direct, ... You can connect an Access project to a remote SQL Server ... a local SQL Server database, or a local installation of the SQL Server ...
(comp.databases.ms-access)
Exactly How to Use Disconnected Recordsets in VB / SQL Server Application
... Front-end is VB 6.0, back-end is SQL Server 2000 (actually, MSDE since ... underlying SQL Server database w/the assumption that the user *might* ... the local disconnected recordset on the user's machine would seem to ... time to update each and every record as each user scrolls through the ...
(microsoft.public.vb.database)
Re: DataSet.GetChanges() in RowChanged(DataRowAction.Add)
... if the way synchronization needs to be handled changes in the ... > data stored in an SQL Server database. ... > GetChanges() call, but I feel that this workaround is not my best choice. ...
(microsoft.public.dotnet.framework.adonet)
VBA Microsoft Access and SQL Server
... I am currently working on a project with Power Point. ... into a Microsoft SQL Server database. ... information from the Microsoft SQL Server database and re-populate a Power ...
(microsoft.public.office.developer.vba)
Re: curious problem in production
... thank for the lesson on unique keys, but I suggest you read the question ... I am getting an exception from sql server ... >> trying to insert into the same sql server database. ...
(microsoft.public.sqlserver.server)