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

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

Other recent topics Other recent topics