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.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  Dynamic Source and Target for Tranformation

Author  Topic  FedeX Starting Member 5 Posts Posted - 2005-12-19 : 10:05:59 Hi , I am trying to export Info from Tabels in Text files in a dynamic way.... I am using an sample that I found ... but something is not working well.. Dim pakt, task, i Const DTSTransformFlag_AllowLessConversion = 512 Set Paket = DTSGlobalVariables.Parent Set task = paket.Tasks("DTSTask_DTSDataPumpTask_1").CustomTask For i = task.Transformations.Count to 1 step -1 task.Transformations.Remove i Next Set objTransform = task.Transformations.New("DTS.DataPumpTransformCopy") objTransform.Name = "Transformation" objTransform.TransformFlags = DTSTransformFlag_AllowLessConversion task.Transformations.Add objTransform I going to appreciate any help Fedex