List all "ID" values in a Package

Hot Topic

DatabaseMail setup problems
How do load all raw data in one directory into the database
SQL Server to SDF
Changing collation in SQL 2000
Linked Server
Apply sql2k post sp4 fix 2162 on cluster
Can't Route to another LOCAL Broker Instance
cant connect to server from another machine
weekly schedule
Problems with linked Servers

SQL Server

Semi-additive measures in AS2005 Standard Edition
how to correctly work with two (or more) databases?
Cube installation without VS
SQL Server 2005 - CONTAINS freetext over multiple fields
Spelling error
DTS - Trapping SQL errors
SQL Server upgrade from 7 to 2005
Using custom assembly problem. Help!
High level of login/sec
Restoring database in SQL server 2005 Beta 2

List all "ID" values in a Package

While experimenting I got this message:

[Flat File Source [212]] Error: The "output column "Column 0" (237)" failed because error code 0xC0209084 occurred, and the error row disposition on "output column "Column 0" (237)" specifies failure on error. An error occurred on the specified object of the specified component"

I note under BIDS, Properties tab, that the Flat File is assigned an ID of 212. But is the number (237) and ID or an error value How can I list all "ID's" used in a package

TIA,

Barker

Answer this question

List all "ID" values in a Package

  • Zelalem

    237 is an id. The columns each component works with are all assigned id's as well the component itself. If you go into the advanced editor of the component that failed and click on "input and output properties" you can browse the properties of each column which contain their id's.
  • List all "ID" values in a Package
Answer this question