maybe there is a null or empty string

try this in the derived column

ISNULL( TextField ) || TextField == "" ? NULL(DT_I4) : (DT_I4) TextField

use a derived column and create a new column using the formula such as (DT_I4) TRIM( FieldNameOfStringData )

I'm glad you got it working, looks like I was a bit off base on that one.

Just to clarify, you have a data flow with an OLE source, set to...

You mention an OLE Source but not an OLE Destination.

My guess is you are reading data from one table and want to insert to another.

Forgive me if I'm being to...

since I don't know MDX by memory, what I do is set up a pivot in Excel and make it look the way I want. Then, using a plug in,...

I like the idea of moving the files and we currently use the file watcher in one of our ETL's, works great. If you can't move the files, here's a...

I feel like we're beating a dead horse at this point but I need to add on to what ...curril said.

I was in the same boat 2 years ago, the...

Project Real from Microsoft is a good resource for understanding business intelligence - http://www.microsoft.com/technet/prodtechnol/sql/2005/projreal.mspx#EEAAC

Also Adventure works has a DW example

I do the same thing Paul said. Here's the technique I use when dealing with assigning surrogate key values to my fact records for unknown members. I set up every...

This was a pretty old post and since then I just use a fully formed sql statement to get the data. I am pretty sure the Pervasive OLEDB provider does...

What does each record in the table represent?

Is it 1 record per invoice, per order, per line item?

Ok,

I should not have assumed by what I saw in perfmon.

I have always assumed doing something like a merge join would actually issue a command to sql which would do...

After watching the performance on this is appears that dtexec.exe uses very little memory and cpu.

I never gave this much thought but DTEXEC is generally issuing commands to SQL so...

Not sure what the problem is?

Sounds like you want to interate through a list of flat files and put that data into tables.

If so setup a file connection with...

I have it working now. Thanks so much for the help.

Here is a summary of what I did:

First deployed the SSIS package to the server using SQL Server storage

Usign DTEXECUI.exe...