greeshatu (5/20/2013)

---

Select and Update are running paralelly .. this is because I have used Balance data distributor to run the tasks parallely .Which asyncronous transformations is helpful in this case.kindly...

Your data comes in from Excel as Unicode.

If you are mapping it straight to varchar() columns, you will get an error.

Add a data conversion component to convert your columns from...

I couldn't find a way of doing this in an iTVF.

If you execute the following:

sp_executesql N'select * from products where name like @ProdName'

,N'@ProdName varchar(30)'

,@ProdName = 'Samsung%'

You'll get the idea of...

You could start by explaining what you mean by "not working."

Try rereading your message while imagining that you are not familiar with your environment. Do you think that you would...

Thanks Sean - that was the point that I was hoping to make.

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...