0

I'm struggling a lot with an SSIS package I’m trying to execute. I have a OLE DB SOURCE which is populated using a SQL Command, and it was working just fine, the preview works fine.

When I try to add a new column in the SELECT query, which is of type uniqueidentifier, then I have this error message:

Value does not fall within the range in SSIS package

I am using a OLE DB SOURCE and an OLE DB DESTINATION. I'm using SQL Server, and the OLE DB SOURCE is the one failing with this error:

Outputs[OLE DB Source Output].Columns[LegalAddressCode] on the non-error output has no corresponding output column on the error output.

Oz Magician
  • 53
  • 1
  • 8
  • Can you describe the data flow that you have set up? What components are you using, and which ones are failing? – AHiggins Aug 18 '15 at 13:50
  • @AHiggins i am using a OLE DB SOURCE and an OLE DB DESTINATION, i'm using SQL Server, and the OLE DB SOURCE is the one failing – Oz Magician Aug 18 '15 at 13:54
  • With this error: Outputs[OLE DB Source Output].Columns[LegalAddressCode] on the non-error output has no corresponding output column on the error output. – Oz Magician Aug 18 '15 at 13:55
  • But i do have a corresponding output – Oz Magician Aug 18 '15 at 13:55
  • Have you tried deleting and recreating the OLE DB SOURCE component? – AHiggins Aug 18 '15 at 13:57
  • @AHiggins yes yes i did, several times, when i remove this column i add, it all works fine, i don't understand why... – Oz Magician Aug 18 '15 at 13:58
  • Have you checked the answer [here](http://stackoverflow.com/questions/23513691/how-to-handle-unique-identifier-values-during-ssis-import)? – AHiggins Aug 18 '15 at 14:04
  • @AHiggins, yes, but it's not my case, this is very frustrating – Oz Magician Aug 18 '15 at 14:11
  • Can you post the full text of your SELECT statement (before & after)? – AHiggins Aug 18 '15 at 14:13
  • @AHiggins, done, the difference is betweeb asterisks ** ** – Oz Magician Aug 18 '15 at 14:18
  • Add a new data flow, call it "Test". Add an OLE DB Source component. Use the following query `SELECT le.AddressCode AS LegalAddressCode FROM ALB_BR_LegalEntity AS le` Add a Derived Column Task. Right click in the background and select Execute Task. Does it run to completion or does it generate the error? – billinkc Aug 18 '15 at 17:27
  • @billinkc i did this and no error, it worked fine.. – Oz Magician Aug 19 '15 at 09:46
  • By virtue of you being able to add that column into an empty data flow, we can conclude the error is not with the data source. You can replace the single column select in the test data flow with your full query and it will work, right? Hit control alt O in the ssis editor. This brings up the output window, assuming default key mappings. Rerun your falling data flow task and there should be 3 to 5 lines of output that start with ERROR. – billinkc Aug 19 '15 at 11:51
  • see http://stackoverflow.com/questions/1493090/how-to-fix-ssis-value-does-not-fall-within-expected-range/38445843#38445843 That might help – Marcus Belz Jul 19 '16 at 09:00

1 Answers1

0

Your parameters are now misaligned. You are now trying to insert a GUID, 16 bytes long, into a variable that is smaller. Check the mapping in the OLE task.

benjamin moskovits
  • 5,261
  • 1
  • 12
  • 22