You've posted this in the wrong forum. I'll ask Steve to move this to the 2012 forum.

Without knowing a few more details, this one is hard to answer.

Can you post pics of all tabs on your EXECUTE SQL task?

Also, how many is "more records"? Have...

SQLisAwE5OmE (1/13/2015)

---

GilaMonster (1/13/2015)

---

Script all their modified procs, views, functions out. Backup, restore with overwrite. Run script with all objects (take a backup of their DB first, just in case)

Likely to...

Peter2012 (1/12/2015)

---

Hi Gurus,

We're using SQL server 2008 R2 and have been receiving the following error messages recently.

----------------------------------------------------------------------------------

Error: 14421, Severity: 16, State: 1.

Date12/1/2015 12:06:00 PM

LogSQL Server (Current - 12/1/2015 5:45:00 PM)

Sourcespid55

Message

Error:...

The other possibility (correct me if I'm wrong, everyone) is to use the DTSX Import Wizard from the 2008R2 server to grab the data from the 2005 server. It won't...

WOW. I did not know about that hack. Thanks, Koen.

Can you try explaining in more English and less code what you're trying to accomplish?

masoudk1990 (1/13/2015)

---

I know how to copy and paste data from one table to another table with INSERT and SELECT query.

I just want to know is it possible to do this...

ElKapy (1/12/2015)

---

Hello there,

I have a some SSIS-Stored-Packages. Running these jobs via "Run package", works fine, inluding logging.

Running the packages by Job, however, works also fine, except the Logging!

Looking in the...

You also need to be careful if you are inserting into a column that already has the identity property set. Check out the SET IDENTITY_INSERT statement in Books Online.

But if...

Wow. I haven't posted to The Thread since last year... Anyway, hello again everyone.

Me updates... I'm hoping to convince my bosses to pay for PASS this year since I...

Lynn Pettis (1/12/2015)

---

Brandie Tarvin (1/12/2015)

---

Lynn Pettis (1/12/2015)

---

Brandie, just curious, when you are importing the file how is it inserted into the table(s)? Does the data go in sequentially on...

The Redneck DBA (1/12/2015)

---

Brandie Tarvin (1/12/2015)

---

And the verdict is in. It was the mirroring after all. Specifically, it was synchronous mode. When I set it to asnychronous, it only took...

Lynn Pettis (1/12/2015)

---

Brandie, just curious, when you are importing the file how is it inserted into the table(s)? Does the data go in sequentially on the clustered index? ...

And the verdict is in. It was the mirroring after all. Specifically, it was synchronous mode. When I set it to asnychronous, it only took 2 and 1/2 hours to...