SQL Server - ssis excel data source datatype conversion errors while converting datatype to sql server datatype mapping
hi guys can you help me regarding which datatype is used for ex: DT_WSTR,DT_STR and for percentage , average for data conversion transformation in ssis package while using excel source to sql server destination with help of
data conversion transformation .
1.Excel source
2.Data conversion transformation and
3.OLEDB destination (sql server).
May 21st, 2012 2:55pm
Your question is not clear enough!
Do you want a basic tutorial on how to create data flow with sources/transformations and destinations?
or you have a problem and you want to solve it?
If you have a problem, tell us what exactly your problem is, what is sample of source data, do you receive any error? what is expected results? what did you do in the package?http://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
May 21st, 2012 4:30pm
What issues are you struggling with? Do you get any errors?MCTS, MCITP - Please mark posts as answered where appropriate.
May 22nd, 2012 2:53am