You may want to look into Monarch if these are human-readable formatted text files. The Monarch Pro version should have a command-line interface so you can pass in files...

I'd love to see a solution to this, too. I was using a Dynamic Properties task to do the same thing, but looping through a list of servers. ...

Try downloading the latest OLEDB for FoxPro. It should be @ the http://www.microsoft.com/downloads site.

I was able to use that to import Foxpro data on my machine. ...

Peter, try to use a MergeJoin with a Derived Column transform in SSIS. That will probably be easier than trying to convert this using a script task.

Set up a...

Is DelayValidation set for that component? If not, that may be worth trying.

I seem to remember having the same issue and eventually got around it through a merge join and a derived column or something similar to convert my variable to a...

Anyone dealt with this? Anyone? Bueller?

You can't in SSIS at this time. I ran into the same problem. Some suggestions were to off-load the data into a flat file somewhere to read through...

You'd need to set the connection string as an expression, passed in to a variable or similar to the package. Run the SSIS package inside of a For Each...

Well, if the director has tact, then your life should be decent. After all, it's a business decision and if the backups aren't working successfully now (and backing up...

Can you schedule the backups through SQL at a time they aren't running their tape backups?

Easy way to ensure that you get...

Create a Global Variable of type datetime.

Use an Execute SQL Task to SELECT GETDATE() (in whatever format you want) - use the Parameters option to map the output to your...

Are any of the tables the same structure or are they all different? You can do this in one package either way, but if some have the same structure,...

Another point that may be worth bringing up is the speed of recovery. Recovery from disk will almost always be faster than recovery from tape. That would allow...

If they still support it, they may be able to give you a copy of the media as long as you have the license for SQL. I think we...