You should leave the catalog db alone and simply redeploy the packages.

Which version of SSDT are you using?

As were our replies, whose questions you have not responded to.

coool_sweet (8/31/2016)

---

sorry type mistake, suppose i have 41 rows ,20 processed successfully and 21th got error.

now when next time my package run i want it to start fro 22 rows...

As...

coool_sweet (8/31/2016)

---

in my ssis package , i have 6000 rows coming and i am puttingin 1 file.

now my requirement is if more than 6000 comes, ex 8000 , 6000 will...

Is the hardware config (CPU/Cores/RAM/Disk Architecture) the same in both environments?

Have you done a side-by-side comparison of the database properties under the 'Options' node in SSMS?

Same question for the properties...

valmostricay (8/30/2016)

---

Today I have worked in sql server 2014, I saved all changes in my database and closed it. Couple hours ago I opened it again and showed an error:...

Nice post, Frederico. Good points, well made.

There is more than one syntax error here (I thought you'd done...

afreenraja (8/29/2016)

---

Thanks for your quick response.

Please find my answers:

Which table does the ordertype column live in? Exp

Are you summing the sale column from the sale table, or does Exp have...

dan.brown1 (8/29/2016)

---

Hi,

In my Prod & Non-Prod, we use a stored proc to pull a list of rows. In non-prod sql server, query completes in 2seconds but in prod it would...

pedro.imex (8/28/2016)

---

a) Identifying the statement(s) which generate the error(s)

$query = "UPDATE lc_t_configuracion SET valor = '$valor' WHERE id_conf =$id_conf ORDER by id_conf DESC LIMIT...

Welcome to SSC.

We're not PHP programmers here, so please help us out by

a) Identifying the statement(s) which generate the error(s)

b) Cutting and pasting the exact text of the error...

Eric Mamet (8/28/2016)

---

A colleague told me that there is Analysis Services in SQL Server 2016 standard edition, though with capacity limits.

Is that true?

Or is it still necessary to get...