Glad to help... best of luck to you.

Tim

How are you storing the password?  If you're not doing so already, store it in a config file for maximum portability.  See the following for a primer on how to...

James,

Make sure you identify the quote " as your field qualifier when defining the text file source.  That will signal the parser that anything within quotes is an atomic value...

I've used the App Dev training series (http://www.appdev.com/) to brush up on various topics, and I have never been disappointed.  These videos are on the pricey side, but in...

Kyle,

If you are familiar with a .NET programming language, you should take a look at SMO (or SQL DMO, for SQL Server 2000).  This programmatic interface will allow you to...

Are the column names consistent for each data file?  If so, just skip the first row of data (Header rows to skip = 1).

hth

Tim

I ran into the same error, but I was trying to do a SELECT...INTO in a linked server.  I had to script the table on the target DB, then run an...

Are you running SQL Server agent using a local account on the SQL box?  If so, you'll have problems copying the file out to a network share.  If this is...

Sorry, I don't think there's a way to do this without uninstalling the default instance first.

Are you familiar with the conditional split task?  This component will allow you to redirect your output to multiple paths based on criteria you specify.  This should give you what...

This was a strange one.... After much searching, I just found the answer to my own question.  Run the following command:

mofcomp "C:\Program Files\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof"

See http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=142375&SiteID=1 for full details.

Dilsa,

It looks like this is a fairly simple mapping, with only the first value requiring any manipulation before going to the destination.  I would use a Derived Column task to...

When you enclose your entire case statement in the parenthesis after your AND clause, the query processor expects a true/false to be returned from within the parenthesis. 

You are also...

I think SQL Server has a driver for dbase - you might try connecting it as a linked server and hit the tables from there.

There was a throughput limitation on MSDE - I think it was five simultanenous operations - but this limit does not exist on SQL Server Express.  This free version runs...