iamsql1 (2/4/2013)
HIi have an idea. can i use a stored procedure and get it executed in EXECUTE SQL TASK
instead of using ole db destination for inserting , updating data in sql server db. ????
Of course - but then the question becomes 'why bother with SSIS at all?'
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.