I want to run a procedure in SSIS Script component by taking one input as parameter.
parameter is retrieved from file name .
The file name is 2006-06-07.txt
I want to run a procedure sending this date as parameter.
Exec pr_populatedata '2006-06-07'
please suggest me the best possible method to solve this.
I feel that I can retrieve the name from variables in script component.
If script component is better for this task..please tell me how I to connect to sql server in script component.
I am new to SSIS