Home Forums SQL Server 2005 SQL Server 2005 Integration Services How to modify sql statement for all Oledb Source from Script Task programmatically RE: How to modify sql statement for all Oledb Source from Script Task programmatically

  • August 5, 2008 at 8:25 am

    #853205

    Not sure about the specifics for the AS400, but I created a "SQL command from a variable" and then use Script Component to create the SQL command. The Script Component is called before the Data Flow task.