On Jun 28, 2:37 pm, Yehuda Katz <yehudaak...@gmail.com> wrote:
> I am trying to download product data from a supplier to put into an
> online store.
> The supplier gives me a list of warehouses, and i can only download
> from one at a time.
>
> I created a DTS script to download the warehouse specificed in
> DTSGlobalVariable("Warehouse"), but i can not figure out how to loop
> through the table of warehouses to get each one.
>
> On top of that, i have a table that lists warehouses that should not
> be downloaded (because we do not want to sell products from that
> category) and i need to make sure that the warehouse that i download
> is not on that list.
>
> It seems that another DTS would work best, but i am also open to other
> suggestions.

> I am trying to download product data from a supplier to put into an
> online store.
> The supplier gives me a list of warehouses, and i can only download
> from one at a time.
> I created a DTS script to download the warehouse specificed in
> DTSGlobalVariable("Warehouse"), but i can not figure out how to loop
> through the table of warehouses to get each one.
>
> On top of that, i have a table that lists warehouses that should not
> be downloaded (because we do not want to sell products from that
> category) and i need to make sure that the warehouse that i download
> is not on that list.
>
> It seems that another DTS would work best, but i am also open to other
> suggestions.
>

On Jun 29, 2:57 am, Allan Mitchell <a...@no-spam.sqldts.com> wrote:
> Hello Yehuda,
>
> I am not sure of you have 1 table of warehouse info and you want to get the
> data for each warehouse seperately or that you have n tables of warehouse
> information and you need to loop through tables.
>
> Here is an idea about an Recordset Loop which it sounds like you may need
> certainly in the first example
>
> http://www.sqldts.com/298.aspx
>
> As for looping through tables you could follow a very similar approach.
> When you pick up a table name then you check to make sure it is not the one
> you do not want.
>
> Make sense?
>
> --
>
> Allan Mitchellhttp://wiki.sqlis.com|http://www.sqlis.com|http://www.sqldts.com|http://www.konesans.com
>
>
>
> > I am trying to download product data from a supplier to put into an
> > online store.
> > The supplier gives me a list of warehouses, and i can only download
> > from one at a time.
> > I created a DTS script to download the warehouse specificed in
> > DTSGlobalVariable("Warehouse"), but i can not figure out how to loop
> > through the table of warehouses to get each one.
>
> > On top of that, i have a table that lists warehouses that should not
> > be downloaded (because we do not want to sell products from that
> > category) and i need to make sure that the warehouse that i download
> > is not on that list.
>
> > It seems that another DTS would work best, but i am also open to other
> > suggestions.- Hide quoted text -
>
> - Show quoted text -