Perhaps you would describe what was wrong with Drew's...

Interesting, thanks for posting this.

OK.

Can you elaborate on exactly what you mean here - what steps are you taking?

scotdg (2/10/2016)

---

Thanks for the response Phil.

The package runs fine on the production server when I run it from SSIS. It is only when I execute the stored procedure that I...

You should also be aware that the NOLOCK hint can lead to some nasty issues, namely:

1) The possibility that 'ghost' data (data which is inserted as part of a transaction...

Did you appropriately configure the connection to MYSERVER.MYDB, somehow, after moving the package?

Or this?

-- Populate the AssetAddress Table with the relevant data

IF @Address IS NOT NULL

INSERT INTO AssetAddress ( AssetId, AddressId, EffectiveFromDate )

VALUES ...

ankithimmatlalshah (2/9/2016)

---

Hello everyone,

I’m working on one of the existing Extract package.

Our customer would like to move the complete extract logic, implemented in this package to SQL stored procedure(s) as they...

patla4u (2/10/2016)

---

Hi All,

I have total 460 million row in the table. I am running query for year 2016 and month = 7 and we have total 8 millions records. query...

VastSQL (2/10/2016)

---

Hi Experts,

We have a powershell which we need to run from one of our SQL Servers. The script checks for a particular service in 4 servers and if it...

kavithaje (2/10/2016)

---

Hi Allen,

The query is returning duplicate rows. i have same MachineID and InstanceKey in both tables. only Account. Schema class and time key is different. I mean Work_Station_Admin_1 got...

Aha, I just assumed it was an unorthodox way of referring to SELECT INTO.

Lynn Pettis (2/9/2016)

---

Who has the Crystal Ball??

Silver Spoon(2/9/2016)

---

I Get the following error when attempting to Configure Distribution on a SQL Server 2014 Machine

ServerName\Instance Cannot be configured for publishing and distribution....

What was the point of this?

The response marked as a solution does not reference your table at all.

The simplest way I can think of doing this is using an SSIS package to submit the queries in parallel via...