An Avanade Blogging Community

Welcome to An Avanade Blogging Community Sign in | Join | Help
in Search

Old School Database Guy

SSIS Error Codes

If you have any experience with SSIS, you have come to realize that the error codes for SSIS are not the same as the error codes for SQL Server.  Personally, I would have preferred the same error code for the same error.  For example, a violation of a unique constraint in SSIS is -1071607685 while the same violation in T-SQL is 2627.

 

SSIS error codes are typically hard to track down, but you can find them at http://msdn.microsoft.com/en-us/library/ms345164.aspx.  

 

Is my curmudgeonly nature showing?

Published Wednesday, June 11, 2008 8:46 AM by Old School Database Guy

Comments

No Comments
Anonymous comments are disabled

About Old School Database Guy

After spending 10 years as a lawyer, Mike discovered his true avocation as a database guy. He has over 10 years experience working with major corporations on database design and integration issues. Mike lives in Colorado where he skis, rides motorcycles and listens to Verdi and Puccini operas in his free time. His personal musings may be found at http://tamethemonkeymind.blogspot.com/.

This Blog

Post Calendar

<June 2008>
SuMoTuWeThFrSa
25262728293031
1234567
891011121314
15161718192021
22232425262728
293012345

Syndication