September 24, 2014 at 9:55 am
Hello, I need to create a job that import an access database.
Does exist a command that I can use to do that?
Thanks
Viky
September 24, 2014 at 10:34 am
One way would be to create a stored procedure to do the import/massage of data and then schedule that in a Job. Then if the Job executes on an interval, then the data would get imported on that. Without more information, it's hard to give you a more definitive answer. You could use OPENQUERY or something to get to your Access data.
September 24, 2014 at 11:22 am
sistemas_casinomnes (9/24/2014)
Hello, I need to create a job that import an access database.Does exist a command that I can use to do that?
Thanks
Viky
Quick thought, I've found that using the import/export wizard to create an SSIS package, saving it and modify as needed, being the path of least resistance. The package can then be run by a scheduled job.
😎
September 24, 2014 at 1:38 pm
Very true... I was probably having flashbacks to "databases" created by people that didn't have a clue what they were doing... so a LOT of cleanup was required... in that case, SSIS definitely gets my vote.
September 25, 2014 at 4:51 am
What is the command Transact sql that I can use to import the access database?
September 25, 2014 at 9:41 am
Is this a one time thing? Does the destination database and the tables already exist in the destination? SSIS could do it. Not enough details to know which is the best option though.
September 26, 2014 at 5:10 am
Yes the database and destinations tables already exists.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply