Groups | Blog | Home
all groups > sql server dts > february 2006 >

sql server dts : Running Reporting Services ExecutionLog DTS Package in SQL 2005


michael.oseni NO[at]SPAM aleagroup.com
2/21/2006 3:45:50 AM
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.
Allan Mitchell
2/21/2006 4:46:59 PM
Hello michael.oseni@aleagroup.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

[quoted text, click to view]

AddThis Social Bookmark Button