Not sure about on a clustered server, but Books Online I think covers the subject on a nonclustered server. Check there and see if it helps.

Jack Corbett (11/24/2008)

---

Lynn Pettis (11/24/2008)

---

Jack Corbett (11/24/2008)

---

rbarryyoung (11/24/2008)

---

And for the record, I like to sit up front because at my age, I cannot see the code slides well enough otherwise......

First both columns can't be primary keys unless they form a multi-column primary key.

Read the article below in my signature block about how to ak for help. Without the...

Jack Corbett (11/24/2008)

---

I would have...

Can you run the batch file as an OS step in a job?

I was able to duplicate your problem on one of our 2000 baoxes. I don't have an answer for you unfortunately.

Have you searched the Microsoft Knowledge Base or reproted...

This doesn't look like a problem with PSFTP, but hat you have the encrypted (saved sensitive information) the package you are trying to run on your server.

Some people just have to complain. Good article. Jeff Moden also wrote an article on the Tally table here on SSC. If you haven't read it, you...

Matt Miller (11/24/2008)

---

There was a very similar thread to this a little while back. You might care to do a search using the SSC google search box (top right...

Now that was funny (lmao)

Looks like a variation on the running totals. I'd recommend two things; the first read the second article in my signature block, and two is use a properly constructed...

Sorry, but you posted your question in a SQL Server 2005 forum, so you got a SQL Server 2005 answer.

Jared Hunt - SQLAddict (11/24/2008)

---

SQL Server 2008 is not that much different than 2005 from an engine perspective, so I would be surprised if an app could run on SQL...

Read Books Online, specifically look up the PIVOT command.

vijaya (11/24/2008)

---

Hi,

When am trying to insert data in to tblAsset table using OLEDB dstination component in SSIS I got following error:

[db_dest_ins_tblAsset [26320]] Error: An OLE DB error has occurred. Error...