We don't know your table structure or your data, making this rather challenging.

Perhaps you could use Profiler to find out what query, or queries, Navision is executing and compare those...

zouzou (6/29/2016)

---

So Sorry was in a rush and dint explain it properly.

The errors that i have originally mentioned are staying the same, although i have narrowed down to only...

Beatrix Kiddo (6/29/2016)

---

In the Venn diagram of the UK, all English people are British, but not all British people are English :-D. One of the best way to wind up...

Can you...

If you want to have control over the values in your IDENTITY column, I suggest that you don't use an IDENTITY column, or that you consider using SET IDENTITY_INSERT ON...

mcfarlandparkway (6/28/2016)

---

Thank you Eric, But didn't came nay results.

showing object name as delPersons ....I see only this.

Is there any way that they are handling this audit data from some where...

SQL Search[/url] is free and really useful when you are looking for references to database objects. Maybe it will help you track this down.

Sergiy, thank you for taking the time to write these informative posts.

I admit that I am guilty of following Paul White's recommendations as would a sheep and now I shall...

zouzou (6/28/2016)

---

I found out when i refer to an instance name inside the SSIS package it doesnt work when you deploy the package in sql job although in Studio is...

Eric M Russell (6/28/2016)

---

Based on the error messages provided above, it doesn't appear to be related authentication or permissions. It sounds related to the status of the source database server....

Have you verified that the SQL Agent service account has requisite permissions on the target SQL Server instance?

Jeff Moden (6/27/2016)

---

jeffe_verde (6/26/2016)

---

The files have data for the Asia-Pacific, EU, and the Americas financial markets (thus the AP, EU, and AM in the file names), and each file is...

zouzou (6/28/2016)

---

Hello there

I have an issue with my SSIS packages they run fine on Studio 2013 but when you try to run them as a SQL job in SQL...

jeffe_verde (6/25/2016)

---

I receive three versions of a file each day, which I then import. But the file names are such that my ForEach loop processes the files out of...

Paul White suggests that the NOT EXISTS ... INTERSECT form produces better query plans than the EXCEPT form, and that's why I use it. See here (in the comments).