SSIS with ACCPAC ERP

[freddyHt]

Has some one try to use SSIS (SQL integration services) to push data to ACCPAC ERP like customers data with custom script?

Thanks for your answer

 

[ettienne]

Forget about it.... you never want to mess around with the database, use the API.

 

[freddyHt]

You could use the API with SSIS. I saw some examples with Microsoft CRM. See link below:

http://blog.sonomapartners.com/2009...using-sql-integration-services-ssis-2008.html

The only information that I find on the Web about SSIS & accpac Api it is this link:

http://blog.cybner.com.au/2007/07/adding-custom-dll-to-ssis-script-task.html

 

[DjangMan]

Let us know how it works out.

 

[ettienne]

Check your backup routines as well.