Re: Help with dtsrun and dts package.

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: Help with dtsrun and dts package.
    ... Okay...so now the package runs but the package itself has ... 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: Email Programming using System.Web.Mail
    ... With System.Web.Mail,, the book for the SmtpMail class says that if you do not specify a value for SmtpServer then it uses the local SMTP server. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: RCP from VMS to Unix
    ... using RCP to recursively transfer files from a VMS host to a Unix server. ... specify in the UNIX file specification. ... alp $ show default ...
    (comp.os.vms)
  • Re: SBS 2003 SP2 Memory
    ... I can use perfmon however I normally do not know what should be my baseline. ... This counter is one of the better indicators of actual pagefile usage ... Its the only server in my network and I'm running the following: ... Symantec Backup Exec (sql database) ...
    (microsoft.public.windows.server.sbs)
  • Re: Email Programming using System.Web.Mail
    ... configuration first but if that doesn't specify the appropriate ... configuration files, an exception would be thrown when you call the ... The moment I specify a valid server then it works: ... It will only connect to an 'up-line' SMTP ...
    (microsoft.public.dotnet.languages.vb)