What I did, from the SQL ToolBox book, for template is, create an actual package with all standard connection and component generic to my development and save it to sql...

Okay. I'll try that and get back to you guys. Thanks for all of you participated.

Okay ... so this seems to be more intesting then what i originally thought it would be ... huh ?

Great approch you all. But the problem is still unsolved....

Oops again!!

Hey Chris,

You looked over one little itsy bitsy detail ... i need to do this in SQL 2000.

Thanks you.

Yeah you are right, i need excatly this.

I kinda need a sequence within each set. I wish if I could see some sort of code for that ?

Thanks for the help. To give you a clearer picture ... here is a sample file data. In the below the 1st line is the header for the consolidated file....

Black background is easy on eyes, for me. By the way its quite old school ... remember blackboards in school?

Also the question is...

I might not belong to that part of the world but long weekends ... aah ... what a luxuary .

If I get one...

You can also use SQL data import export feature. Just create a new database (in which you want to import your access file) with options you like; default would be...

You have got the logic right. Just sprinkle some more checks for sentences detection and you got what a typical VB6 programmer ( like me ) would do

Just posted quite similar script ... just above yours :p.

Good point regarding the 'registered size in memory' concept. Clears things more. Thanks.

Another point that i think found me is, I am not sure if that is relevant or not. But when running the script below:

declare @a float

declare @b-2 float

set @a= 10

set...

Just a brain fart ... for getting more then 2 decimal places you cab use this ...

declare @p int

declare @n int

set @p = 10

set @n = 3

select CAST(CAST(@n AS...

Thanks. Happy SQL-ing =)

Happy Anniversary.

Keep doing what you do, doing a greate job for the online SQL Server community.

FP