Ha ha - fair point. I guess on balance, that you need an owner who know's when to use option 3, but also understands that there are times when only...

Imagine if you employed a gardener on an hourly rate and he insisted on cutting the lawn with a scythe instead of a lawn mower. Wouldn't you get rid of...

I agree with the main point of the article. Automation is a good thing. Freeing up time for more useful tasks is clearly a good thing for morale and efficiency....

LOL, when you find that you know what Judge Judy is going to say before she says it, then that's the time to get on with your cycling adventure ;-)...

I started my sabbatical in November last year. I've been very fortunate to be in a position to do it, but I'm very glad that I have. I agree with...

I'd love to see how the TFL and Oyster network for London Underground is architected.

They have approximately 3 million journeys a day taking place, using RFID cards to gain entry...

What a cool application of the tally table. When I have string manipulation issues, I've always taken the educated guess / trial and error approach much like other posters, but...

In data warehouse development looking at a source system's data is encouraged. Not just column properties and NULL counts, but actually looking at values held within a column that don't...

You could pass in a parameter along with your DTEXEC command?

Perhaps a separate scheduled job would have the parameter IsScheduled set to 1 and the bat file or non scheduled...

Hi Adam,

Go from folder to folder and load each file into one database table? I have tried the For Each Loop, but it just looks for the file name...

I think you may need to escape the quotes too... I vaguely recall running into something like this myself a couple of years back... Something to do with the quotes...

Most likely, you don't have permission or the web server isn't configured to accept uploads. I'd check your credentials are correct and ask your client to verify that web server...

Unfortunately not with SSIS 2005. In SQL 2008 however, this is possible with the cache transform / connection manager and the new lookup component. In 2005, for this type of...

Hello Cospow,

I think asking people in this forum to provide you with a

is not going to get you very far. Perhaps...

I don't really understand how you're using the surrogate key or why you need it, but adding a rowcount to the final row of a text file is easy enough......