That worked, thanks Sean 🙂

Perry Whittle (4/10/2014)

---

No you...

george sibbald (4/9/2014)

---

your question said transfer from sql2000 (2K) to sql2008 (2K8), is that correct?

SQL IDs are logins authenticated by SQL, i.e. you enter an ID and a password, rather...

george sibbald (4/9/2014)

---

I have not tried this so cannot confirm it it works. Even if it does I can say it would randomize SQL authenticated passwords, so it would be...

kramaswamy (4/3/2014)

---

Well, as I said, unless you use an ALTER DATABASE SET OFFLINE WITH ROLLBACK IMMEDIATE, the SET OFFLINE will wait until all open processes are finished executing before setting...

Thank you, well spotted!!...

kramaswamy (4/3/2014)

---

Could be mistaken, but I'm fairly sure that when you execute an ALTER DATABASE SET OFFLINE, it will automatically wait until all processes are finished running before it takes...

That's what I've been trying, but no dice. I've selected the bar from the drop down, reset/refreshed the columns several times, but it still presents as a heap.

SQLRNNR (3/10/2014)

---

With the improvements in the QO, the implicit conversions are likely just being revealed to you now while they 2000 didn't care so much about it. I'd find...

Jack Corbett (3/4/2014)

---

I think you can replace both scripts with the File System Task in SSIS. The first one would be a delete task and it won't...

EricEyster (2/25/2014)

---

Use the Foreach Loop Container to find all the *.csv files in the folder. Use an expression on the file connection manager to assign the actual file name. For...

Jeff Moden (3/2/2014)

---

Jake Shelton (3/2/2014)

---

Thank you Sean - again, is it worth changing the table structures? Also, will we need to point the sprocs to the new indices?

BTW -...

Thank you Sean - again, is it worth changing the table structures? Also, will we need to point the sprocs to the new indices?

BTW - we are porting these...

Ignore this post, wrongly located.

That did not work, I installed the program but the Move/Copy function doesn't even show other packages, the only option is to change the scope within the same package elements...