In SSMS, open a connection to your Production...

If you have issues in the restore because of the lack of tail logs, let us know and we'll try and figure it out from there. But go ahead and...

I admit. That...

Elliott Whitlow (6/16/2011)

---

Use the input/output wizard and chose the tables and at the end save the package that should give you 98% of the work and be a lot faster...

Elliott is correct on this one. Not only is SELECT...INTO going to cause you performance issues, but the use of * will also. Can I ask why you don't just...

Okay, I'm a little confused. Could you speak less in L33T / text shorthand and more in real English words, please?

How many containers do you have in your package? If...

Elliott Whitlow (6/16/2011)

---

Brandie Tarvin (6/16/2011)

---

Why use a Script Task when a File System Task might work just as well? You can set variables at the package level and have them...

Phil, where did you get the idea that fuzzy lookup is only available to Enterprise Edition? SSIS is available...

EDIT- Whoops. Made the @@Version comment about the wrong post. My bad.

I need to see a shot of the variable from the variables window AND the entire properties box when...

Try naming the Transaction. See if that gets around the error.

Also, what you wrote makes no sense. You have a transaction with no way of backing out if there's...

sonal_anjaria (6/16/2011)

---

It is a Execute SQL Task. Trying to move tables from a sql server staging database to a production database

I have created two variables at the container level, not...

Sqlchicken (6/16/2011)

---

viduvs (6/16/2011)

---

Thanks for your reply.

I was having the same solution to install a new fresh instance and then configure the things.

Though we don't have a backup (even external backups),...

Lowell (6/16/2011)

---

see opc.three's post from the thread below;

i learned something here, since i was used to think that GO + BEGIN TRANS were not compatible, and now i know...

princa (6/16/2011)

---

Lowell (6/16/2011)

---

see opc.three's post from the thread below;

i learned something here, since i was used to think that GO + BEGIN TRANS were not compatible, and now i...

I wish I could tell you otherwise, but unless you've got some other availability set up (log shipping, Database Mirroring, etc.), you're stuck doing it the old fashioned way.