Ssis
如何降級 SSIS 的語句
以下程式碼段在 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","")