
December 21st, 2012, 04:37 AM
|
|
Registered User
|
|
Join Date: Nov 2012
Posts: 11
Time spent in forums: 44 m 53 sec
Reputation Power: 0
|
|
|
Importing an Access Table
Hi
I have an access table that contains two fields. Forecast_month and actual_month.
ON an access for the user enters the month via a text box and this updates the table.
I then want to run my SSIS job that imports the access table into my SQL table.
Looking on the web the best advice appears to be to use dtexec via a stores procedure, then to call the sp from access.
My procedure is
dtexec /f "G:\4.FinMgt\Proj_Forecast\pkg_import_months.dtsx"
When I try to execute I get Incorrect syntax near 'dtexec'.
Does anyone know what I have done wrong and is dtexec the best way to get the access table imported.
Thanks for your help
|