Creation, development, production then deletion.

Unhealthy SSIS packages skip the production stage.

AAAV (4/14/2010)

---

ok by mistake i created the dtsx in sql server 2008 BIDS and trying to open in 2005.

my dev machine has both versions and the server has only 2005....

No idea about the NULLs datatype, sorry.

Regarding SQL Server 2008 - go for it. SSIS is not much different, but in some areas it is just plain better and more...

da-zero (4/14/2010)

---

That's why I talked about redirecting or ignoring the error output...

I am wondering whether the fact that you used file-level copy with the packages has confused SSIS because of the duplicate IDs all over the place.

You may like to try...

Sorg should be joined to source_id, not destination_id.

The rest should be ok ... as long as you do not need sorg later on in the dataflow.

Build a mapping table (OldID, NewID) and then use a Lookup transformation to lookup the new ID based on the old ID ... much easier than building a mega-complicated nested...

How did you make the copies?

This also sounds like a maintenance nightmare for the future. Is there any reason why you don't do all the processing in the same package?

Puzzling.

OK, please try opening the advanced editor for your data source.

Have a look at Input and Output properties. Check External and Output columns for SectionTitle - should be TextStream (at...

murugappan.kathiresan (4/12/2010)

---

Phil,

This is my scenario...

I've one excel file, in that file i've one column called Allowance which has only numeric values if it is 0 then the user will enter...

Try putting a data conversion task after your source component. Convert the text field to string(4000) and map the converted field to your destination.

Are you saying that the data type of Allowance is numeric?

That would suggest that "-" is a valid numeric entry - as far as I know, it is not.

So ... the data type of your derived column must also be float?

But you are setting the value of this column to Allowance, which is a string ...

What's the datatype/length of 'LongDescription'?

What is the data type of Allowance?