Brandie Tarvin (9/12/2012)

---

At my employer, we have a couple of methods, depending on site in question. One method was written up by our developers and has a webservice call that...

Yes,...

RBarryYoung (9/11/2012)

---

GSquared (9/11/2012)

---

SSIS has an FTP object that can be used to automatically download the files. Won't work if it's FTPS, but will for FTP. Will that work...

GSquared (9/11/2012)

---

SSIS has an FTP object that can be used to automatically download the files. Won't work if it's FTPS, but will for FTP. Will that work for...

As the other replies indicated, this is about security, not...

Ah. There's your problem.

{oops}

I posted a question here: http://www.sqlservercentral.com/Forums/Topic1357535-2799-1.aspx?Update=1 about automating file downloads in SQL Server. I would appreciate any help or suggestions or even just "This is How We Do It."

Thanks,...

Thanks for the suggestion, arbarona. However, this is not quite what I am asking for.

This link explains how to write a...

Actually, you failed to answer the most important question: Are they on the same network?

Start by...

After thinking about it some, I suspect that this is probably a codepage problem...

First, use Management Studio to generate a script of both the published table and the subscription table. Make sure that you have the "Include Collation" scripting option turned on...

I should add that this may not actually do it for you, it may only enforce it. (throw an exception if it's not enabled when a new database is created)....

Thanks Clare, that makes much more sense... 🙂