i have posted the ActiveX script for the DTS package i hope you can solve it.

Thanks

'**********************************************************************

' Visual Basic Transformation Script

' Copy each source column to the

' destination column

'***********************************************************************

Function Main()

on error resume next

dim line1

dim readcounter

readcounter=0

DTSDestination("custno") = DTSGlobalVariables("cid").Value

DTSDestination("club") = DTSSource("club")

DTSDestination("mail") = DTSSource("mail")

DTSDestination("fname")...

[thank you for replying. but yes i did check all the transformations and tested the DTS package and it doesnt give me an error but, still it does not transfer...

[Can anyone please answer my question]

i tried to save a DTS package in the repository, accidently it got saved only under metadata and i can only view it using the...

thank you, i am going for creating a package in DTS but the only thing that worries me is data integrity, how do i insert records into 3 tables at...