This must be very easy. I can't believe I can't figure it out.
I have a fixed length text file I am importing into a SQL table via DTS. This file contains both header and footer records. DTSSource("Col021") = DTSDestination("POST_BAM"); the post_bam field is data type float. I am getting a Data Type mismatch error in translating the footer record. I have attempted a number of things to modify the value being delivered to the destination to strip out the bad values. (In this case I believe they are spaces.)
I've tried the following:
If IsNull(DTSSource("Col021")) Then DTSDestination("POST_BAM") = 0
DTSSource("Col021") = (" ")
Instr(DTSSource("Col021"),Chr(32)) > 0
All of the scripts above return the same error:
Error Discription: Type mismatch: '[string: " "]'
Can anyone point me in the right direction? Thank you.
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.