dtexec.exe /sql \AADDM\AADDM_Load_USPL /SERVER "130.175.234.224" /USER ssisexec /PASSWORD ssisexec703 /set \Package.Connections[ADDM].Properties[ConnectionString];\""Data Source=xx;User ID=xx;Initial Catalog=xx;Provider=SQLNCLI.1;Persist Security Info=True;\""

can you assist with the step to resolve this issue please

there may be another way, if you use JET engine(provider) in the oledb source and read the csv file as a table(donot dump it in a table), you can query...

check for if the multiple values are seperated by space or carraige retrun(Enter). If they are seperated by space then its a hard time, may be use lookup values to...