|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Thursday, November 12, 2009 5:06 PM
Points: 8,
Visits: 52
|
|
I am attempting to delete rows in a SQL table that may already exist based on a date provided in a file name (i.e. Elm_CBMC_DFromon_102909.txt) where I wish to execute a delete statement from an ExecuteSQL task where I can pass in the WHERE logic as a variable (in this case '10/29/2009') to delete the rows that may already exist. i am pretty new to SSIS and have not come acroos this exercise before. can some one out there please guide me through the steps it takes to successfully strip out the date from the given filename, pass it through as a parameter/variable and successfully execute it in a ExecuteSQL task?
If there is some already prepared link for this process that too would be greatly appreciated.
Thank you!
Steven
|
|
|
|
