dbTalk Databases Forums  

Re: Configuring Transformation Thru Code

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.dts Re: Configuring Transformation Thru Code

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Re: Configuring Transformation Thru Code in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Configuring Transformation Thru Code - 07-11-2003 , 09:38 AM





The best way I know of to explain exactly what you need to do is this

Build a sample package in Designer.
Do Save As | Visual Basic File

Open the file up in Notepad/wordpad/whatever. It will detail how to build a
package from scratch for you. You could even adapt it to meet your exact
needs

--


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Shaun C Farrugia" <farrugias (AT) dteenergy (DOT) com> wrote

Quote:
I'm configuring a transformation (TransformCopy) through vb code that
will tie columns from an Oracle table to columns in a sql table. I am
defining one transformation with multiple source/dest columns. It's a
one to one tie.

I set the ordinal of OracleCol = to the ordinal of the SQLCol in order
to tie them together. I then add the transformation then save the
package. After the save, I go to DTS designer and go to view the
xFormation but it says it's in valid. When i look at it through
Disconnected Edit i see the source column list and dest column list with
the proper ordianl. I do not set size or type on the source/destination
columns - is this required? Does anyone know what oracle types match
with the values SQL expects in the .type property of the column. AM i
missing anything. I'm pretty much just using .AddColumn "Name" to add
the columns to the Destination/SourceColumnList of the transformation.
These Destination and source columns exist in the
Destination/SourceTable property of the Task - this is also set at
runtime.


--
Shaun Farrugia o DTE Energy Trading
Sr Programmer/Analyst
desk o 734-887-2148 oo email o farrugias (AT) dteenergy (DOT) com



Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top