Trigger a SQL Script to Run Based on a Column in Flat File Source In SSIS
-
Hi, I'm new to SSIS and am trying to create a project that uses a Flat File as the source file and extract data from a column (containing ReportDate) and use this parameter to set the Where clause in a stored proc to delete records from a SQL Server table. I'm sure this can be done, just don't know how. Thanks in advance for any help you might provide.
-
Hi, I'm new to SSIS and am trying to create a project that uses a Flat File as the source file and extract data from a column (containing ReportDate) and use this parameter to set the Where clause in a stored proc to delete records from a SQL Server table. I'm sure this can be done, just don't know how. Thanks in advance for any help you might provide.
Delete From TableName Where CoulmnName = @Parameter