TRANFERING DATA....

[korel038]

I am trying to tranform data from ms access to sql server with an odbc...
while most tables are transfered with no problem some others can't....
Some Field's are trying to pass in an upside down posotion...any way i can prevent that....?

 

[JayKusch]

Can you give us an example of "Some Field's are trying to pass in an upside down posotion"

Thanks

J. Kusch

 

[korel038]

'**********************************************************************
' Visual Basic Transformation Script
' Copy each source column to the
' destination column
'************************************************************************

Function Main()
DTSDestination("DhmIstApofMerMelID&quot = DTSSource("DhmIstApofMerMelID&quot
DTSDestination("DhmIstApofID&quot = DTSSource("DhmIstApofID&quot
DTSDestination("DhmIstApofMerMelMerida&quot = DTSSource("DhmIstApofMerMelMerida&quot
DTSDestination("DhmIstApofMerMelMelos&quot = DTSSource("DimMainID&quot
DTSDestination("DimStatus&quot = DTSSource("DhmIstApofMerMelMelos&quot
DTSDestination("DimEponymo&quot = DTSSource("DimStatus&quot
DTSDestination("DimOnoma&quot = DTSSource("DimEponymo&quot
DTSDestination("DimOnomaFather&quot = DTSSource("DimOnoma&quot
DTSDestination("DimOnomaMother&quot = DTSSource("DimOnomaFather&quot
DTSDestination("DimMainID&quot = DTSSource("DimOnomaMother&quot
DTSDestination("DiagrafDescr&quot = DTSSource("DiagrafDescr&quot
DTSDestination("ToposBorn&quot = DTSSource("DimDateDiagraf&quot
DTSDestination("etosborn&quot = DTSSource("DimDateSymban&quot
DTSDestination("DimEponFather&quot = DTSSource("ToposBorn&quot
DTSDestination("DimGenosMother&quot = DTSSource("DateBorn&quot
DTSDestination("DimSxeshID&quot = DTSSource("etosborn&quot
DTSDestination("KtIthag&quot = DTSSource("DimEponFather&quot
DTSDestination("Ithag&quot = DTSSource("DimGenosMother&quot
DTSDestination("DimKtIdiotDim&quot = DTSSource("DimSxeshID&quot
DTSDestination("DimEtosMar&quot = DTSSource("KtIthag&quot
DTSDestination("DimOtaMar&quot = DTSSource("Ithag&quot
DTSDestination("DimBathGamMale&quot = DTSSource("DimKtIdiotDim&quot
DTSDestination("DimBathGamFemale&quot = DTSSource("DimArMar&quot
DTSDestination("DimDateDilGam&quot = DTSSource("DimEtosMar&quot
DTSDestination("DimPraxiGam&quot = DTSSource("DimOtaMar&quot
DTSDestination("DimDateGamPolit&quot = DTSSource("DimBathGamMale&quot
DTSDestination("DimToposGamPolit&quot = DTSSource("DimBathGamFemale&quot
DTSDestination("DimDateGamThrisk&quot = DTSSource("DimDateDilGam&quot
DTSDestination("DimToposGamThrisk&quot = DTSSource("DimPraxiGam&quot
DTSDestination("DimDateGamPolitEtos&quot = DTSSource("DimDateGamPolit&quot
DTSDestination("DimDateGamThriskEtos&quot = DTSSource("DimToposGamPolit&quot
DTSDestination("DimOtaLixBorn&quot = DTSSource("DimDateGamThrisk&quot
DTSDestination("eMerida&quot = DTSSource("DimToposGamThrisk&quot
DTSDestination("DimDateDiagraf&quot = DTSSource("DimDateGamPolitEtos&quot
DTSDestination("DimDateSymban&quot = DTSSource("DimDateGamThriskEtos&quot
DTSDestination("DateBorn&quot = DTSSource("DimOtaLixBorn&quot
DTSDestination("DimArMar&quot = DTSSource("eMerida&quot
DTSDestination("DimBibliarioNo&quot = DTSSource("DimBibliarioNo&quot
Main = DTSTransformStat_OK
End Function

i also posted it by mistake in another thread...oopsss..:0)