Data Driven VBP ???

[posix337]

Hello!

We are in a process of converting our CD production processes into a data driven automated solution.

We have a database (SQL Server) that contains a list of file locations in Perforce. This is on the order of ~500 files.

We would like to query the database and somehow loop through Perforce Sync command steps, however we have not found a good way to do this without resorting to using vbscript and the Perforce COM object...

So, we've solved this for SYNC commands however in the near future I will have to come up with solutions that pull data from a database, build vb projects, copy, and zip files... etc... All of the things VBP is good at.

I hate to think of the amout of work to do all of this in script, it would nearly eliminate the usefulness of VBP. ( I might as well write it all in a program or script).

So, I guess what I really need is an example of querying a database into a recordset or something similar, and looping through VBP steps using the data from the query..

Any help in this area would be greatly appreciated... VBP has been a tremendous help in our automation needs,.

Thanks all!