1

SSIS on SQL Server 2008 R2

I have inherited an SSIS package that is failing when importing a spreadsheet. The part of the failure is in a data flow that consists of :- * an Excel Source Data Flow Component * a Derived Column Data Flow Component * an OLE DB Destination Data Flow Component

enter image description here

I have added data viewers on the two flows, and these show only 1 row on each. enter image description here

The table that I'm importing into is empty.

I'm not sure what else to look at. Any assistance is appreciated. Thank you.

Improve this question
4
  • 1
    Are you able to run a profiler trace to see the statement being sent to SQL Server? If so, could you post it along with any other queries that are defined in the package? Thanks
    – Mr.Brownstone
    Commented Dec 7, 2015 at 12:22
  • 2
    Does the table have triggers on it?
    – billinkc
    Commented Dec 7, 2015 at 15:32
  • @billinkc it DOES have a trigger on it. - Updating my question.
    – cometbill
    Commented Dec 7, 2015 at 16:45
  • The trigger is doing something dumb relative to what the data indicates ;)
    – billinkc
    Commented Dec 7, 2015 at 19:52

1 Answer 1

Reset to default
1

In my case there was a trigger that trying to update one of the rows. The unfortunate thing was that the query in the trigger returned more than one row in the subquery.

As it turned out for me the trigger was only relevant for one particular supplier (an IF condition in the trigger), also luckily for me, the previous occupant of my position hadn't reviewed this trigger, and it was no longer needed.

Removed the trigger. However in other scenarios I would have had to modify the trigger to return one row only.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.