Hi,

I have built a DIM job for AP Vouchers on Sage 500 v7.90 and have it working properly but now I need to set it up to run every night unattended.

How do I tell SQL or SSIS which company code to import the data into? My current Sage 500 database has multiple companies and need to only import to a specific one (i.e. SOA).

The stgvoucherdetl table has a TargetCompanyID column but this is more for intra-company functionality than to determine which company to import into.

I see on the SQL job that you can pass parameters but not sure if this should be done at the SSIS level or in the SQL job.

Any help is greatly appreciated!