1. By using a temp table you are making unnecessary trips to the database.

2. If you lose your connection for some reason, then your base data is lost.

3. SSIS is...

Try checking the "RetainConnection" property in the connection manager you are using.

If you elaborate a little, we may be able to help you find a way to avoid the temp...

Hi,

Why are you inserting into temp table then into main table? Are you able to perform the transforms in the dataflow and insert directly into the main table?

Hi Dave,

It will be based on the data in the whole pipeline. So it doesn't matter what the external columns look like (they are used by SSIS for validation at...

Hi Dave,

You make some good points there...

SSIS calculates how many rows to fit in the buffer based on the estimated row size. And the estimate is based on the...

Hi,

If this is for a one off import then a dynamic solution may save you time, however if you are going to be using this import regularly then you...

If @[User::RunNumber] is a numeric variable then you need to cast it into a string so that it can be concatenated on to the...

Jeremy Giaco (5/7/2009)

---

I find that even when using SET FMTONLY ON; (and NOCOUNT ON) I still have issues with using temp tables in general in SSIS..i can get around...

Have you been able to isolate the offending records? Is it possible they are of different lengths? Could there be truncation going on?

You are converting to a non-unicode datatype......

The usual types of errors with this (I can't count how many times I've had to troubleshoot my packages for this type of scenario) are non matching data types, char...

Just as a side point, in most cases you don't need .net script to set package variables.

Use expressions where possible as they are easier to debug, more visible, and...

I was just re reading your post and I think I misunderstood what you were asking...

Are you able to elaborate some more on what you're trying to achieve? Are you...

Hi,

Not sure why you would need to run the same package twice, but in answer to your question you can copy records using the multicast.

HTH

This now looks to be an error in your DB2 SQL syntax.

Perhaps what you could do, is input the SQL command directly into the OLE DB Source, then when you...

At design time when you set the OLE DB Command to use a variable, you need to have a valid statement in the variable so that the validation succeeds.

If you...