I need some help, I am new to Microsoft SQL Server 2005 Integration
Services and I am having some problems running Reporting Services
ExecutionLog Package in Integration Services. After setting up and
running the package, I received this warning message : "Truncation may
occur due to inserting data from data flow column 'InstanceName' with a
length of 38 to database column 'InstanceName' with a length of 32". I
have modified the column length for 'InstanceName' from 32 to 38 in the
affected table but I am still receiving this warning message : "The
external metadata column collection is out of synchronization with the
data source columns. The column 'InstanceName' needs to be updated in
the external metadata column collection"

How do I update column 'InstanceName' in the external metadata column
collection?

Where do I find the package steps logs (sysdtspackagelog or
sysdtssteplog) when running the package as a job or manually.

Hello michael.oseni (AT) aleagroup (DOT) com,


Ok So I do this one of two ways.

I right click on the destination adapter | Show Advanced Editor and I hit
the refresh button.
OR
I undo the path to the destination adapter , recreate the destination adpater
and redraw the path.




Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com