"Bryan O'Malley" <bryan@N-O-S-P-A-M.chameleon-systems.com> wrote in message
news:K8QVa.48762$wk4.15990@twister.nyroc.rr.com...
> I'm trying to create a local package that will back a set of SQL Server
> tables up to a local Access file on a regular basis. The goal is to have
the
> DTS job create a new access file each day, then backup the tables from SQL
> Server to Access.
>
> I used Enterprise Manager to Export the data from SQL to Access, and had
it
> save it as a local DTS Package. That produces something like what you'll
see
> in this graphic:
>
> http://www.techimo.com/forum/attachment.php?s=&postid=754440
>
> I also know how to make an ActiveX (VBScript) component that will make the
> Access file for me, and set each of the destination data sources to point
to
> the access file.
>
> The question is, how do I put them together?
>
> How do I get that ActiveX task to execute before any of the others? I
could
> set each of the table copy tasks to be dependent on the ActiveX task, but
> there are hundreds of tables, and that will take forever.
>
> Is there any other way?
>
> As it stands now, there are no success or failure dependencies on the job,
> and yet it does seem to execute in a predictable order. I'm just not clear
> on what that order is.
>
> Do job execute from Left to Right? Right to Left? Top to Bottom?
>
> Any help would be appreciated...
>
> Bryan
>
> Try EasyImage Lite to optimize your photos for e-mail and the web!
> www.chameleon-systems.com
>
>

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:%23q%23EyQqVDHA.1072@TK2MSFTNGP12.phx.gbl...
> The order is that which you added the tasks. You can look at constraints
to
> execute that will give you a definite workflow.
>
> Introduction to Workflow
> http://www.sqldts.com/default.aspx?6,107,287,0,1
>
> You can assign the names of Access databases using code similar to this
>
> How can I change the filename for an Access Connection?
> http://www.sqldts.com/default.aspx?6,101,201,0,1
>
> --
>
> ----------------------------
> Allan Mitchell (Microsoft SQL Server MVP)
> MCSE,MCDBA
> www.SQLDTS.com
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
>
>
>
> "Bryan O'Malley" <bryan@N-O-S-P-A-M.chameleon-systems.com> wrote in
message
> news:K8QVa.48762$wk4.15990@twister.nyroc.rr.com...
> > I'm trying to create a local package that will back a set of SQL Server
> > tables up to a local Access file on a regular basis. The goal is to have
> the
> > DTS job create a new access file each day, then backup the tables from
SQL
> > Server to Access.
> >
> > I used Enterprise Manager to Export the data from SQL to Access, and had
> it
> > save it as a local DTS Package. That produces something like what you'll
> see
> > in this graphic:
> >
> > http://www.techimo.com/forum/attachment.php?s=&postid=754440
> >
> > I also know how to make an ActiveX (VBScript) component that will make
the
> > Access file for me, and set each of the destination data sources to
point
> to
> > the access file.
> >
> > The question is, how do I put them together?
> >
> > How do I get that ActiveX task to execute before any of the others? I
> could
> > set each of the table copy tasks to be dependent on the ActiveX task,
but
> > there are hundreds of tables, and that will take forever.
> >
> > Is there any other way?
> >
> > As it stands now, there are no success or failure dependencies on the
job,
> > and yet it does seem to execute in a predictable order. I'm just not
clear
> > on what that order is.
> >
> > Do job execute from Left to Right? Right to Left? Top to Bottom?
> >
> > Any help would be appreciated...
> >
> > Bryan
> >
> > Try EasyImage Lite to optimize your photos for e-mail and the web!
> > www.chameleon-systems.com
> >
> >
>
>