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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics