Class and Sequence Diagrams describing SSIS framework (for Custom Components)?

Hi,

Can anyone tell me where I might find the Class and Sequence Diagrams for the SSIS framework (for Custom Components)?

I've just started trying to create some Custom Transform Components and

I'm really struggling to get my head around the component lifecycle

(i.e what methods are called when, with what arguments, and why) with

just the BOL documentation to guide me.

Thanks in advance,

Lawrie

Take a look here... http://www.microsoft.com/downloads/details.aspx?familyid=1c2a7dd2-3ec3-4641-9407-a5a337bea7d3&displaylang=en

The SSIS book by wrox has a few chapters dedicated to creating Source, Destinations, and Transformation components.

Checking which tables were modified by a program?

Is it possible to know what tables were modified when running an application
?
I'm working on a program that has several different components, but I'm only
testing one. I would like to see what tables were affected by this one
component (either by updating or inserting data to a table or several tables
).
Thanks.You can use SQL Server Profiler to show all the commands sent to the
database. I would filter the commands at least down to a specific user if
you are running profiler on a multi user system.
"VMI" wrote:

> Is it possible to know what tables were modified when running an applicati
on?
> I'm working on a program that has several different components, but I'm on
ly
> testing one. I would like to see what tables were affected by this one
> component (either by updating or inserting data to a table or several tabl
es).
> Thanks.|||You can also filter by applicationname in profiler. Its part of the selecte4
d
data in the default trace template.
--
-Omnibuzz (The SQL GC)
http://omnibuzz-sql.blogspot.com/
"VMI" wrote:

> Is it possible to know what tables were modified when running an applicati
on?
> I'm working on a program that has several different components, but I'm on
ly
> testing one. I would like to see what tables were affected by this one
> component (either by updating or inserting data to a table or several tabl
es).
> Thanks.