Re: Help with dtsrun and dts package.

Well...it's an error on one of the connections, not sure
what else to tell you. If DSNs are the same, maybe drivers
are missing on one of the boxes.
You could try using Access as a middle piece between the two
data sources.

-Sue

On Sat, 19 Aug 2006 09:47:06 -0400, "CharlesC"
<Charles@xxxxxxxxxxxxxx> wrote:

Thanks Sue,

I dropped the tables from the database and that took care of the table
already exists message. But I still get the Source Name not found error.
The SQL server 2000 being used to create the dts package is on a different
computer than the MSDE. The dsn's are the same on both computers.

(I've also tried backing up the SQL master database and then restoring it on
the MSDE master database but the message is that you cannot restore a SQL
database to MSDE.)

Can I create a dts package without using SQL 2000 Enterprise manager? Or put
another way how can I transfer ODBC dbase data to MSDE without using SQL
2000?

Thanks,
Charles.



"Sue Hoegemeier" <Sue_H@xxxxxxxxxxxxx> wrote in message
news:polbe2ts9aker1eh30ur13g4jdrvrv2uh0@xxxxxxxxxx
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: Prevent Viewing on worksheet
    ... and run MSDE as a server. ... been on the market for what.. ... MSDE changed the friggin database market... ... i really reccomend using sql authentication.. ...
    (microsoft.public.excel)
  • Re: Help with dtsrun and dts package.
    ... I dropped the tables from the database and that took care of the table ... The SQL server 2000 being used to create the dts package is on a different ... the MSDE master database but the message is that you cannot restore a SQL ... Can I create a dts package without using SQL 2000 Enterprise manager? ...
    (microsoft.public.sqlserver.odbc)
  • DTS Package - Destination Server is now off of domain.
    ... The SQL Services were previously running as ... Now, my DTS package fails. ... - drop database DATABASENAME. ...
    (microsoft.public.sqlserver.dts)
  • DTS Package - Destination server is now off domain.
    ... The SQL Services were previously running as ... Now, my DTS package fails. ... - drop database DATABASENAME. ...
    (microsoft.public.sqlserver.security)
  • Re: SQL or Access DB
    ... database files and see your data, with access you can create a workgroup ... I have once made a deploy package for MSDE and found myself coding in C++ ... i understood that this is now much better with sql ... the reall server version. ...
    (microsoft.public.dotnet.languages.vb)