Skip to content
September 30, 2009 / windperson

SSIS 真是個Friendly的白痴東西-_-

Script Component被copy到別的地方時(包括包含它的Data Flow Task被copy到別的地方之情形),會跑出類似下面的錯誤:

Error    1    Validation error The_Script_Component_Name: Microsoft.SqlServer.Dts.Pipeline.CannotCreateUserComponentException: Cannot create user component class. Make sure there is one class marked with SSISScriptComponentEntryPointAttribute in your script.     at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.CreateUserComponent()

起初認為可能是類似ID重複或是欄位對應錯誤的問題,後來發現把該Script Component的Script Code編輯介面(VSA IDE)打開,對包含Script Code的Project按右鍵選Rebuild Project後把VSA IDE關掉再按OK把Script Component的選項設定視窗關掉就好了。-_-

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: