I'am having one csv file (dimglobalkeys.csv) contains only one column (unitofmeasure) having 68 records. my destination is table called dimglobalkeys having no data. i have insert scripts to insert the...

(1)double click on executeSQLtask

(2)click Parameters Mapping tab in executeSQLtask

(3)click on add button

is there any other option with out modifying the oracle query......???

I PASSED ORACLE QUERY USING EXPRESSION..SO BY DEFAULT THE EXPRESSION IN QUERY IS TAKING AS DT_WSTR DATATYPE...SO HOW CAN WE CHANGE TO DT_NEXT....

you can call the User defined function and Store procedure directly in Report Dataset.

Thanx...

http://www.mssqltips.com/sqlservertip/1405/sql-server-integration-services-ssis-package-configuration/">

http://www.mssqltips.com/sqlservertip/1405/sql-server-integration-services-ssis-package-configuration/