Ssis

如何降級 SSIS 的語句

  • September 30, 2013

以下程式碼段在 SSIS 2012 中工作——派生列塊。

TOKEN(REPLACE(@[User::FileName],".csv",""),"\\",TOKENCOUNT(REPLACE(@[User::FileName],".csv",""),"\\"))

但它在 SSIS 2005 中不起作用。根據錯誤對話框,無法辨識 TOKENCOUNT。有什麼建議可以使用哪些替代方案?

REPLACE(RIGHT(@[User::FileName],FINDSTRING(REVERSE(@[User::FileName]),"\\",1)-1),".csv","")

引用自:https://dba.stackexchange.com/questions/50500