Thanks a lot for your reply Andras.

Therefore, if I understood BOL well, setting the transaction level to READ UNCOMMITTED would do it?

The parameters are mapped right to me...

1) What you could do is execute the same sql query in Sql Server... See if you get any results from that..

2) Avoid...

You're welcome 🙂

Try going to Object Explorer > Databases > Choose database to script. Right click on it > Tasks > Generate Scripts...

Thanks a lot for your replies!

I decided to use the numeric(19, 5) instead of numeric(16, 5)..

Definately. it is all about how you are calling the spoc..

I would also like to know how to get around this please.

LOL DATABASE -- The reason of existence of this website 🙂

it says 'Cannot copy or convert flat file data for column "Product Name"

Check if the conversion is right or that the columns are mapped correctly...

Thanks MArek 🙂

I would be interested to know how to do that in SSIS please

Amazing!!

Thanks a lot Andras!