DTS Package Launching Access Database

[jjohns09]

I have several Access databases that run some automated tasks through the AutoExec macro. I need to be able to open these Access databases in the last step within my DTS package. I don't care about receiving anything back from them. I just need to open them so they can run their tasks. DTS should complete regardless of whether Access has completed it's task(s).

So, is there a simple way to launch these Access databases through DTS?

Thank you in advance,

Jeff

 

[philhege]

Add a SQL Query task, to be run on success of your previous steps:

xp_cmdshell 'ThePathTotheMDB\MyMDB.MDB', no_output

The SQL Server account or its proxy needs rights to the resource.

HTH,

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
I'm not as think as you confused I am.
-----------
Flabbergasted (a.): Amazed at how much weight one has gained.
-----------
Oyster (n.): One who sprinkles their conversation with Yiddish expressions.

 

[jjohns09]

Phil,

Thank you for the suggestion. Unfortunately, I could not get this to work. I added a SQL Task as advised, but when I execute the package, it never shows that this step has completed. It just sits there showing executing.

Jeff

 

[philhege]

Does the autostart macro close the MDB when it's done?

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
I'm not as think as you confused I am.
-----------
Flabbergasted (a.): Amazed at how much weight one has gained.
-----------
Oyster (n.): One who sprinkles their conversation with Yiddish expressions.