SQL Server Integration Services Automation

  • How can I find status of a job in SSIS?

  • I am loading 5 different csv files into sqlserver db (into one table) by using 5 data flow tasks (each data flow for each csv), I am doing this monthly once manually.

    Would you please explain me how I need to automate this process.

    Another thing is, how we can load csv file into sharepoint URL by using SSIS.

    Its a kind of urgent...........

    Advanced Thanks

  • Even after I moved Microsoft.Office.Interop.Excel.dll file to GAC (C:\Windows\Assembly) folder, I'm still not able add it as a reference to my script task. Do I need to reboot the server?

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply