Many thanks Luis

Hi Eugene,

Thank you very much for your posting. Hope this is clearer:

declare @PhoneTable_New table

(

Id BIGINT IDENTITY(1,1) NOT NULL,

Phone nvarchar(20),

PhoneCount Int,

ContactName nvarchar(60),

ContactNameCount Int,

CustID nvarchar(20) ,

CustIDCount Int,

CustomerName nvarchar(60),

CustomerNameCount Int,

TableSource nvarchar(20),

PhoneSource nvarchar(20)

)

INSERT...

Thanks GianLuca - Think that solved the issue

Many, Many Thanks guys

Hi Ian,

'No' we don't have strange business requirements, and as I pointed out, I am new to triggers,

but I did attempt to post/describe my T-SQL issue as well as I...

Many thanks John and Cadavre for your help.

Cadavre - on first glance that looks correct.

Thanks John.

I couldn't see the wood-for-the-trees in the larger query.

Regards,

Many thanks Phil

I found this

http://dbaspot.com/sqlserver-dts/203632-ssis-pulling-data-excel-2007-a.html

I'll try the associated download in the DBA's reply.

Regards,

Hi Koen,

Thanks for your reply... I don't believe I bossed anyone around. Also, I DO appreciate and haven't forgotten that this is a forum with unpaid members. I was just...

AAAARGH... This is so frustrating.

I think I have supplied sufficient details in my related posts.

I can't use the 'sa' account. The sa account doesn't have the rights to the 2nd...

Yes, 'xxxx' IS the service account. This account has the required privileges on both servers. The 2nd server is VERY locked down, which is why I'm using credentials etc

Thanks for your tme guys - but I think I found a good web link that helped resolve my issue. Basically, I added a For Loop container after my Execute...

Thanks for the replies

I realise that the code in my original posting needed double quotes

"\\ServerName\AX\WT A to B\Mileage.Bat"

I...

Excellent responses guys. Thanks