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