Thank you so much Bob for the feedback. I have used If EXISTS before and I can see now (after your explaination that it would have been better.

I have never...

Hi Guys thank all of you for responding so quickly (and on a Saturday too (smiel))!

I think I figured it out:

IF (SELECT COUNT(*) FROM Enroll_Dtl WHERE LEN(Card_Num) 16)...

Thank you so much.

Thanx to all of you for all your help, patience and guidance. I have managed to get the query completed.

Thanx again,

Trudye

insert into TRLR (rundate, vendor_name, record_type, file_seq_no, vendor_file_name)

select '20090822','XXX','00','062', 'Todays_First_File.txt' union all

select '20090822','XXX','00','063', 'Todays_second_File.txt' union all

select '20090822','XXX','00','064', 'Todays_Third_File.txt' union all

select '20090822','XXX','00','065', 'Todays_Fourth_File.txt' union...

Thanx Guys, if you need anything else pls let me know.

CREATE TABLE Hdr](

[RunDate] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_E_Hdr_RunDate] DEFAULT (CONVERT([varchar](8),getdate(),(112))),

[Vendor_Name] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[Record_Type] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL...

Good Point about the waste of time, here are the necessary fields

Run_Log

[Rec_Type] [nvarchar](2)

[Hdr_Seq] [numeric](9, 0)

[Vendor_Name] [varchar](20)

[Run_Date] [nvarchar](8)

Hdr

[RunDate] [varchar](8)

[Vendor_Name] [varchar](20)

[Record_Type] [varchar](2)

[File_Sequence_No] [varchar](6)

here are the relevant fields

Dtl]

[RunDate] [varchar](8)

[Vendor_File_Name] [varchar](500)

[Vendor_Name] [varchar](20)

[Tran_Type] [varchar](2)

[Filler8] [varchar](150)

Trlr]

[RunDate] [varchar](8)

[Vendor_Name] [varchar](20)

[Rec_Type] [varchar](2)

[Vendor_ID] [varchar](2)

[Dtl_Count] [numeric](5, 0)

[Vendor_File_Name] [varchar](500)

Trlr_Errors]

[RunDate] [varchar](8)

[Vendor_File_Name]...

Not sure what you mean.

This may not be the smartest question I'll ask in my life time. But here goes:

I have 3 trailers, one trl doesn't have any...

Thanx to everyone for responding. for those who think using a cursor is a horrible idea you point is well taken. However I am a VBA programmer and very new...

oook, I revised the code and it's still reading only the 1st record only now it's reading it over and over and......

Here is what I have:

DECLARE @Run_Date as int

DECLARE @DTL_CNT...

Thanx so much, I solved the problem. My expression in the properties of the Connection for the For Each Loop was not set properly.

Thanx again

Thanx to everyone for chiming in I found out the Variable mapping in the For Each Loop was the culprit (it was missing).

Now I have a truncation problem. I have...

I know what you mean Lynn. The problem is SSIS is not like SQL Code you can't post you code for everyone to see.

Is there something I can tell...

Thanx again SScrazy