Setting Vpd user before running SSIS's Lookup Query against Oracle DB.
i need assistance ssis expert if can me here. qq – using ssis(sql server integration service) task on hand , using lookup feature oracle db query – problem need set vpd user (virtual private database) before running lookup query. need advice on how can accomplished. tried running execute sql task before running data flow task. thanks in advance it's property of package connection manager, not project connection manager. david david http://blogs.msdn.com/b/dbrowne/ SQL Server > SQL Server Integration Services