Knowledge Essentials - 3Essentials Hosting

Scheduling MSSQL Jobs or SSIS packages on Shared Hosting

Article ID: 664

 Back to Search

Question:

I'd like to schedule a SSIS (SQL Server Integration Services) package for my MSSQL database on my shared hosting account.

Answer:
  • One of the key “features” of the higher end SQL server.. this includes such things as automatic import of a CSV file into database tables. This basic import/export can be done with the db user created in plesk, when connecting with that user as a SQL Login from MSSQL Mgmt Studio over our SSH/tunnel based connection. 

  • As a further enhancement, SSIS packages can be scheduled as job steps within a SQL agent job to be automated, for example to daily import a spreadsheet into a table.  At this time, this feature is not supported on our shared hosting services.

  • Customers may wish to evaluate moving to our virtual or dedicated hosting plans.  This feature is supported on managed virtual and managed dedicated server plans.  Note the plan must include the Plesk Power pack for managing MSSQL databases, and must include a version of the SQL Server engine which supports the SSIS features required including SQL Server Agent (which is not included in some versions... please check Microsoft for details on comparing MSSQL editions).
 
Downloads Associated With This Article
No downloads are currently associated with this article.