Script Component doesnt change the GUID on copying
I have a script component which has some logic I want to reuse on every data flow task within the same package. Each time i copy and paste that component onto a different task, I get an error saying it cannot create script component. When I look at the
GUIDs for each of them, they are the same. Anyone has any idea how to resolve this?
December 23rd, 2010 11:46am
There is no way to resolve it other than manually setting the GUID. I've complained long and hard about this.http://sqlblog.com/blogs/jamie_thomson/ |
@jamiet |
About me
Free Windows Admin Tool Kit Click here and download it now
December 23rd, 2010 12:12pm
Maybe BIDS Helper can help. (http://bidshelper.codeplex.com/)
It has a menu option to Reset GUIDs. If you copied the Script Component to the clipboard, then did a Rest GUID operation, the original MAY then have a different GUID than the one on the Clipboard that can then be pasted.
It's a long-shot, I know.
Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.
December 23rd, 2010 12:24pm
I did try the BIDS Helper already but it didnt help. So, is there currently no way to copy the Script component?
Free Windows Admin Tool Kit Click here and download it now
December 23rd, 2010 12:43pm
The GUID was not the culprit here. Once I copied the script component, the subsequent components had some warning in the code which got ignored. I was trying to write some string to a Ntext field. Once I changed the nTExt to Unicode string, everything started
to work.
This may come in handy for someone.
December 23rd, 2010 5:05pm