Is there a way to automate the exporting of DTS packages to .bas files.
I know it is easy to do it manually through the gui but cant seem to track down any way to do it automatically.
Any known solutions?
Versions : SQL Server 2000
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
strangelynormal1 - it would appear that ccarns is asking if it is possible to automate saving the DTS package as a Visual Basic file, not automate the execution of the package. I presume they want to run through many packages and export to VB so they can program a GUI in VB.
Ccarns - I don't believe this is easily possible in SQL Server 2000.
Go to this DBFORUMS article for more on your question, however:
http://dbforums.com/arch/2
strangelynormal1 - thanks for the detailed instructions but that is not what I am after.
MikeWalsh - you are correct I am not trying to automate execution of the packages - I want to automate the export of all the DTS pacakages to seperate text files which are VBS(.bas) .
The reason I need to do this is for documentation, and not for anyother purpose such as executing the code via gui or otherwise.
I know the .bas file is ugly to look at but it has all the details of what the DTS package is really doing in one text file.
It's a shame that this functionality isn't exposed via the DTS object model--seems kind of dumb. In sql7, there was a script utility that would do this. I've heard that, for the most part, it works with SQL2000--you might give it a try: http://support.microsoft.c
Brett
Business Accounts
Answer for Membership
by: strangelynormal1Posted on 2004-02-04 at 16:36:12ID: 10276687
You may want to schedule the DTS package. I'll assume that you are going through the wizard instead of the DTS area and that when you mention GUI, you mean the "Data Transformation Services Import/Export Wizard."
After you've chosen the data you want to transfer and to where you want to transfer it, you'll come to a window saying "Save, schedule, and replicate package." Here, you will want to "Save DTS Package."
If by "automatic," you mean on a regular scheduled basis, select "Schedule DTS package for later execution" and press the "..." button next to it. Schedule it appropriately.
If you just want to be able to press a button to run the same export at will, then select "Save DTS Package." Then you can execute it from the Data Transformation Services, Local Packages by right clicking on the DTS you just created and clicking "Execute Package."
If you are not using the "Data Transformation Services Import/Export Wizard," then go straight to Data Transformation Services, Local Packages and right click on the DTS in question. Choose "Schedule Package" and schedule appropriately.
If this doesn't answer your question, please clarify.
Thanks,
Helena