You are a genius! Thanks a lot!

Thanks a bunch there. But I have not at all used the Script task before. Can you walk me throught a step by step process. I will do it accordingly.

I did run the query in Query Analyzer and the response time for 10000 records was labout 20 seconds.I have removed all grouping and sorting that was applied on the...

Thanks a bunch to Sarah there!!! At least a rescue. I have done as you said, and it worked great. But I am very weak on Script Task. If...

Do you have the task coding? What transformation? Thanks

Thanks. But do you know anything easier than this. I am not a hard core programming person. I really appreciate your help in this, but I just can't run the...

Hi, basically if you want all the packages that you have created to be reused and deployed, you can basically save the package to a central hub(if your company has...

Thanks Sarah, but I do have 3 files coming at 3 different times and I have to automate this to run by itself each time selecting each day's date file....

Hi Suresh,

I did not find any solution up till now.I have done a lot of reading and

have made an assumption on the transformation that I might need to use.

I...