Hi Yes there is

Configure a second destination to a file or a table and set errored rows to redirect to this destination rather than fail the package

Both thank you for your time very helpful indeed , I was going with XML Explicit - am now on the right track

Hi Looks like your credentials are incorrect on the job:

"Login failed for user 'sa'."

Andy

Hi

Stab in the dark but I think your after:

WHERE (m.device='EM' or m.device IS NULL)

Andy

Hi Phil

Yep its really throwing me to and finding this is like looking for a needle in a haystack!

Tomorrow I will be trying This

Will post back once I've tried

Hi Phil

Again Thanks for taking time

Nope this is on the server and no, no other users can deploy and yep it affects all users and projects (admittedly there is only...

Hi Phil

Thanks for the reply

All SQL Services use Windows authentication and I am logging in using Windows Authentication and have tried:

Running the ispak manually

Running the ispak from command prompt (Admin)

Running...

Yep thats correct

You are only able to have 2 synchronous replicas and auto failover is only available on synchronous replicas

Its by design or you could auto failover with data loss...

Run > type: Services.msc

Locate the service Right Click > Start

Andy

Koen Verbeeck (8/8/2013)

---

Is a claim bound in any way to a policy? If yes and claim is just a smaller level of detail of a policy, than I would create...

Hmm no takers? Looks like I will be the first person ever to try Partition Sliding with Always On..... 😉 :rolleyes:

Thank-You Abu, very interesting, I'l take a look through this.

I'm interested, do many people use this solution?

Andy

Hi

Difficult to help with the info given, perhaps this will point you in the right direction?

SELECT

e.BuProductName

,MAX(s.OrderQuantity) as Sold

,CAST(SomeDate AS DATE)

FROM

dbo.Product AS e

INNER JOIN dbo.Transact AS s

ON e. productID=...

Hi

Here is one way without using a CASE:

DECLARE @gross_amount VARCHAR (10) = '18'

SELECT CAST(COALESCE(NULLIF(@Gross_Amount,'NULL'),@gross_amount) AS DECIMAL(18,2))

Andy

Yep, this one

http://www.amazon.co.uk/SQL-Server-MVP-Deep-Dives/dp/1935182048

Excellent book!