Good catch. I didn't get beyond the recordset and activex when I posted my answer. If this is all that the whole DTS is doing, then a SQL...

You'll also want to look at Expressions to build your SQL queries into variables. Not as much fun, but it's doable. I'd recommend getting your text editor out...

From your description, it sounds like you're talking about a "For Each" container. Check out http://www.sqlis.com for Shredding a Record set - http://www.sqlis.com/default.aspx?59

You may also...

Hard to really say without knowing what the error was you encountered. Try looking at the Progress tab and scrolling through the output to get the error or show...

If the file/dataset is small, try putting a data viewer on the task. That way you can watch the values going across and see what's going on. (Right-click...

Save the package and either add a step to Drop tables first, progressing on completion or modify the Create table step to check for and drop any existing tables prior...

Try using Ragged Right. If I remember correctly, the row delimiter doesn't work the way we expect it to in Fixed-Width. CR and LF are just treated as...

Expressions will more than likely be your friend here. I've seen a couple of posts on some blog sites that talk about using expressions to get dates, but that's...

I think I actually did, but I'm not quite sure what I did to change it. I know that I've had issues when the DBF files I need are...

I actually have "Paradox 5.x" in my Extended Properties. Perhaps that's worth a try?

Best guess is that you need to have the Paradox drivers installed. I have Paradox 9 installed on my machine so I don't expect any major issues. I'll...

There's also an add-in @ http://www.sqldts.com that you can use if you install it on any machines that will need to edit or run the package. It...

Yes, the properties window for your Excel Source. Look for the Connection String property and add IMEX=1 (with ; before or after as appropriate to separate the parameters). ...

You may want to try adding IMEX=1 to your connection string (just before the end-quotes). This will force all columns to be treated as strings, so you...

After reading this a little more closely, I'd have to agree with the poster who indicated to read it into a table, the split the text through TSQL commands. ...