thank you very much,

Jian

Here is the script to create table:

CREATE TABLE [dbo].[Test](

[MemberID] [bigint] NULL,

[Performed_Date] [datetime] NULL,

[DateRank] [bigint] NULL

) ON [PRIMARY]

GO

Here is the script to populate the data:

insert into test (MemberID, Performed_Date, DateRank)

values

('168451', '2024-10-21...

my question is more about how to make the web service task to use the customized soap request file.

I am not familiar at c#, can you please be more specific?

Thank you very much for all your help. It works beautifully...

what if that is a column name, e.g.

select sum(saletotal)/NumberofDays

I tried to follow Vbscript but fails:

Public Class ScriptMain

' The execution engine calls this method when the task executes.

' To access the object model, use the Dts object. Connections, variables,...

Did you declare the property for "DirectoryInfo" somewhere in your package?

Thanks,

The script task is more of something that I am looking for. However, I got an error when I am testing it:

Error 30002: Type 'DirectoryInfo' is not defined.

Line...

Thanks.

These are load files of various sort and do not come with date extension.

Q

First of all, thank you very much for your reply.

To answer your question, effective date could start at date, regardless weekend or holiday, and it would be fine if there...

For example:

MemberID Effdat ...

How to specify if the result is >= 1 one path and the result is = 0 another path.

Thanks,

Qjlee

The question is how to program it?

Thanks,

Qjlee

Can you please be more specific?

Thanks,