RE: Multiple loops in one package?

Hello Peter,

Based on my scope, this is not currently support in SQL 2000 DTS package.
You may want to check if SQL 2005 can meet your requirement because it has
enhancement on this respect.

For more information on this, please go to SQL 2005 newsgroup:

http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&sl
cid=us

Thanks & Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================


This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
| From: Peter A. Schott <paschott@xxxxxxxxxxxxxxxx>
| Subject: Multiple loops in one package?
| Date: Tue, 30 Aug 2005 11:30:55 -0500
| Message-ID: <v729h1dq10tmpqho1i9e4g275gn5k7t0i3@xxxxxxx>
| X-Newsreader: Forte Agent 3.0/32.763
| MIME-Version: 1.0
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Newsgroups: microsoft.public.sqlserver.dts
| NNTP-Posting-Host: 216.178.160.231
| Lines: 1
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.dts:14435
| X-Tomcat-NG: microsoft.public.sqlserver.dts
|
| I know how to loop through one set, but wasn't sure if there was an easy
way to
| loop over two variables, something like:
|
| Get list of servers
| Get next server from Server recordset --a
| For Each Server
| Get List of Databases
| Get next database from DB Recordset --b
| For Each Database on server
| Do Stuff
| Loop Databases (back to b)
|
| Loop Servers (back to a)
| Exit
|
|
| I know I can do one or the other without too much trouble, but has anyone
done
| this successfully? Do I just need to point the DB loop to B with a
success to
| Loop Servers which will then take me back to a?
|
| Thanks.
|

.

Relevant Pages

  • global variable not working
    ... which sets a global variable in the DTS package and then the stored procedure ... It all works on the development server! ... problem I am having is that I have moved the DTS package up to our Test sql ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS Packages fail when executed from Jobs
    ... I have tried running the DTS package on the server whilst logged on as the ... DTSRUN.EXE or through the SQL Server Enterprise Manager. ... >> I am having trouble executing a DTS package from a SQL Job. ...
    (microsoft.public.sqlserver.dts)
  • RE: DTS, .NET and remote servers
    ... Server A is running SQL 2000 and in domain X ... Server B is running IIS and host web-sevvice, ... I wish my web-service to trigger a DTS import on server A. The ... demonstrating the DTS package is loaded and accessible on Server B). ...
    (microsoft.public.sqlserver.dts)
  • Re: For Each in adp
    ... If you don't have the form tied to a table in your SQL ... Server DB, then you will not have any records to loop ... >> controls, or the collection of controls that are part ...
    (microsoft.public.access.formscoding)
  • Application hanging up when reboot
    ... i write a windows application which mainly loop at the sql ... server to do some operations. ... but, when i restart the computer without really close it first, a dialog ...
    (microsoft.public.dotnet.languages.csharp)
Loading