HI mark in the data flow task instead of connecting the same OLE DB Source and connecting to the flat file and OLD DB Destination take two OLE DB Source...

Hi instead of selecting the table or view in the DATA ACCESS MODE of OLE DB Source Editor u can use SQL COMMAND from the drop down and give the...

arr = Split(DTSSource("vchContactKey"),"~",3)

DTSGlobalVariables("WINCoCd").value =arr(0)

DTSDestination("CNTCT_SEQ_NUM) = arr(1) & arr(2)

Then in the derived column task of SSIS the derived column function will be

arr_0 = SUBSTRING("vchContactKey",0,3)

arr_1= SUBSTRING("vchContactKey",1,3)

arr_2= SUBSTRING("vchContactKey",2,3)

So now can i go ahead...

Hi in the ActiveX script component the script is as follows

arr = Split(DTSSource("vchContactKey"),"~",3)

DTSGlobalVariables("WINCoCd").value =arr(0)

DTSDestination("CNTCT_SEQ_NUM) = arr(1) & arr(2)

Then in the derived column task of SSIS the derived column function will...

Hi thanx for your reply. What function should i use in the derived column...Is substring function same as the split function?

Hi VG,

I've the following script in the activeX transformation mapping of the data driven query task of one of...