Error in DTS sample execution!
Hi,
I need to create a TXT file from DTS (SQL Server 7.0) with an Active Script Task. I tried it with a sample of DTS Designer Help (file system operations). There are some machines who run the sample with no problem, and others (with WIN95 and NT40 )with the next...
A simple method, if there isn't many values, is define a formula field for column's values. Example :
formula1 : Column1 = if {datafield} = "Jones1"} then datafield_value else ""
formula2 : Column2 = if {datafield} = "Jones2"} then datafield_value else ""...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.