Do you have the error message????????

it is true that if the package execution is not started then send email task will not work....

@cold coffee:

Thanks for your response.

If you look at the file I have attached you will notice that In some cases the EXPECTEDPAYDAY is actually prior to the DOCDATE. And...

1.From the RM30101 (RM Transaction History Table) select the 6 most recent invoices (DOCNUMBR) based off of the date that they have been paid off (DINVPDOF) for each customer (CUSTNMBR)....

Thanks for response.....i am getting negative values for some and pretty huge year values for some..my query below :

select AVG(DATEDIFF(D,DINVPDOF, DOCDATE)), CUSTNMBR from

(select docnumbr,custnmbr,dinvpdof,curtrxam,

( RANK() over (partition by custnmbr...

Did you try (local) or localhost.

Did you check the protocols for that instance in Sql server configuration manager. Also verify the instance name in configuraion manager. May be SQL Server...

Here you go RM30101 Tables structure:

USE [TWO]

GO

/****** Object: Table [dbo].[RM30101] Script Date: 05/05/2011 17:12:07 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING OFF

GO

CREATE TABLE [dbo].[RM30101](

[CUSTNMBR] [char](15) NOT NULL,

[CPRCSTNM]...