Try something like

DECLARE @Err int



CREATE TABLE #Tmp (

  PingText varchar(255)

)



INSERT INTO #Tmp

  EXEC xp_cmdshell 'ping <your server ip address>'



SELECT @Err = COUNT(*) FROM #Tmp

WHERE...

You need to use the RETURN statement, not RAISERROR.

eg: Return(1)

Thanks

Phill Carter

Can you use ping via ExecuteProcess Task or xp_cmdshell?

Thanks

Phill Carter

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

---

--------------------
Colt 45 - the original point and click interface