Check in IE - go to Tools, Options, Connections tab, Lan Settings button..., and see if you have a proxy server specified. My guess is that you do. ...

I haven't seen this before & I'm somewhat confused. The error would indicate that you can't resolve the URL, so maybe a DNS issue upstream from you. But...

P.O. Boxes are of course not tied to a physical location, so there's nothing you can do about those. As far as the other dirty data, some of the...

I took a quick look on their yahoo developer group, and looks like they have some city level geocoding available for some locations. But unfortunately, you're right, the really...

Thanks for the feedback. Good advice on the warning column length.

I think this should work if you don't have the SQL Server project option....

1 - open VS 2005, and choose new project, type "Class Library". Name it the same...

Definitely something to consider - if your company or business relies on you being accurate down to a tolerance of feet, or the density of the location (NY) is such...

I don't profess to be a C# wiz, so don't have an exact answer. I would start with the XmlTextReader object. In my code I put it in...

Well, initially when I prepared the article, it was 50,000 hits per day. But I just checked now, and they have changed it to 5,000 hits per day ....

If you install the oracle client tools from you SSIS machine, I think the default location is:

c:\oracle\ora92\network\admin\tnsnames.ora

One of my entries looks like this.......

fully.qualified.server.name =

(DESCRIPTION =

...

The password policies for SQL 2005 pick up the password policies from the box that SQL is sitting on, so if that's part of a larger domain policy, then check...

Give this a try - this worked for me on SQL 2005 instance. I'm assuming you're going to Active directory, but not sure...You also must have read permissions on...

If you're working in 2005 you can also use Try/Catch...

SET XACT_ABORT ON

BEGIN TRY

BEGIN TRANSACTION

INSERT INTO table1 (...) VALUES (...)

INSERT INTO...

Yes you can. Install 2005 instance as a named instance. I have had some issues on a cluster with both versions, but on a standalone box, they run...

I agree with Joseph - check out the e-learning, and if you can, just start on SQL 2005 instead of 2000, since 2000 is already a 5-6 yr old release....