For the initial job, I would follow the excellent advice above.  This would also get the dts packages -- the only other way I know without writing code is to...

The first thing I would do is establish basic communications.  Can you ping the IP address of the FTP server from your SQL Server?   It could be related to DNS...

Although I like MS products, Microsoft has never been one to quickly accept a court ruling except where it benefits them. MS has been struggling with the upgrade cycle...

Is there a specific reason for doing the join criteria in the where rather than in the join clause? Using the join is ANSI standard.

Joe Johnson

NETDIO,LLC.

Why are you breaking the date up that way? breaking up the date in the where clause that way will force a table scan.

You could probably increase...

Geez. I got it wrong. However, I feel justified because I was in the majority -- misery loves company and all that.

The date column threw me as I...

quote:

---

So.. now when we get a file from that system, we just open it up in Textpad and save as to...

ASP should be running under the IWAM account by default. How is security setup on the server that is running ASP? How is your SQL server login setup,...

These aren't specifically SQL Server, but I like gotdotnet.com, codeproject.com, and 4guysfromrolla.com -- some interesting articles and info.

I still haven't found a really good book that I like for .NET...

I had a problem with Unix text files similar to this, where the input was expecting a standard CR/LF at the end of each line -- in hex 13 and...

It is not very hard to do that if you know the commands to send to the web server. In one of my grad classes, we had to do...

I may be missing something, but if it is a small group program and you are obviously coding it, wouldn't the performance, security, etc be better if you implement the...

To build on your statements and to answer Philip...

In most instances, localization usually happens at the business logic stage, which is either in the client or the app server tier...

I found this split function on this site a while back -- it works great.

http://www.sqlservercentral.com/scripts/contributions/157.asp

Joe Johnson

NETDIO,LLC.

This is about website server using Site Server and SQL and setting up a server farm. It might help depending on what you are doing. http://www.microsoft.com/siteserver/ssrk/rk_manage_whitepapers.htm

Joe Johnson

NETDIO,LLC.