Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tombino
Starting Member
26 Posts |
 Posted - 2007-06-04 : 03:06:32
|
| Hi everyone,Every day I have to export data from SQL server 2005 to Microsoft access. (with export data wizard)There is an automatic function that allow to overwrite the data?because every time that I do it the tables goes to add to theexisting Access database. So every time before start the job I have to delete the file and create a newone.I appreciate your help |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-06-04 : 03:54:34
|
| Create a DTS/SSIS package and schedule it.Peter LarssonHelsingborg, Sweden |
 |
|
|
tombino
Starting Member
26 Posts |
Posted - 2007-06-04 : 18:49:30
|
| I have trouble to run the SSIS package like a job. If I use the DTExecUI.exe is working fine but when I try to do it using SQL server agent come out this error: execution of job'nameofthejob' failed and this is what is write in the history of the job: The package could not be found.I read that a lot of people is having the same problems. I can not use also the server machine, because is 64 bit, so when is trying to export file to microsoft access database (32 bit) it fail.What can I do?Tom |
|
|
|
|
|
|
export data