FTP in a nutshell . . .

FTP client communicates to FTP host via TCP/IP to transfer files.

Transfer errors are "typically " caused by TCP/IP communications errors (but not always.)

Session...

Hi Duran,

You do need a dedicated network for the heartbeat.

(Do not setup a heartbeat connection through any shared network switch.)

A direct cable connection between two network adapters is considered a...

K . . . I'll bite . . .

BCP T-SQL reference . . .

http://msdn.microsoft.com/en-us/library/aa174646(SQL.80).aspx

Or . . .

Bulk insert may what you're looking for . . .

http://msdn.microsoft.com/en-us/library/ms188365.aspx

And . ....

Hi Golden,

I don't have much experience with this particular T-SQL command . . .

but I believe OPENROWSET may do the trick for you.

There a couple of gotcha's with this...

Also . . .

Ensure your workstation's MDAC is updated to the latest version.

(Assuming you're using WinXP)

To check the version -

http://support.microsoft.com/kb/301202

To Download -

http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&displaylang=en

2.) For a local instance...

1st step (I'd do) is attempt setting up user or system DSN via the ODBC Data Souces wizard.

(Control Panel / Administrative Tools)

It should display an error message when you test...

from within the Query Analyzer (SQL 2000 SP4) I got the resultant 1.0 as well.

just my $0.02.

M

Hi Lynn,

It is a really good company to work for.

The company's called PMA Canada Ltd.

(Peter Mielzynski Agencies)

http://www.pmacanada.com/

We're a national organization (offices in every province.)

Family owned (William Grant's &...

I work for a SMB beverage alcohol import agency . . .

As compensation we receive . . .

Competitive pay (reviewed ad-hoc,) flex time, work from home, health benefits, performance...

tosscrosby-60625 (3/2/2010)

---

Sometimes I can be a little too sensitive. No offense taken at all Mark. BTW - my last name is also Crosby. No relation to the hockey player....at least...

Hey Terry,

Please accept my apologies.

It's (was) a cut/paste of the script from a popular beer commercial meant to poke fun at Canadian culture.

(It's now affectionately called "The Molson Canadian rant".)

No...

'nuff said. orginal post edited - rant removed.

There's still a great brewing community in Wisconsin.

http://en.wikipedia.org/wiki/Wisconsin_breweries

Fabulous products!

Hey Artoo,

Modify the script to set the time/date to the file name . . .

http://msdn.microsoft.com/en-us/library/t0aew7h6(VS.85).aspx

(Language Reference)

http://msdn.microsoft.com/en-us/library/d1wf56tt(VS.85).aspx

DatePart

http://msdn.microsoft.com/en-us/library/4kt42529(VS.85).aspx

i.e.

oDom.Save "C:\PC\XML\testxml-" & DatePart("yyyy",NOW) & "-" & DatePart("m",NOW) & "-" & DatePart("d",NOW)...

Hamilton, Ontario, Canada . . . Born & raised!

http://maps.google.ca/maps?f=q&source=s_q&hl=en&geocode=&q=Hamilton,+Ontario,+Canada&sll=43.256692,-79.869053&sspn=0.832135,1.978912&ie=UTF8&hq=&hnear=Hamilton,+Hamilton+Division,+Ontario&t=h&z=10&iwloc=A