Re: Help with dtsrun and dts package.

Charles,
On the first error, if you have a DSN for your connections,
you need to have that on the box where the DTS package is
running. The problem is generally from having something in
the connections that you had setup on the box where you
developed the package but it is missing from the location
where the package is running.
In terms of the second error, you are importing the data
into a table named ITEMS. The task is set to create the
table. If you run the package more than once against the
database, the task is trying to create the table again but
the table already exists. You need to modify the task to
check for existence, truncate the table if needed. Or just
create another Execute SQL task to drop the table before
executing the task to populate the table.

-Sue

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

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: DTS Designer without a server.
    ... You can design your DTS package locally (if it's a SQL to SQL ... On the target server richt click Data ...
    (microsoft.public.sqlserver.dts)
  • Re: Editing an SSIS package created by Import/Export Wizard
    ... SQL 2000 and migrated to a SSIS object in SQL 2005 or did you simply ... migrate it to a legacy DTS package within SQL 2005? ... I created the SSIS package using the BIDS ...
    (microsoft.public.sqlserver)
  • Re: How to open sql 2000 DTS package in sql 7?
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > Our partner created a DTS package in sql 2000. ...
    (microsoft.public.sqlserver.dts)
  • Re: Import data from Access to SQL2005 on daily basis
    ... You can use SSIS to execute your working 2K package by using the Execute DTS 2000 Package task. ... looking to transfer data on a daily basis from an Access database to ... in SQL 2000, but do not know how to go about it in SQL 2005. ... tried importing the 2000 DTS package into 2005 with little luck. ...
    (microsoft.public.sqlserver.dts)
  • RE: Modify DTS Package from Visual Basic
    ... Sure you can change anything in the package from VB - you can even create it from scratch then run it. ... > sort of a function to automatically modify a DTS package in a given ... > SQL database. ...
    (microsoft.public.sqlserver.dts)