I kind of remember hearing about this before. I believe the resolution was to uninstall/reinstall SSIS and/or Excel.

An alternative solution would be to use a Data Conversion transformation after...

Are you 100% certain that the latest version of your package was actually deployed to that folder?

Beat me to it Phil.

Here's what I came up with.

DECLARE @Input varchar(8000)

SELECT @Input = 'ab.cd.ef.gh.kl'

DECLARE @Start int

SELECT @Start = CHARINDEX('.', @Input) + 1

DECLARE @End int

SELECT @End = LEN(@Input) - CHARINDEX('.',...

If all of the data from your source is transferred to the destination regularly, the simple answer would be to truncate the destination tables before executing the data flow tasks.

You...

From http://consultingblogs.emc.com/jamiethomson/archive/2005/05/29/SSIS_3A00_-Memory-Usage.aspx:

On 32bit Windows

* Maximum memory is 2GB without the /3GB switch in boot.ini

* Maximum memory is 3GB WITH the /3GB switch...

In his example, VAR_TEST was the variable name, Ivan_Test was it's value.

SSIS 2005 works just like DTS did. I'm sure 2008 is the same way.

Remove what you've entered in the Expressions section.

Click on Script, then enter your variable name VAR_TEST, without the @, in either the ReadOnlyVariables or ReadWriteVariables property.

You can ignore that error, but you'll have to create the deployment manifest file manually. This happens when more than one package in your project uses the same config...

Are you sure that problem isn't the other way around?

There are 2 things you can to to handle unmatched record errors in a Lookup. Ignore them, or redirect the...

You can add more than 1 Lookup to a data flow.

Simply connect the matched output of your 1st Lookup to your 2nd Lookup, etc.

A File System Task with it's Operation set to 'Copy File' inside of a For Each Loop Container.

You'll have to set up variables to store your source & destination folder...

From http://msdn.microsoft.com/en-us/library/ms135954.aspx:

The VS_ISBROKEN value indicates that the component has an error that can be rectified by editing the component in the designer. The error is typically caused by a custom...

SQL*Loader is similar to BCP.

http://www.oracle.com/technology/products/database/utilities/htdocs/sql_loader_overview.html

Oracle Warehouse Builder is an Oracle ETL tool:

http://www.oracle.com/technology/products/warehouse/index.html