Hi paul

To get your desired result You need to change in your previous query

.It should be

select a.BL_ID,a.POL_COUNTRY_CD,a.POD_COUNTRY_CD, b.REGION_TRADE as REGION_TRADE_POLCOUNTRYCD,c.REGION_TRADE as REGION_TRADE_PODCOUNTRYCD,

Tradelane=

case ltrim(rtrim(substring(a.POL_COUNTRY_CD,1,2) ))

when 'GB' then

...

Hi Abhas

Yes,You can copy only those files from source to destination which are 90 days old only.

Do the same as i said, the only change you need in your...

Hi Paul

I read ur topic,what i understand is

You have to assign value to a colum DHL_TEMP.TRADELANE for each NCV_BL_DHL_TEMP.BL_ID

and the condition is

TRADELANE-----------------POL_COUNTRY_CD----------------POD_COUNTRY_CD

Euro NC/UK to ASPA---------Starts with GB-------------Any country where...

Hi Sasi

In SSIS if the datetime field is null,it will take a default date value

So in precedence constraint u need to compare the date value with null or blanck or...

Hi Praveena

Do you know the use of propagate variable in SSIS?

If we are using the event handler for eg.OnError for ExecutePackageTask1 and error Occures in ExecutePackageTask1 then the OnError...

Hi abhas

Write the variable name in script task as User::daysback instead of user::daysback and then try

Incase any query let me know

Rashmi

Hi abhas

I think you have declared a variable user:varFilePath in your script task as read only,change it to User:varFilePath.

I have a sample project,if you want I'll send it to...

Hi abhas

To delete the files from Destination Folder

U need to follow the following steps

Create one variable varFilePath

Use a for each loop container,which iterate through each file in Destination Folder and...