I have a text file which has records with blanks in a particular column. When I try to import these records into a decimal field I get an error. I would like to replace these blank fields with a 0 when they are imported. Here is the ActiveX script I'm currently using. The error I get when the import reaches such a record is "Transformation encountered an invalid data value for destination column."
DTSDestination("FrBCPM") = SourceOr0("Col098")
Main = DTSTransformStat_OK
if IsNull(DTSSource(Col098)) then
SourceOr0 = 0
SourceOr0 = DTSSource(Col098)
To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.
I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb. Luckily, there is a free version SQL Express, but does …