I think this should be giving you a syntax error.  I don't think you can use a parameter in an assignment.

Oops yeah, the output parameter from an ExecSQL task needs to be the result of a select query.

Right now you have two sprocs, one depends on success of the other? ...

Try this in your Exec SQL Task...

DECLARE @rc int

DECLARE @rptdt datetime

EXEC @rc = dbo.usp_MySproc @rptdt

SELECT @rc AS MyOutputParam

You can now assign the result of...

When you create your Oracle connection, use the Oracle ODBC driver, not the OLEDB provider.

You should change your design to the one I described.  While called a "DataSource" the Excel File that is referred to in the DPT is the destination.  Each transformation must have...

Your first step should be an ActiveX before the DPT.  When you use Excel as a destination, the file must already exist when the transformation begins. So you will need to...

Okay then, you don't have a problem.  Source File is handled in its connection object. Destination Database is handled in the connection, table in the transformation.  Instead of the format...

Here is an example.

I have a package configuration table that stores a bunch of dates, flags and such that tell this particular package how to run, one of which is a...

Well it ain't fast if it don't work, eh? 

Keep in mind that you can run multiple transformations all at the same time -...

Not sure why you are hanging on to bulk insert?  I don't think it meets your needs.  Why not trash it and use text file source instead.  Select the appropriate...

I found a nifty new use for the dynamic properties task.  I use it to manage step precedence bases and values in a package that requires the dynamic skipping of...

Once you fix that issue, you might also consider dropping the duplicate mapping of the b fields.  Also bad form to use * in your source sql.  Guess what happens...

Thank you, Aaron!  I will share this with my team!

I would like to know too!

This is what I have been doing instead -

1 - evaluate - set global var to indicate pass or fail.

2 - take care of business - net...