July 25, 2008 at 4:25 am
Hi all!
I am not really experienced with SQL Server 2000 but my boss wants me to store all dts (binary format) we have (about 500) in a .bas (VB) format (the files are stored as structured storage files). This is to store them on VSS to keep tracks of the changes done. I know you can do it using enterprise manager but they are too many to do them one by one. I had a look on internet and couldnt find a solution for this. A software that can be called in a command line with source and destination folder as argument would do. Also a script converting to .bas would be great.
thank you for your help!
Romain
July 25, 2008 at 4:38 am
DTS packages can be exported to a file and then imported into SQL Server if saved in the structured format but not if saved in VB format.
There is a utility to perform these activities at http://www.sqldts.com/242.aspx
SQL = Scarcely Qualifies as a Language
July 25, 2008 at 5:05 am
Hi,
I dont think you understood my problem. I have to create a system to keep tracks of changes done to dts scripts. To do so I think the best way is to use VSS and store my dts in it to be able to check their historic. The problem is that dts are binary files and VSS wont show me the differences between two versions of a file in this format. Therefore I have to convert each of them to Visual basic and them store them into VSS. My problem is that there is no easy way to convert .dts to .bas (VB). I tried DTSBackup2000 but it doent do conversion.
thank you for your help,
Romain
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply