What does this Warning Signify ?
The meta data of the colums does not match the metadata of the external columns with which the output columns are associated Output "OLEDB source Output" : "Col1","Col2","Col3" Do you want to replace the metadata of the output columns with the metadata of external columns ? The Package runs fine but in BIDS but in error list at the bottom of BIDS i can see this : The external column "Col1" needs to be updated The external column "Col2" needs to be updated . The external column "Col3" needs to be updated . Only thing changed in the Source Procedure is data type , Does this reflect my package ? Thanks in advance ! Rajkumar Yelugu
November 21st, 2011 7:05am

I asume you have this warnings in a source or destination in your data flow. Your source (eg. file, database) ahs changed your connection manager has been update but your source or destination component in your dataflow has not. To resolve these warnings: - Open the dataflow task - Open te source or destination - If there is a pop up, click yes - close the de propertie window of the source or destination. - warnings are soled. grtz, Ivo
Free Windows Admin Tool Kit Click here and download it now
November 21st, 2011 7:55am

Thanks for your response , My package is scheduled and running fine on a daily basis , It would be great if you can advise if these warnings impact my output in destination ! Thanks .Rajkumar Yelugu
November 22nd, 2011 1:14am

Can some please provide some pointers ? Thanks !Rajkumar Yelugu
Free Windows Admin Tool Kit Click here and download it now
November 23rd, 2011 2:19am

Hi Rajkumar Yelugu, Please refer to the following simlar threads: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/8e3990bf-be08-418e-8c3f-60047cf5fda7/ http://www.sqlservercentral.com/Forums/Topic735740-266-1.aspx#bm978604 If you have any question, please feel free to ask. Thanks, Eileen
November 23rd, 2011 4:39am

Hi Rajkumar Yelugu, Please refer to the following simlar threads: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/8e3990bf-be08-418e-8c3f-60047cf5fda7/ http://www.sqlservercentral.com/Forums/Topic735740-266-1.aspx#bm978604 If you have any question, please feel free to ask. Thanks, Eileen Thanks Eileen , Can you please confirm the output will not effect at the destination end with this warning as per link 2 pasted ?Rajkumar Yelugu
Free Windows Admin Tool Kit Click here and download it now
November 23rd, 2011 4:43am

Hi Rajkumar Yelugu, I am sorry for not making my post clear enough. The output effect of course at the destination end with this warning like: The external column "Col1" needs to be updated. Please refer dan.lorenc's reply in the link: http://www.sqlservercentral.com/Forums/Topic735740-266-1.aspx#bm978604 Thanks, Eileen
December 1st, 2011 4:25am

Hi Rajkumar Yelugu, I am sorry for not making my post clear enough. The output effect of course at the destination end with this warning like: The external column "Col1" needs to be updated. Please refer dan.lorenc's reply in the link: http://www.sqlservercentral.com/Forums/Topic735740-266-1.aspx#bm978604 Thanks, Eileen Thanks !Rajkumar Yelugu
Free Windows Admin Tool Kit Click here and download it now
December 1st, 2011 4:46am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics