We are trying to run an AIE job and get data from a CSV file into CMDB. In the CSV file we have a column named "Warranty Expiry Date" and we want to change date format and thus want to use following function.
targetsql | select CONVERT(DATETIME, '$Warranty Expiry Date$', 103) Problem is AIE does not recognize the variable $Warranty Expiry Date$. We removed the SPACE character from it and it worked fine. Of course, we can use this solution, but just wanted to know if there is any way by which AIE can understand variable names with SPACE characters in them? regards, Yogesh _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
