harri.reddy (8/28/2012)
from oledb source to multitask to oledbdestionation in data flow task.i am getting this error on OLEDB Destination
As others have already stated, you need to provide more details. What is the error message? What do the tables look like?
What you have asked in here is like taking your car to the mechanic and telling them "it's broken" and walking away. The mechanic is about as likely to work on your car as anybody here is going to work on your issue.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/