SQL Server Integration Services Automation

  • ashish sinha-404083

    SSC Veteran

    Points: 296

    How can I find status of a job in SSIS?

  • vasu_sql-1092310

    SSC Veteran

    Points: 269

    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

  • Jay1234

    SSCommitted

    Points: 1622

    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 18 (of 18 total)

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