Thank u all for u'r tricks & tips.

I hav solved the purpose by calling DTS package in SP, where country wise data is supplied thru cursor.

Within the DTS Package, i am...

Thanks a lot, Will try the above.

In the mean time i hav used BCP, calling thru sp, where i have fetch the country in a cursor & execute one by...

yes pls, i need the output as excel or csv file.

The main purpose behind is, these country wise (xls/csv) files will be delivered to respective country owners by a Notes...

Thanks Kenneth,

As the above process being part of ETL program, there is no way to utilise this in the client side. Anywat thanks for u'r info.

regards

saravan

Jeff,

Even after using @@error i could not find any error.

But managed to get rid of prob, by spliting the dts as 2 package.

anyhow thanks man for u'r advise.

Regards

sara

Thz Jeff,

i included SET NOCOUNT ON begin of sp, at the end SET NOCOUNT OFF

but i still face the same problem, my connections to db is correct.

when i execute individual...