Are you playing around with the SET FMTONLY ON\OFF settings in the proc or when executing the SQL?

If u have a 3rd party source, want to write the conversion in VB.NET (script task), why r u trying to use ssis then? just curious?

Did u try using the TO_CHAR from the oracle query ??

I have found the checksum to be useful in some cases and unreliable in some. If the data set if distinct then the checksum function (of all rows stands good),...

Did u create a resultset [0] for the stored procedure output??

Do u have permissions to take backup on the other side?

Did u set EvaluateAsExpression property = TRUE on the variable?

Have u had a chance to look at the Email Task ?? It is really simple. Connect your work items to the email task with a workflow condition and...

In the where clause use the variable substitution

SELECT some date

From some table

WHERE MyDate = ?

Under Parameter mapping in ExecuteSQLtask add a new parameter, take the approp data type, and for...

Create a variable and write code in script task or expression builder to change it every week (or put the code in the the OnPreExecute event of the package)

U need 2 merge join transforms (1 for first 2 joins [TbaleA and TableB] and 2nd for the join of [TableA and TableB] and TableC

actually u may get errors because of no values or null values.

Check out my blog for this section:

http://sqlscape.blogspot.com/2009_03_01_archive.html

It has the section to set the value correctly.

Hope it...

SELECT @RowCountResult = Count(*) AS CountResult From Table Where name = 'Ryan'

Add a Script task and print out the variable

Dts.Variables("VarName").Value.ToString()

See what is the filename..... mostly it is bringing the filname in an incorrect format, i.e. with\without full path descriptor.

If you raise the error it should fail the package (Assuming that you have set the following properties FAIL PARENT ON FAILURE = "TRUE" on all tasks in the for...