Now I have a text file likes this (#@# is the column delimiter) :
A01#@##@#NULL#@#Feb 1 2007 12:15:00:000AM
A02#@##@#NULL#@#Feb 2 2007 13:01:00:000AM
A03#@##@#NULL#@#Feb 3 2007 14:02:00:000AM
...
...
My destination SQL 2008 table structure is :
Column name Column type
Name Varchar(20)
Quantity Integer
Remark Varchar(50)
Last_Mod_Time DateTime
My questions :
(1)The 2nd col. of the text file is nothing, the data type of the 2nd table column is Integer, how can I convert : nothing into 0 ?
(2)The 3rd col. of the text file is : NULL, how can I convert it as " nothing so that there is nothing in the table's 3rd column ?
(3)How can I load the 4th column into my table as DateTime ?
Can Import and Export Wizard do this ? Or I need to use Business Integenience Studio ?
Are there any web sites teaching us to do this ?