Re: Can I export all packages to VB files?

#1

Unfortunatley the option is not in the object model.

You may be able to loop through your packages in VB amd call the scripting
utility on the SQL Server 7 CD to do this for you.

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Jim" <james_peppercorn (AT) storagetek (DOT) com> wrote

Quote:

I want to export about 30 packages from an SQL 2000 server
to VB (.bas) files, without having to open each package
individually and choosing 'save as' VB file. I would want
only the latest version. Can this be done programatically?

Thanks,

Jim
james_peppercorn (AT) storagetek (DOT) com

#2

I have SQL Server 2000. IS this scripting utility
included with it, as well?

Jim

Quote:

-----Original Message-----
Unfortunatley the option is not in the object model.

You may be able to loop through your packages in VB amd
call the scripting
utility on the SQL Server 7 CD to do this for you.

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Jim" <james_peppercorn (AT) storagetek (DOT) com> wrote in message
news:039a01c35b92$37bf42a0$a401280a (AT) phx (DOT) gbl...
I want to export about 30 packages from an SQL 2000
server
to VB (.bas) files, without having to open each package
individually and choosing 'save as' VB file. I would
want
only the latest version. Can this be done
programatically?

Thanks,

Jim
james_peppercorn (AT) storagetek (DOT) com

.

#3

I have never checked on the 2000 CD but it might be. If not you can grab
the 7 version from the 7 CD and use that. I am not too sure though if it
handles the new tasks in 2000. Again I have rarely used the product but it
did help me out a few times when we were on 7.

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Jim" <james_peppercorn (AT) storagetek (DOT) com> wrote

Quote:

I have SQL Server 2000. IS this scripting utility
included with it, as well?

Jim

-----Original Message-----
Unfortunatley the option is not in the object model.

You may be able to loop through your packages in VB amd
call the scripting
utility on the SQL Server 7 CD to do this for you.

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Jim" <james_peppercorn (AT) storagetek (DOT) com> wrote in message
news:039a01c35b92$37bf42a0$a401280a (AT) phx (DOT) gbl...
I want to export about 30 packages from an SQL 2000
server
to VB (.bas) files, without having to open each package
individually and choosing 'save as' VB file. I would
want
only the latest version. Can this be done
programatically?

Thanks,

Jim
james_peppercorn (AT) storagetek (DOT) com

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Can I export all packages to VB files?

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: Can I export all packages to VB files? - 08-06-2003 , 01:24 AM

Re: Can I export all packages to VB files? - 08-06-2003 , 02:15 PM

Re: Can I export all packages to VB files? - 08-07-2003 , 01:14 AM