Convert .bas file to .dts - SQL Server Forums

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)

Convert .bas file to .dts

Author

Topic

seagateik
Starting Member

3 Posts

Posted - 2002-07-10 : 13:04:20

Hi!
Is it possible to convert VB .bas file to .dts file (or open it in DTS
Designer) ?

Thanks in advance.

setbasedisthetruepath
Used SQL Salesman

992 Posts

Posted - 2002-07-10 : 13:09:51

If you previously saved a DTS package as a visual basic module, you could certainly open it in EM and save it as a OLE structured storage file ( a .DTS file ), yes.

Jonathan Boott, MCDBA

setbasedisthetruepath
Used SQL Salesman

992 Posts

Posted - 2002-07-10 : 13:53:58

I'll have to eat my words here ... I assumed you could open a .bas file after the fact but after actually trying to, it doesn't appear you can open packages saved as anything but structured storage files.

Jonathan Boott, MCDBA

seagateik
Starting Member

3 Posts

Posted - 2002-07-10 : 13:56:17

Let me clarify myself:
The package was created with DTS Designer.
After that to modify it I saved it as VB file(.bas) and modified in VB
(a lot of similar Active X tasks).
Now I need it back as .dts file to be stored on the server.
How I can do this?

Thanks

quote:

If you previously saved a DTS package as a visual basic module, you could certainly open it in EM and save it as a OLE structured storage file ( a .DTS file ), yes.

Jonathan Boott, MCDBA

setbasedisthetruepath
Used SQL Salesman

992 Posts

Posted - 2002-07-10 : 14:00:15

Ouch. I wish I could offer you a solution but I'll have to refer you to my previous post. If you really want the package to exist on the server you might have to merge your VB changes into the old package on the server.

Jonathan Boott, MCDBA

seagateik
Starting Member

3 Posts

Posted - 2002-07-10 : 14:19:36

Thanks

quote:

Ouch. I wish I could offer you a solution but I'll have to refer you to my previous post. If you really want the package to exist on the server you might have to merge your VB changes into the old package on the server.

Jonathan Boott, MCDBA

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources