Database

CREATE FUNCTION [dbo].[FN_STRINGTOTABLE](@P_STRING VARCHAR(8000), @P_DELIMITER CHAR(1))        
	RETURNS @P_TEMPTABLE TABLE 
	(ITEMS VARCHAR(8000))        
AS        
BEGIN        
    DECLARE @V_IDX INT        
    DECLARE @V_SLICE VARCHAR(8000)        
       
    SELECT @V_IDX = 1        
        IF LEN(@P_STRING)<1 OR @P_STRING IS NULL  RETURN        
       
    WHILE @V_IDX != 0        
    BEGIN        
        SET @V_IDX = CHARINDEX(@P_DELIMITER,@P_STRING)        
        IF @V_IDX	!=0        
            SET @V_SLICE = LEFT(@P_STRING,@V_IDX - 1)        
        ELSE        
            SET @V_SLICE = @P_STRING        
           
        IF(LEN(@V_SLICE)>0)   
            INSERT INTO @P_TEMPTABLE(ITEMS) VALUES(@V_SLICE)        
  
        SET @P_STRING = RIGHT(@P_STRING,LEN(@P_STRING) - @V_IDX)        
        IF LEN(@P_STRING) = 0 BREAK        
    END    
RETURN        
END

Hulicat wrote:

How do I generate the GUIDS (unique identifers) from a DTSX package?