whicle loading the ecel to sql server destination getting nulls
this is my out put and input files,in my source is excel contains string+numeric and only numeric while loading the data into sql server destination only numeric values getting null, but i want show that numeric value into destination also
plz help,,,
Regards
Arjun
May 16th, 2012 3:33am
Set IMEX=1 in your connection string.
http://www.connectionstrings.com/excelMCTS, MCITP - Please mark posts as answered where appropriate.
Free Windows Admin Tool Kit Click here and download it now
May 16th, 2012 5:06am
hi,
Thanks
May 16th, 2012 6:33am