Wrox Home  
Search P2P Archive for: Go

  Return to Index  

sql_language thread: RE:


Message #1 by Gittens Andy <andy.gittens@m...> on Wed, 1 Aug 2001 08:38:33 +0100
SQL Server doesn't understand .bas files. That type of file is provided in
case you want to integrate your package in a VB project. You want to save
your package as a COM file, which can either be loaded into the destination
SQL Server through Enterprise Manager or can be run directly using the
DTSRUN command line utility.

HTH,

Darin Strait, MS SQL Server Development and Administration
http://home.earthlink.net/~dstrait/professional/resume.htm


----- Original Message -----
From: "Clifton Dunaway" <csdunaway@y...>
To: "sql language" <sql_language@p...>
Sent: Wednesday, August 01, 2001 6:40 AM
Subject: [sql_language] RE:


> I've exported the DTS package to a .bas file, but I still don't know how
to
> open it in the destination SQL Server. Can you explain this?
>
>
> --- Gittens Andy <andy.gittens@m...> wrote:
> > Save The package as a file or vb script . bas ,copy then go to dts and
open
> > package  select file then it will open on the new server
> >
> >
> > -----Original Message-----
> > From: sql language digest [mailto:sql_language@p...]
> > Sent: 01 August 2001 00:03
> > To: sql_language digest recipients
> > Subject: sql_language digest: July 31, 2001
> >
> > SQL_LANGUAGE Digest for Tuesday, July 31, 2001.
> >
> > 1.
> >
> > ----------------------------------------------------------------------
> >
> > Subject:
> > From: Clifton Dunaway <csdunaway@y...>
> > Date: Tue, 31 Jul 2001 05:30:36 -0700 (PDT)
> > X-Message-Number: 1
> >
> > I am developing a DTS package for another company. I need to know an
easy
> > way to set it up on their server. We both use SQL Server 2000.
Currently,
> > the only way I know is to do a ' Save As' to my laptop ( which has SQL
> > Server 2000 loaded), then connect the laptop to their network, open the
> > DTS package, and do a 'Save As' on their server. There must be an easier
> > way.
>

  Return to Index