You can have the stored procedure in the OLE DB source in the dataflow. You can map parameters into the stored procedure. Be aware that stored procedures can behave oddly...

Very very intesting question. Thanks Ron.

Jason-299789 (12/14/2012)

---

What exactly are you trying to do?

Also the SCD will not recognise Primary keys on the desitination table as Business Keys as they are not guaranteed to be identical,...

So you have a transaction around the dataflow, data is transferred inside the dataflow, the dataflow errors out and data is still inserted?

That's very strange. Also because the dataflow will...

Don't worry, we all had this happening to us once 😀

The two Execute SQL Task and the destination in the dataflow use the same connection manager right?

Are you sure the data is stored outside of SQL Server? This is the case with FileStream for varbinary(max), but I'm not sure it is for the image datatype.

Did you put the property RetainSameConnection to true on the connection manager?

Because it is not there?

(probably because the query optimizer thinks certain queries can benefit from the index)

Maybe SSIS hates being called recursively? 🙂

Why don't you build a recursive function right into the script task? Unzip the file, check for .csv and if there are no csv...

You can't. You'll need to do custom coding in .NET to achieve this, and it won't be easy. Search the net to found out if someone else has already coded...

SQL Server supports up to 2,147,483,647 bytes for image data.

It doesn't use 2,147,483,647 bytes for the pointer.

An alternative if you don't like coding:

put a data conversion task and convert the column to a numeric datatype.

Redirect the errors to another destination or throw them away (for example...

Great question to end the week. Had to do some research, but it was worth it.

chris corbin (12/13/2012)

---

It's reasons like this that I view Microsoft Certifications as absolutely worthless..

FYI.. to everyone involved, the correct answer here is to write a C# app, or use...