I get all the dtsx which has XXX values in it

Thanks Scott...that is exactly what I was looking for.

This is how the data looks like.

Select 1 ,'Mon-Sat 10am-9pm, Sun 11am-6pm'

UNION ALL

Select 2,'Mon-Sat 10am-8pm, Sun 10am-7pm'

UNION ALL

Select 3 'Mon-Thu 10am-9pm, Fri 10am-10pm, Sat 10am-9pm, Sun 10am-6pm'

Thanks a lot Luis. the logic is brilliant..It helped me save lot of time.

Sorry for not posting the DDL.Next time I will definetly do that. Thanks again..!!

Iam not clear about the nesting.Can you please give me more details..?

b) based on a certain value in a database table?

I think this is possible.

1) Using execute SQL task select the value from the data base.

2) Use the value...

Thanks Sean & Lowell for your help . Let me try this 🙂

The build succeeds ,but Iam not able to find the problem.If you can point me why this error occurs then I can check that.

Again I need a code to delete...

Yes,SSIS installed in my machine.How do I debug from SSIS...?

I don't have C# installed in my machine. How do I do that..?

Sorry the request method is DELETE instead of PUT.

request.Method = "DELETE";

Iam getting this error

Error: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.ArgumentException: Empty path name is not legal.

at ST_20aed8fe3d0347a0b748f4bc14e21fe2.csproj.ScriptMain.Main()

---...

SQL Agent is not enabled

Thanks to both of you.

check this Link...I executed using this.

http://bi-polar23.blogspot.com/2007/08/loading-multiple-excel-files-with-ssis.html