Why not?

If that's where the deadlocks are happening, can you ask them for support?

It would be...

What is 'CRM destination'? Is this a custom component?

Mordred (5/15/2013)

---

I've been working on a workaround for this. I've created individual connections for each CSV file. At a certain point in my package, and while using precedence constraints...

Can you answer a couple more questions about your set-up:

1) Is the file format the same for all files?

2) Is this a common staging table, or is there one staging...

First point to note is that...

You could try exporting from Excel to a CSV file and importing that. You'll have fewer problems, I assure you.

Nobody wants that 🙂

An important part of the error message: "There may be error messages posted before this with more information about the failure."

Generally, I've found that to be the case - so...

hewitg 82815 (5/13/2013)

---

I'm currently creating a flat file export for one of our clients, i've managed to get the file in the format they want, i'm trying to get the...

Spam reported again.

Please go away ccmalls.

There's a built-in function in C# that will do this without looping:

string col1 = "0001234";

col1.TrimStart('0');

I think 'Jamie' was the name you were looking for 🙂

You could try something like this (untested):

Select HouseLine1 = (case when len(House_No_End) > 0 then House_No_Start + ' - ' + House_No_End

when len(House_No_Start) > 0 then House_No_Start

else House_Name...

How big is the file, roughly?

One option would be to pre-process it - maybe use s script task to replace "" with ".

If the file is huge, it might make...