The term "Formal Design Methodologies" would include things like database normalization techniques, process and data modelling. What gets done in what order, etc...

Something I found useful to get familar with...

You need to check the @@ERROR variable.

Eg:

fetch next from cur into @Var1

while @@fetch_status = 0

begin

  update table1 Set Field1 = @Var1

  if @@ERROR <>...

The best method is to use NT Authentication then there is no userid or password to worry about.

I set my ADO Connection string up as a Global Variable. The userid...

Check the SQL Server Accelerator for BI from Microsoft.

http://www.microsoft.com/solutions/BI/nextsteps/default.asp

Haven't tried it myself but it's supposed to build the DTS packages required for loading a Datawarehouse.

Thanks

Phill Carter

You can modify the Step name via Disconnected Edit. Be careful, you can screw things up if you forget to change one property. eg: The task name is also a...

quote:

---

What about @@rowcount along with the batch size

---

Let me explain my situation.

I have a file...

quote:

---

Have you tried using the Batchsize option.I think if you use this option with a specific size(1000) you can findout how many...

quote:

---

I think @@rowcount should give you the number of records inserted.

begin tran

select * into authors2 from authors

select @@rowcount

commit tran

---

November 11, 2002 at 3:49 pm