Have you tried using Power Query to extract data from the web site instead? Power Query has a lot more capability than the standard web data snagging wizard. Check out...

I'm always looking for free geography related data sets. Here is one that can serve up census data and more on US locations. I've used it in the past to...

What kind of service account are your services running under? Are you using Domain accounts or Network Service accounts? If you are using Network/machine accounts, try using a Domain...

A friend of mine took the Microsoft example proc and produced a more robust version. It defaults to using the servername from @@servername if one is not provided, and it can...

Two things jump out at me as possible problems:

1. you have LIKE operators that are incomplete

     active_flag like 'a' 

has no wild-card or regular expression defined. if you are trying to...

The best approach to solving this is a "table Pivoting" technique that uses a CASE statment to drop row values into specific columns, and a group by to collapse the source rows...

Abhinav,

Until we have Try/Catch blocks in T-SQL you do have to trap for errors after every proc call.  It is possible to do this in a more generic fasion by...

There is an even simpler and more elegant use the Coalsce() function to "Flatten" a column to a delimited string.  I first saw the technique in an article in T-SQL...

Here is a proc that demonstrates parsing a string out by a delimeter into multiple words. It should work to suit your purpose directly, or as an example of how...