may be consfusing..sorryabt that.

I have bunch of files and the user has to load a single file which he wants. so that user has to select the file name and pass it...

I am sure I dont have any duplicates, weired thing is that when I split the file into 2 and ran my job it was gud. so I concluded that...

my windows user id..under my name.

still am getting the result with coma seperated, am not getting in diff columns

but when i use sustem_user am getting as SA, how can i get my user name.

When I use system_user I get sa id but i need to get windows id.

so do u mean I cant display the result in 2 columns by using print, only...

PW..

when you say validation sql task, is it a store proc we need to write to validate.

I am able to do the same as you said using temp table. The only thing is how do i need to check for errors and notify the users regarding...

what do u mean by take the other columns out.

I want to display all fields with UNIQUE SSN.

though I am using DISTINCT for SSN still am getting repeated

I dont mind which SSN shud be used, what i need is just UNIQUE SSN's thats all.

123111111        ADGSDGDSGDSDG      JDJDJNNEEJJSKLS       1987-11-11

201205455        MARGARET                  GUMP                          1952-01-01

087605420        ADAMS                        ...

what do u mean by app, I am doing these in my sql server reporting services.

I am ok with my select statement, i got the result i need but when when i add this select to my expression in my report its...

for instance my result set shud be in this way.

address1    address2         Result

aaaa            xxxx             xxxx

bbbb                               bbbb

cccc            yyyy             yyyy

I need all address2 value and if there is null in address2 then display address1 value in place of that

I have 3 columns appno,appseq,ledger for that constraint