Yes you can do it by SSIS and with script too refer following link for script:
http://support.microsoft.com/kb/918992
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."