thkz pritesh got it ...really it was helpful i have been tryying this from friday as my senior said it is fixed width so i havent tried it as ragged...

yes pritesh exactly thats what i need and i am trying too but the problem here is i couldnt set the columns correctly as in the pic when i just...

the sample data is something this way ...

A0233366240 2522966011G14454530000000 76668 LORABCDEM 1.0MG ...

hi pritesh ans steve ...pritesh i tries the way you said me but it did not work for me in that way and i came to know that there is...

hey garry this is rag...add me to the buddy list and msg me when needed i shall try if poss...

hi...i am unable to understand where can i pass the variable in the execute sql task..

i shall set the for each loop and give the properties in that create...

ya i got it thkz jay

do u know how to set that in ssi bcoz i tried doing it i couldnt get that ...

i have got error saying sending mail failure.....

i have addes smpt...

is this only for excel or any source i mean flat file also...

but i couldnt understand where should i add it to the connection string could u provide me an exapmle of one of urs file with that imex plzzz...thkz for...

the error shows that ssis is not installed completely or a service pack is not updated accorfnig to the version ur using ...plz check that u shall get it

hi I am curious to know that what is IMEX i jus want ot know that and where can i set that to one i couldnt find it in...

hi holly can u please let us know how did u do that bcoz i couldnt get u ...if poss with a n example...thkx

u can import all the file using a single package if it does have the same attributes ....create a package with foreachlloop in which set the option for for each...

If so try to do import using import/export in ssms ..if it went throuhg there might be some problem with ur ssis installation...as u said u are having vista could...