I found this posting on Simple-Talk the other day, and am intending to give it a try: http://www.simple-talk.com/sql/ssis/ssis-basics-setting-up-your-initial-package/

Then there's part 2 of the previous article: http://www.simple-talk.com/sql/ssis/ssis-basics-adding-data-flow-to-your-package/

Jason

Thanks for the information Steve!

If / when I go to the SQL in the City, it'll only be the second such event I've been too. I do (when I...

Well, for giggles I renamed an SQL Server I have, to see if that would break the Agent service.

I changed nothing, didn't follow the steps when done to rename an...

Did you rename the computer at some point?

I ask because it doesn't look like the computer name is the same between here:

and here:

Unable to connect...

Oh, I don't mind biased, and I figure I'll pick up some pointers even if I never touch a Redgate application.

Hmm, now to suggest this to one of my bosses,...

OK, I'm reviving this topic with a new (somewhat related) question:

How do you feel about the SQL in the City[/url] events?

I took a look at the agenda for the London...

At this point I've seen Avengers three times and yet I still wouldn't object to seeing it again. I'm a comic book fan from a while back, but nothing...

Thanks Lynn! I took a look at the PASS 2012 site, and it looks interesting, especially after I browsed some of the sessions from 2011.

Now, if I could figure...

Thanks to both of you!

Jason A.

Lynn, you are absolutely right that if we were to do Differential backups, it would catch the updated filestream information. I was talking about my original thought of doing...

Leo.Miller (4/17/2012)

---

jasona.work (4/17/2012)

---

I realize we could take Differential backups throughout the week (Tue-Fri,) which would capture only the updated / changed / added Filestream information, but there are office politics...

If you download and install the SQL Server 2008 R2 Express with Advanced Tools, Management Studio does come with it.

Jason

I think (right now) I'd probably be a Ford Crown Victoria. Rugged, dependable, keeps on going no matter what crap gets thrown at it...

Why do you think the Crown...

A few possibilities to look into on this:

1. Are your systems both in an Active Directory Domain? Can you ping each server from the other by name NOT...

Thank you!

Now to get myself into the habit of using them...

Jason A