convert .bas 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

Import/Export (DTS) and Replication (2000)

convert .bas to dts

Author

Topic

ciaran
Starting Member

40 Posts

Posted - 2006-01-04 : 05:30:28

Hi,
I seem to have been handed a project that no developer at this company wants to touch. I have a complicated vb project which builds a dts package on the fly and then executes it. I simply wanted to know if there are any tools out there which may aid my cause i.e convert .bas to dts. I know this is a long shot but what the hell i have to ask.
regards
ciaran

sachinsamuel
Constraint Violating Yak Guru

383 Posts

Posted - 2006-01-04 : 05:53:44

You mean to say you want to save the bas file in DTS?

If yes then find the below code in your bas file.

'goPackage.SaveToSQLServer "(local)", "sa", ""
goPackage.Execute
goPackage.Uninitialize

uncomment the line in bold and run. This will save the code in DTS format and then run it.

Regards
Sachin

Don't sit back because of failure. It will come back to check if you still available. -- Binu

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-01-04 : 06:36:23

And you can find more scripts here
www.sqldts.com

Madhivanan

Failing to plan is Planning to fail

ciaran
Starting Member

40 Posts

Posted - 2006-01-04 : 07:15:51

quote:
Originally posted by sachinsamuel

You mean to say you want to save the bas file in DTS?

If yes then find the below code in your bas file.

'goPackage.SaveToSQLServer "(local)", "sa", ""
goPackage.Execute
goPackage.Uninitialize

uncomment the line in bold and run. This will save the code in DTS format and then run it.

Thats exactly it. Thanks very much

Regards
Sachin

Don't sit back because of failure. It will come back to check if you still available. -- Binu

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-01-04 : 07:52:41

ciaran, you didnt specify anything in the above reply

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources