Skip to content
November 10, 2009 / windperson

詭異的SQL Server Integration Service的Script Task

  1. Web Service不能在SSIS 2008的Script Task打開來的VSTA IDE裡面直接叫用,加入Web Reference之後,第一次開OK,第二次打開就自動消失了~
    解法:用.net的工具程式建立一個Proxy class來呼叫Web Service(請參考這個),不過這個Proxy class也得每個專案自己新建,不能用加入Reference的方法,不然第二次也是會掉。
  2. 自訂的Class不能用加入Reference或是Add Existing Item的方式加入到Script Task的script專案裡。
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: