Hugo, thanks VERY much for your script and, even more, your explanation. Simple and to the point, thorough.

Posts like this one are why I sometimes spend more time than...

Hmmmmmmm...... did you search this site? When I looked up my script to do this, the first thing in it was this comment:

-- FROM http://www.sqlservercentral.com/Forums/Topic853747-146-1.aspx

😉

Rich

Nadrek, good ideas.

I'd add *.cab files to your list: you can always re-load them if you move them off to a removable disk.

Rich

Here's a quick and dirty VB Script I munged together from the interwebs to pull out Image data from a SQL table and write the stored PDF files to disk....

hallhome (9/15/2010)

---

Thanks everyone. Whoever set up this database made some big mistakes. From the older logs that I have seen, it appears that they had set up full...

But what happens when you add...

GilaMonster (9/8/2010)

---

yessen (9/8/2010)

---

Well my sysadmin uses backup-exec software to save the mdf and ldf files every day, which is not the full backup of the database. If lets say everything...

I just spent 2 weeks(!!) cleaning up a lookup table in a third-party ERP application that allowed (and still allows, but for the now-rescinded, application level user permissions) free-form entry...

You're welcome! Nice to know it helped, and good to hear back that I wasn't typing into the ether!

This is an incredibly useful site, full of knowledgeable articles, thoughtful...

I often use something along the lines of this to read in Excel data. The IMEX=1 trick will save you a lot of grief from SQL incorrectly "guessing" what...

I'm pretty new to RS, but I will suggest one benefit I've found to putting some formatting in SQL and not in RS: maintainability.

I find it much easier and more...

I've run into a similar problem importing data from Excel. There's a connection string parameter you can add to prevent SQL from "guessing" how to import the data:

http://microsoftdw.blogspot.com/2005/11/excel-data-not-coming-into-ssis-right.html

Maybe there's...

However, I set it to delete all the shipped log files that are older than 7 days.

So, lets say something bad happens, I tell my SQL Management Studio to restore...

wilson.higdon (8/4/2010)

---

rmechaber (7/22/2010)

---

I'm surprised no one has mentioned the one drawback of storing packages in the database: you cannot edit them there. You have to export the package to...

Thanks for the link!

Rich