Re: Help with dtsrun and dts package.

Hi Sue,

The 2 types of errors I get are:

DTSRUN OnError: Copy data from ITCOUNT to [master].[dbo].[ITCOUNT]
Step,Error=-2147467259 (80004005);
Error String:[Microsoft][ODBC Driver Manager] Data source name not found and
no default driver specified.

and

DTSRUN OnError: Create Table [master].[dbo].[ITEMS] Step,Error=-2147217900
(80040E14);
Error String:[Microsoft][ODBC SQL Server Driver][SQL Server]There is already
an object named 'ITEMS' in the database.

Thanks, Charles.


"Sue Hoegemeier" <Sue_H@xxxxxxxxxxxxx> wrote in message
news:ih0ae2pgt7e70g29qn2qit6dkbvfum9lsm@xxxxxxxxxx
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: Access2k upsizing to SQL2k Automation
    ... Once I manually set the primary keys on two of the ... correctly against the SQL database. ... Upsize Wizard only marks some of the columns 'null'. ...
    (microsoft.public.access.conversion)
  • Re: too much OOP ?
    ... SQL database, ... You cannot say that without specifying what kind of requests are planned. ... nothing about inventory management, but in my area of interest relational ...
    (comp.object)
  • Re: Update Sql Server 2000 database from the HP3000
    ... collects those updates via ODBC every 10 or so seconds. ... essentially update the SQL database at the same time as the main ... Authorised and regulated by the Financial Services Authority. ...
    (comp.sys.hp.mpe)
  • Re: Q: Datatables, Datasets and updating
    ... I have two tables A and B in the SQL database. ... ID_A (the primary key of A) and NAME_A (a string ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Configuration & Deployment issues
    ... > to logged in a SQL Server database. ... > moment this is Windows Server 2000 and Windows XP. ... > even take the new upgrades. ... We can use our SQL database to see if the ...
    (microsoft.public.windowsxp.configuration_manage)
Loading