May 18, 2011 at 9:38 am
hi
I hv package who creates a new archive directory,
so the package is like this
initialize->creates new archive directory (with timestamp)
-> given 2 condition
like findstring("user::find_spec","|",1)==0
findstring("user::find_spec","|",1)!=0
after that there is a archive 1 and 2
can anybody tell me what this condition do
thanks in advance
May 18, 2011 at 10:08 am
daveriya (5/18/2011)
I hv package who creates a new archive directory,so the package is like this
initialize->creates new archive directory (with timestamp)
-> given 2 condition
like findstring("user::find_spec","|",1)==0
findstring("user::find_spec","|",1)!=0
after that there is a archive 1 and 2
can anybody tell me what this condition do
FINDSTRING (SSIS Expression)
http://msdn.microsoft.com/en-us/library/ms141748.aspx
You lost me on the archive 1 and 2 as stated.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 18, 2011 at 1:41 pm
i know this link,just tell me what this 2 condition do
archive 1 is for each loop after the first condition and archive 2 is for loop after the second condition
May 19, 2011 at 12:34 am
daveriya (5/18/2011)
i know this link,just tell me what this 2 condition doarchive 1 is for each loop after the first condition and archive 2 is for loop after the second condition
If you know the link, you probably read the contents and you should know what the FINDSTRING function does.
So it would be easy to see what the condition is checking.
I'll give you a hint: it's looking for the pipe | character.
Another hint: the second condition is the exact opposite of the first one.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply