While deploying are you selecting connection manager for excel file in configuration file? If you are selecting connection manager for excel file in configuration file, make sure that username, password...

Use question mark in sql statement as

Select ToEmailID

FROM dbo.Table1

WHERE PackageName = ?

Go to parameter mapping. Add a parameter. Rename parameter name to 0. Select system variable for package...

Did you try accessing Oracle SP by creating a system DSN?

Create a ODBC data source for Oracle(Control Panel -> Administrative Tools -> Data Sources(ODBC) -> System DSN -> Add...

You can use OLEDB command for the same.

Write a stored procedure which will insert a record into table and then select @@IDENTITY value as output parameter.

Create a new...

It is 1252

Use the below transformation in derived column and then use data conversion to convert to Date data type

SUBSTRING([Column 0],1,2) + "/" + SUBSTRING([Column 0],3,3) + "/" + SUBSTRING([Column 0],6,4)

where Column...

ODBC can be accessed in SSIS using ADO.NET connection manager.

To create ADO.NET connection for ODBC, Add new ADO.NET connection manager, go to Provider drop down, select ODBC Data Provider...

Check for memory settings used in SSIS data flow. For more details check http://msdn.microsoft.com/en-us/library/ms141031.aspx

If you want call the web service inside Data Flow Task then you need to create its web proxy and then use web proxy in Script component.

If you need...

You can add derived column transformation between source and destination to combine all source columns together.

Or you can write a sql query in Source to combine columns from source and...

Did you check for Lookup Configure Error Output option is set to Redirect Row? Set all columns to Redirect Row on error.