Implicit queries: machine

Showing posts with label machine. Show all posts

Wednesday, March 21, 2012

Import Excel Spreadsheet to SQL 7

Running SQL Server 7 and Excel 2002 on an Win XP Pro machine.
I created a database with two tables, ran a program that added some data to
both tables, then used the Data Transformation Services Export Wizard to
export the tables to an Excel workbook containing each table as a separate
spreadsheet. So far, so good.
I manually made a number of changes to the spreadsheets, altering some of
the values that had been exported, adding some more rows to one of the
spreadsheets and sorting the rows. Now when I go back to SQL Server and use
the Wizard to import the data back into the tables, not all of the data
comes back in. Of about 250+ rows in one of the tables, less than 200 of
them get imported. I don't see any errors when running the wizard. I did a
TRUNCATE TABLE in query analyzer before doing the import to clear all the
rows in each table.
Is there some kind of marker to put in the file that tells the import wizard
where to stop? For example, when printing a spreadsheet, you "set" the
print area. Is there a corresponding function to set the "import" area?
Thanks
John Schneider
When you export to Excel from SQL Server a named range is created on the
Excel worksheet. In Excel select Insert on the menu and then Name. You
should see a name in the dialog box. Click on it and update the range and
then the full data set should get imported to SQL server.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Bingo! Thanks for the reply. I NEVER would have found that setting.
John
"Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
news:cP9tbKX0EHA.764@.cpmsftngxa10.phx.gbl...
> When you export to Excel from SQL Server a named range is created on the
> Excel worksheet. In Excel select Insert on the menu and then Name. You
> should see a name in the dialog box. Click on it and update the range and
> then the full data set should get imported to SQL server.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>

Monday, March 19, 2012

Import data to sql Server 6.5

I have a datafile, Bendill.dat, from a SQL6.5 database I used to run some
time ago. The machine on which this used to run is not operational any more.
I have set up SQL Server 6.5 on a virtual machine, and want to import my old
data from Bendill.dat into this SQL6.5.
How do I do it?
When I have this running, my ultimate goal is to convert the SQL6.5 data to
SQL2000 and from there to SQL2005 (as there is no direct upgrade path from
SQL6.5 to SQL2005).
Regards,
Gudni
Gudni G. Sigurdsson (GudniGSigurdsson@.discussions.microsoft.com) writes:
> I have a datafile, Bendill.dat, from a SQL6.5 database I used to run
> some time ago. The machine on which this used to run is not operational
> any more.
> I have set up SQL Server 6.5 on a virtual machine, and want to import
> my old data from Bendill.dat into this SQL6.5.
> How do I do it?
Do you have any idea of how that file is organized? I assume that this
is a device file, such a file can have multiple databases, or even worse,
multiple fragments of databases. That is, a database can be on multiple
device files.
If you know that there is only a single database on the file, it's a
little easier, but it would still help to know what is the data and
what is the log.
I think the command to use would be DISK REINIT, but I don't think I
ever used it under all those years I ran 4.x and 6.x.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|||Tibor Karaszi (tibor_please.no.email_karaszi@.hotmail.nomail.com) writes:
> Yes, DISK REINIT which will re-create the database devices. Then DISK
> REFIT, which will create the database based on those devices. DISK
> REINIT is the tricky part since ideally you want to run it so you get a
> proper layout of data vs. log allocations.
It would really help if Gudni has the contents of syssegments from the
6.5 master database saved somewhere.
That old architecture is certainly not missed at all.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|||Hello and thanks for responses so far.
This file is a device file unfortunately rather than a backup file.
As far as I know there is only one database in this file bendill.dat and
that is the database I am interested in. And I believe this file stores the
whole database.
Later today I will try your suggestions and see how far that will get me.
"Tibor Karaszi" wrote:

> I think it is sysusages which is the one that is needed in order to get the database fragment
> layout.
>
> I couldn't agree more! :-)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Erland Sommarskog" <esquel@.sommarskog.se> wrote in message
> news:Xns99EBB6194C187Yazorman@.127.0.0.1...
>
|||Thanks both of you Karaszi and Sommarskog.
I have not been working on this problem since 11/17/2007 but I will have to
come back to it. Unfortunately, I have had no success so far. I feel I have
to get hold of SQL Server 6.5 Books Online to better understand what I am
doing and how I should go about following your propositions.
So long,
Gudni
"Tibor Karaszi" wrote:

> You should be able to do DISK REINIT and use the size of your file to calculate the size of the file
> that you specify for your DISK REINIT. Depending on the original layout, you might end up with data
> pages where SQL Server expects log records and vice versa, but that should hopefully not prohibit
> you from exporting the data.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Gudni G. Sigurdsson" <GudniGSigurdsson@.discussions.microsoft.com> wrote in message
> news:69643E74-8ABA-45A7-8FA4-F6B506A94320@.microsoft.com...
>
|||Gudni G. Sigurdsson (GudniGSigurdsson@.discussions.microsoft.com) writes:
> I have not been working on this problem since 11/17/2007 but I will have
> to come back to it. Unfortunately, I have had no success so far. I
> feel I have to get hold of SQL Server 6.5 Books Online to better
> understand what I am doing and how I should go about following your
> propositions.
Isn't Books Online installed with the 6.5 installation you have?
If you have access to MSDN Subcriber Downloads, you can get SQL 6.5
with Books Online and all there.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Import Data question using DTS

I have a database A on 1 server and database A on the 2nd machine.
I would like to export data from tableA database A from the 1 server to the
2nd machine, but I only want to export data whose date = '02/28/05'.
When I export the data using DTS, I specify that I would like to "use query
to specify the data to transfer", and I wrote the query as the following:
select * from tableA where tableA.[DateRecorded]='02/28/05' and run it. It
said that it successfully export the data.
But when I went to the 2nd machine database A table A, I do not see the data
where [DateRecorded]='02/28/05'.
How can I export data only where [DateRecorded]='02/28/05' ?
Thank you very much.Hi,
If you run your query directly against database a on server 1, are the rows
returned?
It might be a issue with string to date convertion. Try using the format
'20050228' or explicitly
convert the string to a datetime - Convert(datetime, '02/28/05', 1).
If there is a time component (ie not 00:00:00) you would need to discard
that before doing the comparison.
Or try: DateRecorded BETWEEN '20050228 00:00:00' AND '20050228 23:59:59'
Cheers
J.
"fniles" <fniles@.pfmail.com> wrote in message
news:e4p9JZoHFHA.3196@.TK2MSFTNGP15.phx.gbl...
> I have a database A on 1 server and database A on the 2nd machine.
> I would like to export data from tableA database A from the 1 server to
the
> 2nd machine, but I only want to export data whose date = '02/28/05'.
> When I export the data using DTS, I specify that I would like to "use
query
> to specify the data to transfer", and I wrote the query as the following:
> select * from tableA where tableA.[DateRecorded]='02/28/05' and run it. It
> said that it successfully export the data.
> But when I went to the 2nd machine database A table A, I do not see the
data
> where [DateRecorded]='02/28/05'.
> How can I export data only where [DateRecorded]='02/28/05' ?
> Thank you very much.
>|||If the data type for [DateRecorded] is DATETIME, try:
select * from tableA where CONVERT(VARCHAR, tableA.[DateRecorded], 101)
='02/28/2005'
"fniles" wrote:
> I have a database A on 1 server and database A on the 2nd machine.
> I would like to export data from tableA database A from the 1 server to the
> 2nd machine, but I only want to export data whose date = '02/28/05'.
> When I export the data using DTS, I specify that I would like to "use query
> to specify the data to transfer", and I wrote the query as the following:
> select * from tableA where tableA.[DateRecorded]='02/28/05' and run it. It
> said that it successfully export the data.
> But when I went to the 2nd machine database A table A, I do not see the data
> where [DateRecorded]='02/28/05'.
> How can I export data only where [DateRecorded]='02/28/05' ?
> Thank you very much.
>
>|||Thanks for the reply.
>If you run your query directly against database a on server 1, are the rows
>returned?
Yes, rows are returned when I run the query "select * from tableA where
tableA.[DateRecorded]='02/28/05'" against database A on server 1.
"J Hunter" <ms-nntp-nospam@.jshunter.co.uk> wrote in message
news:%23B2ZnfoHFHA.3628@.TK2MSFTNGP15.phx.gbl...
> Hi,
> If you run your query directly against database a on server 1, are the
> rows
> returned?
> It might be a issue with string to date convertion. Try using the format
> '20050228' or explicitly
> convert the string to a datetime - Convert(datetime, '02/28/05', 1).
> If there is a time component (ie not 00:00:00) you would need to discard
> that before doing the comparison.
> Or try: DateRecorded BETWEEN '20050228 00:00:00' AND '20050228 23:59:59'
> Cheers
> J.
>
> "fniles" <fniles@.pfmail.com> wrote in message
> news:e4p9JZoHFHA.3196@.TK2MSFTNGP15.phx.gbl...
>> I have a database A on 1 server and database A on the 2nd machine.
>> I would like to export data from tableA database A from the 1 server to
> the
>> 2nd machine, but I only want to export data whose date = '02/28/05'.
>> When I export the data using DTS, I specify that I would like to "use
> query
>> to specify the data to transfer", and I wrote the query as the following:
>> select * from tableA where tableA.[DateRecorded]='02/28/05' and run it.
>> It
>> said that it successfully export the data.
>> But when I went to the 2nd machine database A table A, I do not see the
> data
>> where [DateRecorded]='02/28/05'.
>> How can I export data only where [DateRecorded]='02/28/05' ?
>> Thank you very much.
>>
>|||Ok, could you confirm the following:
1. Your using hte DTS Import/Export Wizard
2. You set up a source
3. You set up a destination
4. You provide a query
When you define a destination - does the table exist? If yes, have to tried
letting the wizard create a new table? Do you define any transforms? Does
clicking on the preview button display the desired results?
Cheers
J.
"fniles" <fniles@.pfmail.com> wrote in message
news:O36yUsoHFHA.1996@.TK2MSFTNGP12.phx.gbl...
> Thanks for the reply.
> >If you run your query directly against database a on server 1, are the
rows
> >returned?
> Yes, rows are returned when I run the query "select * from tableA where
> tableA.[DateRecorded]='02/28/05'" against database A on server 1.
>
> "J Hunter" <ms-nntp-nospam@.jshunter.co.uk> wrote in message
> news:%23B2ZnfoHFHA.3628@.TK2MSFTNGP15.phx.gbl...
> > Hi,
> >
> > If you run your query directly against database a on server 1, are the
> > rows
> > returned?
> >
> > It might be a issue with string to date convertion. Try using the
format
> > '20050228' or explicitly
> > convert the string to a datetime - Convert(datetime, '02/28/05', 1).
> >
> > If there is a time component (ie not 00:00:00) you would need to discard
> > that before doing the comparison.
> >
> > Or try: DateRecorded BETWEEN '20050228 00:00:00' AND '20050228 23:59:59'
> >
> > Cheers
> >
> > J.
> >
> >
> > "fniles" <fniles@.pfmail.com> wrote in message
> > news:e4p9JZoHFHA.3196@.TK2MSFTNGP15.phx.gbl...
> >> I have a database A on 1 server and database A on the 2nd machine.
> >> I would like to export data from tableA database A from the 1 server to
> > the
> >> 2nd machine, but I only want to export data whose date = '02/28/05'.
> >>
> >> When I export the data using DTS, I specify that I would like to "use
> > query
> >> to specify the data to transfer", and I wrote the query as the
following:
> >> select * from tableA where tableA.[DateRecorded]='02/28/05' and run it.
> >> It
> >> said that it successfully export the data.
> >> But when I went to the 2nd machine database A table A, I do not see the
> > data
> >> where [DateRecorded]='02/28/05'.
> >>
> >> How can I export data only where [DateRecorded]='02/28/05' ?
> >>
> >> Thank you very much.
> >>
> >>
> >
> >
>|||Thanks for the reply.
> 1. Your using hte DTS Import/Export Wizard
Yes
> 2. You set up a source
Yes, database A from 1st server
> 3. You set up a destination
Yes, database A from 2nd machine
> 4. You provide a query
Yes.
select * from tableA where tableA.[DateRecorded]='02/28/05'
> When you define a destination - does the table exist?
Yes, tableA exists in both 1st server and 2nd machine
> If yes, have to tried letting the wizard create a new table?
No. Did you mean click on "Transform" and select "Create Destination Table"
>Do you define any transforms?
No
>Does clicking on the preview button display the desired results?
Yes
"J Hunter" <ms-nntp-nospam@.jshunter.co.uk> wrote in message
news:OtRcA3oHFHA.3936@.TK2MSFTNGP10.phx.gbl...
> Ok, could you confirm the following:
> 1. Your using hte DTS Import/Export Wizard
> 2. You set up a source
> 3. You set up a destination
> 4. You provide a query
> When you define a destination - does the table exist? If yes, have to
> tried
> letting the wizard create a new table? Do you define any transforms?
> Does
> clicking on the preview button display the desired results?
> Cheers
> J.
> "fniles" <fniles@.pfmail.com> wrote in message
> news:O36yUsoHFHA.1996@.TK2MSFTNGP12.phx.gbl...
>> Thanks for the reply.
>> >If you run your query directly against database a on server 1, are the
> rows
>> >returned?
>> Yes, rows are returned when I run the query "select * from tableA where
>> tableA.[DateRecorded]='02/28/05'" against database A on server 1.
>>
>> "J Hunter" <ms-nntp-nospam@.jshunter.co.uk> wrote in message
>> news:%23B2ZnfoHFHA.3628@.TK2MSFTNGP15.phx.gbl...
>> > Hi,
>> >
>> > If you run your query directly against database a on server 1, are the
>> > rows
>> > returned?
>> >
>> > It might be a issue with string to date convertion. Try using the
> format
>> > '20050228' or explicitly
>> > convert the string to a datetime - Convert(datetime, '02/28/05', 1).
>> >
>> > If there is a time component (ie not 00:00:00) you would need to
>> > discard
>> > that before doing the comparison.
>> >
>> > Or try: DateRecorded BETWEEN '20050228 00:00:00' AND '20050228
>> > 23:59:59'
>> >
>> > Cheers
>> >
>> > J.
>> >
>> >
>> > "fniles" <fniles@.pfmail.com> wrote in message
>> > news:e4p9JZoHFHA.3196@.TK2MSFTNGP15.phx.gbl...
>> >> I have a database A on 1 server and database A on the 2nd machine.
>> >> I would like to export data from tableA database A from the 1 server
>> >> to
>> > the
>> >> 2nd machine, but I only want to export data whose date = '02/28/05'.
>> >>
>> >> When I export the data using DTS, I specify that I would like to "use
>> > query
>> >> to specify the data to transfer", and I wrote the query as the
> following:
>> >> select * from tableA where tableA.[DateRecorded]='02/28/05' and run
>> >> it.
>> >> It
>> >> said that it successfully export the data.
>> >> But when I went to the 2nd machine database A table A, I do not see
>> >> the
>> > data
>> >> where [DateRecorded]='02/28/05'.
>> >>
>> >> How can I export data only where [DateRecorded]='02/28/05' ?
>> >>
>> >> Thank you very much.
>> >>
>> >>
>> >
>> >
>>
>|||It sounds like everything is configured correctly. When I refered to a
destination table I did not mean to click on the Transforms button, but just
to enter a destination table that doesn't exist DTS will do the rest.
When you execute the Export does it confirm a number of lines copied? ie
Complete (91)?
Just incase there is a problem with your select on the destination table,
could you choose a new destination that doesn't exist. Once complete do a
select * from <new table> to verify new lines have been copied.
Cheers
J.
"fniles" <fniles@.pfmail.com> wrote in message
news:u2VyfvpHFHA.2924@.TK2MSFTNGP15.phx.gbl...
> Thanks for the reply.
> > 1. Your using hte DTS Import/Export Wizard
> Yes
> > 2. You set up a source
> Yes, database A from 1st server
> > 3. You set up a destination
> Yes, database A from 2nd machine
> > 4. You provide a query
> Yes.
> select * from tableA where tableA.[DateRecorded]='02/28/05'
> > When you define a destination - does the table exist?
> Yes, tableA exists in both 1st server and 2nd machine
> > If yes, have to tried letting the wizard create a new table?
> No. Did you mean click on "Transform" and select "Create Destination
Table"
> >Do you define any transforms?
> No
> >Does clicking on the preview button display the desired results?
> Yes
>
> "J Hunter" <ms-nntp-nospam@.jshunter.co.uk> wrote in message
> news:OtRcA3oHFHA.3936@.TK2MSFTNGP10.phx.gbl...
> > Ok, could you confirm the following:
> >
> > 1. Your using hte DTS Import/Export Wizard
> > 2. You set up a source
> > 3. You set up a destination
> > 4. You provide a query
> >
> > When you define a destination - does the table exist? If yes, have to
> > tried
> > letting the wizard create a new table? Do you define any transforms?
> > Does
> > clicking on the preview button display the desired results?
> >
> > Cheers
> >
> > J.
> >
> > "fniles" <fniles@.pfmail.com> wrote in message
> > news:O36yUsoHFHA.1996@.TK2MSFTNGP12.phx.gbl...
> >> Thanks for the reply.
> >>
> >> >If you run your query directly against database a on server 1, are the
> > rows
> >> >returned?
> >> Yes, rows are returned when I run the query "select * from tableA where
> >> tableA.[DateRecorded]='02/28/05'" against database A on server 1.
> >>
> >>
> >> "J Hunter" <ms-nntp-nospam@.jshunter.co.uk> wrote in message
> >> news:%23B2ZnfoHFHA.3628@.TK2MSFTNGP15.phx.gbl...
> >> > Hi,
> >> >
> >> > If you run your query directly against database a on server 1, are
the
> >> > rows
> >> > returned?
> >> >
> >> > It might be a issue with string to date convertion. Try using the
> > format
> >> > '20050228' or explicitly
> >> > convert the string to a datetime - Convert(datetime, '02/28/05', 1).
> >> >
> >> > If there is a time component (ie not 00:00:00) you would need to
> >> > discard
> >> > that before doing the comparison.
> >> >
> >> > Or try: DateRecorded BETWEEN '20050228 00:00:00' AND '20050228
> >> > 23:59:59'
> >> >
> >> > Cheers
> >> >
> >> > J.
> >> >
> >> >
> >> > "fniles" <fniles@.pfmail.com> wrote in message
> >> > news:e4p9JZoHFHA.3196@.TK2MSFTNGP15.phx.gbl...
> >> >> I have a database A on 1 server and database A on the 2nd machine.
> >> >> I would like to export data from tableA database A from the 1 server
> >> >> to
> >> > the
> >> >> 2nd machine, but I only want to export data whose date = '02/28/05'.
> >> >>
> >> >> When I export the data using DTS, I specify that I would like to
"use
> >> > query
> >> >> to specify the data to transfer", and I wrote the query as the
> > following:
> >> >> select * from tableA where tableA.[DateRecorded]='02/28/05' and run
> >> >> it.
> >> >> It
> >> >> said that it successfully export the data.
> >> >> But when I went to the 2nd machine database A table A, I do not see
> >> >> the
> >> > data
> >> >> where [DateRecorded]='02/28/05'.
> >> >>
> >> >> How can I export data only where [DateRecorded]='02/28/05' ?
> >> >>
> >> >> Thank you very much.
> >> >>
> >> >>
> >> >
> >> >
> >>
> >>
> >
> >
>

Import Data question using DTS

Monday, March 12, 2012

Import data option not visible

Hello All,

I have created a database on my local machine using SQL Server Express 2005. I am trying to export data from an excel file into a table in this database but when i see tasks available for the database there is no option of import data like I assume there should.

Only the following options are visible.

Detach

Shrink

Back Up

Restore

Generate Scripts

Any solutions on how I can get my excel file into the table.

Kiran

Import / Export is not included in the Express edition.

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

|||

Ohh.

Then would my only option be to download a different version like SQL Server compact.

Thanks,

Kiran

|||

Kiranvukkadala wrote:

Then would my only option be to download a different version like SQL Server compact.

No, only SQL Server Standard, Developer, or Enterprise editions. Read the link John provided.

|||

Would any of these editions be free to download from Microsoft. I need only a test database on my machine which uploads tables through excel files. If there is a workaround with express edition it would be great as I already downloaded that version.

Thanks,

Kiran

|||Nope. None are free. Sorry.

The developer edition is only $50 (US) though.

Friday, March 9, 2012

Import data failed

I tried to import data from a SQL Server 2000 database in another machine to
my machine. The data is about 3 gig in size.
When copying the data, it failed with this error "[Microsoft][ODBC Sql
Server Driver][SQL Server] UPDATE STATISTICS failed because the followint
SET options have incorrect settings: 'ARITHABORT'.
What does it mean and how can I fix it ?
Thank you very much.Never mind, I fixed the problem.
I was copying from a "Simple" recovery mode database to a "Full" recovery
mode database.
I change the destination database to be "Simple" and it fixed the problem.
Thanks.
"fniles" <fniles@.pfmail.com> wrote in message
news:%23CN2L9QBHHA.2276@.TK2MSFTNGP03.phx.gbl...
>I tried to import data from a SQL Server 2000 database in another machine
>to my machine. The data is about 3 gig in size.
> When copying the data, it failed with this error "[Microsoft][ODBC Sql
> Server Driver][SQL Server] UPDATE STATISTICS failed because the followint
> SET options have incorrect settings: 'ARITHABORT'.
> What does it mean and how can I fix it ?
> Thank you very much.
>

Import data failed

I tried to import data from a SQL Server 2000 database in another machine to
my machine. The data is about 3 gig in size.
When copying the data, it failed with this error "[Microsoft][ODBC S
ql
Server Driver][SQL Server] UPDATE STATISTICS failed because the followin
t
SET options have incorrect settings: 'ARITHABORT'.
What does it mean and how can I fix it ?
Thank you very much.Never mind, I fixed the problem.
I was copying from a "Simple" recovery mode database to a "Full" recovery
mode database.
I change the destination database to be "Simple" and it fixed the problem.
Thanks.
"fniles" <fniles@.pfmail.com> wrote in message
news:%23CN2L9QBHHA.2276@.TK2MSFTNGP03.phx.gbl...
>I tried to import data from a SQL Server 2000 database in another machine
>to my machine. The data is about 3 gig in size.
> When copying the data, it failed with this error "[Microsoft][ODBC
Sql
> Server Driver][SQL Server] UPDATE STATISTICS failed because the follow
int
> SET options have incorrect settings: 'ARITHABORT'.
> What does it mean and how can I fix it ?
> Thank you very much.
>

Import data failed

I tried to import data from a SQL Server 2000 database in another machine to
my machine. The data is about 3 gig in size.
When copying the data, it failed with this error "[Microsoft][ODBC Sql
Server Driver][SQL Server] UPDATE STATISTICS failed because the followint
SET options have incorrect settings: 'ARITHABORT'.
What does it mean and how can I fix it ?
Thank you very much.
Never mind, I fixed the problem.
I was copying from a "Simple" recovery mode database to a "Full" recovery
mode database.
I change the destination database to be "Simple" and it fixed the problem.
Thanks.
"fniles" <fniles@.pfmail.com> wrote in message
news:%23CN2L9QBHHA.2276@.TK2MSFTNGP03.phx.gbl...
>I tried to import data from a SQL Server 2000 database in another machine
>to my machine. The data is about 3 gig in size.
> When copying the data, it failed with this error "[Microsoft][ODBC Sql
> Server Driver][SQL Server] UPDATE STATISTICS failed because the followint
> SET options have incorrect settings: 'ARITHABORT'.
> What does it mean and how can I fix it ?
> Thank you very much.
>

Wednesday, March 7, 2012

Import and Export Wizard throws errors when theres alot of tables

I’m trying to copy data from production to my local machine using the SQL Server 2005 import and export wizard. It works fine if I select a small number of tables but throws errors

When there’s a lot of tables. Have you ever experienced problems using it? Is there a better way to transfer the data?

the data source is SQL Server 2000 and the target is 2005. I have the optimize for many tables and transaction options selected

Here’s the errors I get

Execute the transfer with the TransferProvider. (Error)

Messages

· ERROR : errorCode=-1073451000 description=The package contains two objects with the duplicate name of "output column "ErrorCode" (49)" and "output column "ErrorCode" (14)".
helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

· ERROR : errorCode=-1073451000 description=The package contains two objects with the duplicate name of "output column "ErrorCode" (31)" and "input column "ErrorCode" (52)".
helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

Umm, do you have existing tables that have a column named, ErrorCode?|||very possible..if so what am i supposed to do to fix the problem ?|||Rename the columns in the tables... Really, not many options to do here.

I have created a Connect bug in relation to this:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=252471

You should go there and vote, with comments, to help give more weight to the bug. Also "validate" it.

Thanks,
Phil|||

Thx, Didn;t see the siginficance of the fact that the column was called ErrorCode Right awy. I've been trying to use Import and Export to load data from production 2000 to local 2005 for several days now and I'm pretty burnt out. The vote does not seem enabled at the moment I'll look at it again tomorrow

|||

Mike C wrote:

Thx, Didn;t see the siginficance of the fact that the column was called ErrorCode Right awy. I've been trying to use Import and Export to load data from production 2000 to local 2005 for several days now and I'm pretty burnt out. The vote does not seem enabled at the moment I'll look at it again tomorrow

You have to sign into Connect before you can vote.

Wednesday, March 21, 2012

Import Excel Spreadsheet to SQL 7

Monday, March 19, 2012

Import data to sql Server 6.5

Import Data question using DTS

Import Data question using DTS

Import Data question using DTS

Import Data question using DTS

Monday, March 12, 2012

Import data option not visible

Friday, March 9, 2012

Import data failed

Import data failed

Import data failed

Wednesday, March 7, 2012

Import and Export Wizard throws errors when theres alot of tables

Implicit queries

Blog Archive

About Me