Thanks........

This is what I did.......

,.........................

..................................

.................................,

CASE

WHEN cd.Description = 'Doral'THEN 'B'

WHEN cd.Description = 'Davis'THEN 'B'

WHEN [ADJ_IND]= '7'THEN 'A'

WHEN [ADJ_IND]= '8'THEN 'A'

ELSE 'N'END...

Thanks,

But how would I Do the join this time? I know I have to have another join this time because the search creteria is different...........

use a data conversion transform inbetwwen source and destination.

Make sure ur record count is integer variable.

Inside another dtaflow drag script component. when its ask for something, choose Source. in the input and output tab add a column. in...

SOrry, But from where I see is IMPOSSIBLE. "+" sign "E" char and "."

If I am not wrong, You are trying to get A record count that you write to a flat file and write that cound to another file.

simply, create a variable...

hey Jack Ur Query gave me this result sets......there is no total on the last columns........results are random........

VEND_ID RECEIVED...

I modified ur query to look like this

SELECT

P.VEND_ID,

CAST(P.RCVD_FR_EDI_TS as Char(12)) as [RECEIVED...

USERS...........

After Alteratiosn these are the errors.....

Msg 8120, Level 16, State 1, Line 1

Column 'PROV.RCVD_FR_EDI_TS' is invalid in the select list because it is not contained in either an aggregate function...

Thanks Jack. I don't believe they will be ready for SSRS.

What I am gonna do is put the result set into a variable in SSIS and send email to users...

I am using T-SQL.

This will be a part of daily job through SSIS. I have to output the query results set to file and then send file to Users.......

Hey I went through all....Couldn't figure out................ALl this talks about Unzipping the file. In my case I need to ZIp it..........ans then send it through FTP.

SO in my case .........I...

Thanks Mahesha, THis one works......I tired it before as one of my collegue suggested.

Also When I remove config file from package configurations, the error goes away.........

ALso, When I remove config...

One thing I found that when I removed COnfig file from the package configuration, the error goes away. so I think it has to do with Config file and specially...