Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Dynamic DTS packages

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-07-06 : 11:06:54
Robert writes "We are currently converting our entire system from Fox Pro 2.6 (yeah I know) to SQL 7.0... One problem that we have encountered is that our ACEing software from PostalSoft only excepts text files and DBF's. Instead of writing a separate DTS for each file we wish to process (I would say on average we process 50 files a day) or writing some text file creation code in VB, I was hoping there was a way to dynamically change DTS packages. Our development team (all three of us during off hours) haven't been able to find anything.

Thanks,
SQL N00wB1E"
   

- Advertisement -