Thanks a lot guys ... with all yours suggestion, I was able to complete this. Happy new year.

Jeff Moden (12/22/2007)

I need to break these 10 tables into 50 tables 1 for each state ... Each state will have its own table... What is the best way...

Thanks guys

Thanks for the help... actually those 50 tables have to be further matched against a huge table to append other info based on addresses.... I did not want to run...

Basically I have 10 tables of Individuals Info broken down by First Digit of Zip... like all the zip starting from 1 has table called tble1 and so on... I...

Thank you all for all the suggestions... All of them are educational for me and I will use them now and in future.

Thanks guys for taking time and responding to my questions. It gives me a good starting point.

Thanks Loner. The database structure is same and we have different db for every client. The data file they send us are not of same format and data they provide...

Steve thanks for the response. We are talking about 200 clients. Any suggestion. Thanks!

It is a good practice to include error message on dts packages if you are scheduling it.

Thanks a lot Sergi!

Thanks Robert... it did work.

EXEC sp_MSForEachDB 'if exists (select * from [?].dbo.sysobjects where [name] = ''communication'' and xtype = ''u'')

begin

 select distinct  ''[?]'',

 a.*, b.Opened,  b.HardBounced, b.SoftBounced, b.MalFormed, c.Unsubscribed from (

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

Alok thanks for the response. We have two hundred dtabases. One way is to use

EXEC sp_MSForEachDB 'IF ''[?]'' NOT IN (''master'', ''model'', ''msdb'', ''tempdb'')

I think this takes care for all dbs in a server:

EXEC sp_MSForEachDB 'IF ''[?]'' NOT IN (''master'', ''model'', ''msdb'', ''tempdb'')

  select top 10 ''[?]'',* from [?].dbo.individual1 o join [?].dbo.address1...