Stewart "Arturius" Campbell (6/6/2012)

---

I presume you are using SSIS?

Why must this be done using a script component?

If it is to populate a variable, consider using a SQL task, returning a...

Gianluca Sartori (6/5/2012)

---

Charmer (6/5/2012)

---

Hi Friends,

How to copy tables from one server to another server?

i tried ssis and export/import through ssms....but it says server instance is timed out to get the...

SQLKnowItAll (6/5/2012)

---

What query is timing out? For example, are you trying to do this all at once or one table at a time? If it is only 1 table,...

Jeff Moden (6/5/2012)

---

Charmer (6/5/2012)

---

Geoff A (6/5/2012)

---

it depends on what the table contains. (filestream data, identity column, timestamps, etc...)

but i like to do the following (your mileage will vary);

1. create the...

i already tried by changing it...

Geoff A (6/5/2012)

---

it depends on what the table contains. (filestream data, identity column, timestamps, etc...)

but i like to do the following (your mileage will vary);

1. create the database where the...

Charmer (6/5/2012)

---

Hi Friends,

How to copy tables from one server to another server?

i tried ssis and export/import through ssms....but it says server instance is timed out to get the connection....

since the...

Sean Lange (6/1/2012)

---

Your issues could be slightly different than mine.

Seriously you know better by now. Maybe somebody else has a...

Lowell (5/29/2012)

---

well it looks like it can be done without the cursor and also without the dynamic SQL;

this SELECT is the section that would be doing the INSERT;

how many rows...

Lowell (5/29/2012)

---

well the details are certainly different now that the DDL is posted.

the DDL details you posted is doing an Insert, not an update, and it's not joining on...

update top or doing an update in batches is the suggestion when you say an update for a billion rows takes too long/locks table.

to minimize that impact, you do multiple...

hi all here my ddl and dml and the cursor i use...

/****** Object: Table [dbo].[SrcCodeMap1] Script Date: 05/29/2012 18:30:46 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE...

oh....but i am not sure how the...

ok dwain, let me try to get DDL', and DML's...

Charmer (5/29/2012)

---

GilaMonster (5/29/2012)

---

No, a cursor is not likely to be good, neither is a while loop. What exactly are you trying to do? Iterative processing is typically slower than set-based...