Hi,

If its possible, could you please tell me whether it is possible to use '%' as wild character with the CASE statement as in the code I have mentioned ?...

Hi,

What I am simply trying to do is use a wild character with the CASE statement to achieve this scenario-

I have a table with a list of countries. Here...

Hi Phil,

I am sorry about the incomplete info. Actually I am trying to match the 'All' pattern as in :

'Any country where Trade = EURO MED'- this would mean all...

Hi Rashmi,

Thanks a lot for your earlier solution. It resolved the main issue. If you could please help me with one more thing it would be great.

If you remember from...

Thanks a ton Rashmi...I think you have nailed it...i will test the query and let you know...thanks very much for your patience and the resulting solution...

I am very new to...

Hi GSquared,

Would you be able to help me now with some detailed information below:

I need to assign a value to a column called 'tradelane' for each unique BL_ID in the...

Hi GSquared,

Thanks again for your reply. Actually this project is divided into 2 parts, firstly an SSIS package would need to be created to populate the tables(which are new tables)-...

If you need more information, please let me know....

Thank you for your response, GSquared. Please find the table definitions below:

NCV_BL_DHL_TEMP-

CREATE TABLE [dbo].[NCV_BL_DHL_TEMP]

(

[BL_ID] [decimal](10, 0) NOT NULL,

[BL_NUM] [nvarchar](13) NULL,

[CP_GROUP_CD] [nvarchar](30) NULL,

[POL_COUNTRY_CD] [nvarchar](2) NULL,

[POD_COUNTRY_CD] [nvarchar](2) NULL,

[SAISAN_VESSEL_CD] [nvarchar](6) NULL,

[SAISAN_VOYAGE_CD] [nvarchar](6)...

Issue resolved....the reason was MS Visual J# not installed

Hi,

Thanks again. I have already tried with the method you have advised but still get the same error. I have reached a point where virtually everything has been tried to...

Hello,

Thanks for your reply. Ya the SSIS package which includes the script works perfectly on 32 bit. Also, the machine that I am running the package on has 64 bit...

Hello Leju,

Thanks a lot for your reply. I have confirmed that the references exist in the script task. However, am not sure on how to check if they...

Hello Justin,

Really very sorry for the late reply. Below is the code for unzipping the file I am using in SSIS:

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime

Imports java.io.FileInputStream

Imports java.io.FileOutputStream

Imports java.util.zip.ZipInputStream

Imports java.util.zip.ZipOutputStream

Imports java.util.zip

Imports...

Hi,

I changed the Run64BitRuntime to false, now it shows another error: violation of primary key constraint. The error is below:

[OLE DB Destination [9]] Error: SSIS Error Code DTS_E_OLEDBERROR. An...