Off the top of my head, I would suggest a Derived Column operation with a FINDSTRING call to get the  position of the period, then a SUBSTRING call to return...

There is an MSDN thread about the "Failed to decrypt" error over at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=142920&SiteID=1

If you use the SSIS Deployment Wizard along with a configuration file, you can specify the...

I pull a lot of dates in the format of MMDDYYYY in from text files in SSIS.  I typically use something like the following as a new DT_DATE (rather than DT_DBTIMESTAMP) column...

I've not worked with Paradox specifically, but in theory you should be able to do it in SSIS via an ODBC data reader.  You'd likely need to establish an ODBC entry...

I have no hard evidence of it, but I think that a pointer would be faster for access only if the field size is routinely over 8000 characters.  Otherwise, you'll...

The performance you get will depend on how much data you're putting into the max fields, your database settings, and what operations you're doing with these fields.  I was apprehensive about...

If there is consistency in the data, that is, if the extra comma is always present, you could import the name components as multiple fields and concatenate them using a...