Hello friends Actually in ssis pkg after some step i do login at site https://www.donotcall.gov.au/industry/ using my login and password then then upload my data file there and choose an option at site then site will return me some data file and save in database.. and this is daily based task.. Can i do this task automatically.?? Please Friends help me in this . Regards Bi_group

You can schedule the package. http://blog.sqlauthority.com/2011/05/23/sql-server-running-ssis-package-in-scheduled-job/Best Regards,Uri Dimant SQL Server MVP,http://sqlblog.com/blogs/uri_dimant/ Blog : MS SQL Development and Optimization Blog : Large scale of database and cleansing

Yes you can do this using a script task. Check this for reference where the user has uploaded a code he used for loading a file to a https site.http://btsbee.wordpress.com/

thanx for the reply to both of you.. actually URI i think you didn't understand my question..:) i want to do some task in which i login at some website and perform some operation and get datafile and finally upload in database. i need to do all these using ssis.. can i ?? if yes then how.. ??

What do you mean by "perform some operation". If the scenario is connect to website, upload a file, wait for a response file to be dropped at some ftp/ network to database then you can achieve this using a script task (to uploda file), a loop (to wait for the response file) and a data flow task to read and upload the response file. If the scenario is connect to web service (exposed by some website) to upload file, receive response and upload it to a database then you can achieve this using a webservice task/ script task (to setup a request-response pattern) and a data flow task to upload the response to the database.http://btsbee.wordpress.com/

Hi Btsbee. Actually Perform some task means first login there ,upload file, choose action in which i want to choose subscription then simply site will give me and output file ... will you please help me with code and example. The site is https://www.donotcall.gov.au/industry/ ...... thanx with Regards Bi_Group