bitbucket (2/20/2008)
Not a guru but a thought, since you have the column ID (assuming it is the column with the error) use this column Id as a parameter in a T-SQL statement to select from sys.columns the object_id which (defined as "ID of the object to which this column belongs"), and name (defined as "the name of the column") then using this object_id do a select on sys.objects to return the object name. This should result in the table name and the column name.Refer to BOL sys.objects and sys.columns
Hope this helps
NAAA. Column ID is not the one you are talking about. This is an internal SSIS identifier of the column within a source-destination or transformation task. It is essentially something around 100, then 500 and then it grows.
M$ themselves admitted that this is a missing feature.
I am just wondering (VB/SSIS gurus please help us here) if there is a way to use SSIS API in VB and access the previous task and its fields and then lookup for the name using the provided ID??
If there is no way, then too bad... I will create hundreds SELECT.. with thousands of CASE.. statements to figure the field..
Or maybe I can create a lookup table for it? Which maps sys.columns to the SSIS IDs?//
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM