"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:polbe2ts9aker1eh30ur13g4jdrvrv2uh0@4ax.com...
> 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@bscinforma.com> 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@nomail.please> wrote in message
> >news:ih0ae2pgt7e70g29qn2qit6dkbvfum9lsm@4ax.com...
> >> 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@bscinforma.com> 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@nomail.please> wrote in message
> >> >news:bcr8e21idcbpajoo6l88urbb89sc2e8asn@4ax.com...
> >> >> 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@bscinforma.com> 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.
> >> >> >
> >> >> >
> >> >> >
> >> >>
> >> >
> >>
> >
>

<Charles@bscinforma.com> 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@nomail.please> wrote in message
>news:polbe2ts9aker1eh30ur13g4jdrvrv2uh0@4ax.com...
>> 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@bscinforma.com> 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@nomail.please> wrote in message
>> >news:ih0ae2pgt7e70g29qn2qit6dkbvfum9lsm@4ax.com...
>> >> 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@bscinforma.com> 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@nomail.please> wrote in message
>> >> >news:bcr8e21idcbpajoo6l88urbb89sc2e8asn@4ax.com...
>> >> >> 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@bscinforma.com> 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.
>> >> >> >
>> >> >> >
>> >> >> >
>> >> >>
>> >> >
>> >>
>> >
>>
>