Re: Help with dtsrun and dts package.

Okay...so now the package runs but the package itself has
errors. What exactly are the errors?

-Sue

On Thu, 17 Aug 2006 19:18:15 -0400, "CharlesC"
<Charles@xxxxxxxxxxxxxx> wrote:

Sue, thanks for your response. The first problem was the /S etc.. I thought
you had to specify the Server and Username.

Dtsrun now runs but I am getting errors.

'All' I want to do is to export data from an Microsoft ODBC dbase database
to MSDE.
What I have done is create an SQL database, imported the odbc dbase stuff
into it, and now I am trying to export this new SQL database to a structured
file dts package and import it into MSDE.

Is there a way that this can work? or is there an easier more direct way?

Thanks,
Charles.

"Sue Hoegemeier" <Sue_H@xxxxxxxxxxxxx> wrote in message
news:bcr8e21idcbpajoo6l88urbb89sc2e8asn@xxxxxxxxxx
You want to use the /F option instead /S /N etc and then put
in the file name with full path to the DTS structured
storage file. Something along the lines of:
dtsrun /F"C:\SomeFolder\SomePackage.dts"

-Sue

On Wed, 16 Aug 2006 17:38:18 -0400, "CharlesC"
<Charles@xxxxxxxxxxxxxx> wrote:

Hello,

I used SQL Server Enterprise Managers' Export Wizard with destination
ODBC
driver for SQL to create a dts package in the structured file format.

I entered the following dtsrun line (msde 2000 sp3)

dtsrun /S servSQL /U sa /P thepw /N db.dts

and received the errors shown.


Error: -2147217900 (80040E14); Provider Error: 1462 (37B6)
Error string: The specified DTS Package
('Name='db.dts';ID.VersionID={[not specified]}.{[not specified]}'
does
not exist.
Error source: Microsoft OLE DB Provider for SQL Server


What am I doing wrong? Any help would be appreciated.

Thank you.






.

Relevant Pages

  • Re: dtsrun - on another users computer with out installing more software on the machine
    ... Simon ... > have changed this to the server name and now its not finding the files ... Microsoft Data Transformation Services Package ... >> Your DTSRUN command refers to the SQL Server. ...
    (microsoft.public.sqlserver.dts)
  • Log Shipping & Changing Roles
    ... Create a Data Transformation Services (DTS) package to ... copy the current primary server to the current secondary ... DTSRun: Loading... ...
    (microsoft.public.sqlserver.server)
  • Re: DTSRUN privileges?
    ... DTSRun: Executing... ... Try going into Query analyzer and connect to the server as that user and see ... The DTS package is stored in the database. ...
    (comp.databases.ms-sqlserver)
  • Re: Help with dtsrun and dts package.
    ... you had to specify the Server and Username. ... Dtsrun now runs but I am getting errors. ... What I have done is create an SQL database, ... I used SQL Server Enterprise Managers' Export Wizard with destination ...
    (microsoft.public.sqlserver.odbc)
  • Re: Pass server name inn global variable dynamically!!!
    ... I am a little confused as to which Server name you want to set dynamically. ... /A - this tells me I want to set a GV inside the package. ... www.SQLDTS.com - The site for all your DTS needs. ... > exec master.dbo.xp_cmdshell @dtsrun ...
    (microsoft.public.sqlserver.dts)