tag:blogger.com,1999:blog-6855339694180792214.post291650773706638740..comments2024-03-27T04:45:10.518-07:00Comments on Jessica M. Moss: PASS Community Summit 2009Jessica M. Mosshttp://www.blogger.com/profile/12673369096441752530noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-6855339694180792214.post-12826111470788405182011-12-28T05:41:49.223-08:002011-12-28T05:41:49.223-08:00I am using below query in sql command from varaibl...I am using below query in sql command from varaible to fecth the data from two different table.<br /><br />select x.*, y.col1, y.col2 from table1 as x inner join table2 as y on y.[Y ID] = x.XID<br /><br />AS per my businees logic i need use the query as sql command from variable. When i am running the package after the setting DelayValidation to True, I am getting the below errors..Please help me on this..<br /><br />"[OLE source table1]] Warning: The external columns for component "OLE source" (1) are out of synchronization with the data source columns. The external column "col2" (601) needs to be removed from the external columns. The external column "Col1" (598) needs to be removed from the external columns."..<br /><br />[SSIS.Pipeline] Error: "component "OLE source table1 " (1)" failed validation and returned validation status "VS_NEEDSNEWMETADATA".<br /><br />Advanced Thanks!!..balaji hambeerehttps://www.blogger.com/profile/04180809993729190199noreply@blogger.comtag:blogger.com,1999:blog-6855339694180792214.post-25598892049924059432010-02-11T06:35:32.115-08:002010-02-11T06:35:32.115-08:00If you will be willing to share information with m...If you will be willing to share information with me about ssrs.<br /><br />It will be my pleasure<br /><br />Jessica Moss´s eternal slave<br /><br />robertdba@hotmail.comUnknownhttps://www.blogger.com/profile/15277834239271045720noreply@blogger.com