Monday, March 26, 2012
Export data into a script as "insert into"s
I am using a Web based front end to a SQL Server db installed at my host that only lets me import data into tables either manually (in a 'datasheet' view) or with a SQL query.
Does anybody know if I can export data from my local db as a script such as
insert into TestTable(Id, Name) values ("1", "Test1")
insert into TestTable(Id, Name) values ("2", "Test2")
.
.
.
... so that I can run this script on the Web front end and insert data into the db at my host?
Many thanks in advance.Here's a link to some stored procedures you might find useful. I think the DataAs InsCommand may be what you are looking for.
http://www.mssqlcity.com/Scripts/scrImpExp.htm|||Thanks for your help Fred.
That stored procedure mostly does the job but looks like it needs a few slight mods because some data types aren't implemented (such as text which is written out as 'None Yet')...
Export Data in a specific format
Is there a way to do that and if there is how?
Can someone please help me in explaining how to extract data to a txt file as well. Here is my SQL statement thus far:
SELECT AccountNumber, CustomerID, Sum(CheckTotal) As CKT, Sum(PSD.Quantity) as QTY, Sum(ItemPrice * PSD.Quantity) As ItPrice, Sum(FCharge) as FCharge, Sum(SCharge) as SCharge, Sum((ItemPrice * PSD.Quantity) + FrankingCharge + ServiceCharge) As Total From PSD INNER JOIN Customer ON PSD.CustomerId = Customer.ID INNER JOIN Item ON PSD.ItemId = Item.ID Where PSD.Datecreated Between '12/01/2006 01:00:00 AM' and '12/31/2006 11:00:00 AM' Group By AccountNumber
ThanksWhat language are you using to do this?|||If you don't need to incorporate the export/import functionality in application - use Data Transformation Services (DTS).|||Guys,
I was away for the holiday, Sorry.
The language I am using is VB.
I am not familiar with DTS. Can you explain how that works please.
Thanks!!|||See here: data transformation services|||create a view (based on your query + include some more where condition to eliminate zeros & spaces) and then directly insert it to the new table.
like,
insert into ...(finance. table)
select ...
from (new view)|||use OSQL command line utility to get all the result in a txt file.
open command prompt and type OSQL /? for more options|||That sounds great, but as I am new to VB I might need some help on how to call that through vb. Any Ideas?
EXPORT Data From TXT FILE TO SQL SERVER
how can i export from sql sever table data to another text or csv file thorugh sql server stored procedure..import is working fine...
can u give me a solution ..
Thanks and Regards
ArulThere are ways to run though the File I/O in a stored procedure, but do you really want your sql server to have that type of file security abilities?
I'd suggest either doing through code, or running a loop that sets a file to become that text file. And blob that.
there's also DTS Capabilities that you can use.
Books Online is your best friend. Remember that.
Export data from SQL Server 2005 Express to Access Database?
We have successfully completed the project for the programmer in our team. Life was good.
Someone told me that I can use SQL Server 2000 instance to export SQL Server 2005.
I tried and cannot be done. Instance in SQL Server 2000 can't find instance in SQL 2005 Express.
:angel:
export data
A have a simple task:
I want to export a table from my sql server 2005 into a excelsheet. If I use the Sql Server import and Export wizard. I perform this task from a local installation of enterprise manger.
I keep getting the same error:
"The product level is insufficient for component"
At first I tought it might be a problem with not having the latest service pack on the sql server. So I updated to service pack 1 and updated so all the patches were uptodate on the server and my local machine.
Still no result.
I did discover that if I run the wizard on the enterprise manager installed on the server itself it works fine.
My question is what can it be that is causing the problems on my local machine ?
(on normal pc with windows xp and updated with the latest patches etc)
See if anything here helps:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=112469&SiteID=1
Steve Kass
Drew University
http://www.stevekass.com
Marcel v S@.discussions.microsoft.com wrote: > A have a simple task: > > I want to export a table from my sql server 2005 into a excelsheet. If I > use the Sql Server import and Export wizard. I perform this task from a > local installation of enterprise manger. > > I keep getting the same error: > "The product level is insufficient for component" > > At first I tought it might be a problem with not having the latest > service pack on the sql server. So I updated to service pack 1 and > updated so all the patches were uptodate on the server and my local > machine. > > Still no result. > > I did discover that if I run the wizard on the enterprise manager > installed on the server itself it works fine. > > My question is what can it be that is causing the problems on my local > machine ? > > (on normal pc with windows xp and updated with the latest patches etc) > > > > > > > > >
|||What SKU of SQL Server are you using?
SQL Server 2005 Developer Edition
SQL Server 2005 Enterprise Edition
SQL Server 2005 Standard Edition
SQL Server 2005 Workgroup Edition
SQL Server 2005 Express Edition
If this is not a mission critical machine, you should consider installing Service Pack 2 - November CTP.
Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/
This is a common issue that has multiple potential causes. Please refer to this blog post for more information:
http://blogs.msdn.com/michen/archive/2006/11/11/ssis-product-level-is-insufficient.aspx
Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/
export data
A have a simple task:
I want to export a table from my sql server 2005 into a excelsheet. If I use the Sql Server import and Export wizard. I perform this task from a local installation of enterprise manger.
I keep getting the same error:
"The product level is insufficient for component"
At first I tought it might be a problem with not having the latest service pack on the sql server. So I updated to service pack 1 and updated so all the patches were uptodate on the server and my local machine.
Still no result.
I did discover that if I run the wizard on the enterprise manager installed on the server itself it works fine.
My question is what can it be that is causing the problems on my local machine ?
(on normal pc with windows xp and updated with the latest patches etc)
See if anything here helps:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=112469&SiteID=1
Steve Kass
Drew University
http://www.stevekass.com
Marcel v S@.discussions.microsoft.com wrote: > A have a simple task: > > I want to export a table from my sql server 2005 into a excelsheet. If I > use the Sql Server import and Export wizard. I perform this task from a > local installation of enterprise manger. > > I keep getting the same error: > "The product level is insufficient for component" > > At first I tought it might be a problem with not having the latest > service pack on the sql server. So I updated to service pack 1 and > updated so all the patches were uptodate on the server and my local > machine. > > Still no result. > > I did discover that if I run the wizard on the enterprise manager > installed on the server itself it works fine. > > My question is what can it be that is causing the problems on my local > machine ? > > (on normal pc with windows xp and updated with the latest patches etc) > > > > > > > > >
|||What SKU of SQL Server are you using?
SQL Server 2005 Developer Edition
SQL Server 2005 Enterprise Edition
SQL Server 2005 Standard Edition
SQL Server 2005 Workgroup Edition
SQL Server 2005 Express Edition
If this is not a mission critical machine, you should consider installing Service Pack 2 - November CTP.
Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/
This is a common issue that has multiple potential causes. Please refer to this blog post for more information:
http://blogs.msdn.com/michen/archive/2006/11/11/ssis-product-level-is-insufficient.aspx
Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/
Friday, March 23, 2012
Export Column Import Column in SSIS
HI FOCKS,
i want to know the use of Export Column & Import Column in SSIS
please give me the example
regards
koti
They are used to move files into and out of columns in the data flow.
Export code procedure
again in to the database, but this in the commandline.
Thanks,
Carlos DokiHello Carlos,
The following script gives you the text of a given stored procedure.
--
MyScript.vb
--
dim cn
dim StoredProcedureLines
set cn=CreateObject("ADODB.Connection")
cn.open "Provider=SQLOLEDB;Data Source=.\SQLEXPRESS;Initial
Catalog=TEST;Integrated Security=SSPI"
set StoredProcedureLines=cn.execute("sp_helptext 'MyStoredProcedure'")
while not StoredProcedureLines.eof
WScript.Echo(StoredProcedureLines(0))
StoredProcedureLines.MoveNext
wend
You just need to alter the text and execute the new DROP PROCEDURE / CREATE
PROCEDURE statement. You can save this script as MyScript.vb and execute it
from the command line:
C:\>CSCRIPT MyScript.vb
I hope it helps you...
Best regards.
Elyo Ravuna
"carlosdoki@.gmail.com" wrote:
> I'd like to export code the procedure and alter the code and import
> again in to the database, but this in the commandline.
>
> Thanks,
>
> Carlos Doki
>
Export and Import table from or to text file
Do you guys have any idea?
I want to export my table to a text file
and import a text file to a table
Thanks a lot!!!for export, you can use sqlplus and spool the result in a file or write pl/sql proc with utl_file to write a file
for importing a text file, use sql*loader utility
hope this help you
Originally posted by lawbenny
Hello all,
Do you guys have any idea?
I want to export my table to a text file
and import a text file to a table
Thanks a lot!!!sql
Export and Import of SSIS packages
Hello All,
Is there a way to completely export an SSIS package (the package, the configuration and the SQL Agent settings).
And a way to import it into another computer running SSIS.
If yes, then can this be done by means of a script?
regards,
Abhishek.
BOL has some topics covering that:
http://msdn2.microsoft.com/en-us/library/ms141034.aspx
http://msdn2.microsoft.com/en-us/library/ms141772.aspx
Additionally, If your are using file based packages (.dtsx); whatever method you choose that can copy the package files and configuration files (if used) will work.
Export and Import Database from Sql 2000 to Sql 2005
Need help exporting a database from Sql 2000 Exterprise and Import it to Sql 2005 using Sql Developer.
I have tried to do a detach - copy mdf & ldf to new syatem and then do an attach - This doesn't seem to work
Also tried backup on 2000 and then Resore on 2005. This doe not seem to work.
Source system is 64bit and destination system is 32bit
Not 100% certain but the problem is probably with the 64bit to 32bit conversion problem. The binary files are probably incompatible.
Try and straight db copy Management Studio by right clicking the on the database | Tasks | Copy DB. Make sure not use the detach and re-attach method.
export an import data. How?
Hi every body
I have 2 databases called Tax and News
There is a table in database Tax called table table1(id, Title,Content)
There is a table in database News called table table2(id, Headline,Body)
How can I copy(append) data from table1 to table2 with mapping Title -> Headline and Content -> Body
Any answers would be appreciated.
INSERT INTO table2(id, Headline, Body)
SELECT id, Title, Contents
FROM table1
(WHERE...) <-- Maybe you don't need this, if you want to insert all values.
Hope this works. If not, please write back...
|||Himartinhn
I mean two tables from two differences database (Tax db and News db).
how can I do that?
|||
a4nsd:
I mean two tables from two differences database (Tax db and News db).
INSERT INTONews.dbo.table2(id, Headline, Body)
SELECT id, Title, Contents
FROMTax.dbo.table1
hope it helps./.
|||Yes exactly. When you prefix the DB-name, remember the dbo...
|||Hikaushalparik27
Thanks a lot in your answer.
But I can not copy unicode characters. Why?And how to resolve it?
|||
a4nsd:
But I can not copy unicode characters. Why?And how to resolve it?
i am not clear... i mean are you getting any error.. if yes, then which one ?
|||
I mean all data in the table1 are unicode characters,but when I copy to table2, I lost all the format
This is one of my record example.
in table1.title ='M? thêm ?i?m thu l? phà tr??c b?';
when I copy it into table2.(mapping title->Headline) It became table2.Headline = "M? thêm di?m thu l? phà tru?c b?";
How to solve it?Thanks
|||
a4nsd:
This is one of my record example.
in table1.title ='M? thêm ?i?m thu l? phà tr??c b?';
when I copy it into table2.(mapping title->Headline) It became table2.Headline = "M? thêm di?m thu l? phà tru?c b?";
just one silly question..
are you sure about the datatype for table2.Headline... (i mean it should be same as table1.title)...
hi
Yes, they are the same type.(nvarchar).how?
|||Hi
I've found out the solution by adding N before each field.
sqlexport all tables in a db without the data
data.. to later import them elsewhere, with MSSQL7.
Preferably, without having to use the Enterprise Manager -- but even
that would be fine.
ThanksJoe,
A number of options:
http://www.karaszi.com/sqlserver/in...rate_script.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Joe Green" <the_3_project@.yahoo.com> wrote in message news:a5b86892.0403310456.b234473@.pos
ting.google.com...
> How can I export all the tables in a given database, without the
> data.. to later import them elsewhere, with MSSQL7.
> Preferably, without having to use the Enterprise Manager -- but even
> that would be fine.
> Thanks|||Hi,
Use the below store procedure using SQL DMO to script out tables from a
database.
CREATE PROC GenerateScript (
@.server varchar(30) = null,
@.uname varchar(30) = null,
@.pwd varchar(30) = null,
@.dbname varchar(30) = null,
@.filename varchar(200) = 'c:\script.sql'
)
AS
DECLARE @.object int
DECLARE @.hr int
DECLARE @.return varchar(200)
DECLARE @.exec_str varchar(200)
DECLARE @.tbname varchar(30)
SET NOCOUNT ON
-- Sets the server to the local server
IF @.server is NULL
SELECT @.server = @.@.servername
-- Sets the database to the current database
IF @.dbname is NULL
SELECT @.dbname = db_name()
-- Sets the username to the current user name
IF @.uname is NULL
SELECT @.uname = SYSTEM_USER
-- Create an object that points to the SQL Server
EXEC @.hr = sp_OACreate 'SQLDMO.SQLServer', @.object OUT
IF @.hr <> 0
BEGIN
PRINT "error create SQLOLE.SQLServer"
RETURN
END
-- Connect to the SQL Server
IF @.pwd is NULL
BEGIN
EXEC @.hr = sp_OAMethod @.object, 'Connect', NULL, @.server, @.uname
IF @.hr <> 0
BEGIN
PRINT "error Connect"
RETURN
END
END
ELSE
BEGIN
EXEC @.hr = sp_OAMethod @.object, 'Connect', NULL, @.server, @.uname, @.pwd
IF @.hr <> 0
BEGIN
PRINT "error Connect"
RETURN
END
END
-- Verify the connection
EXEC @.hr = sp_OAMethod @.object, 'VerifyConnection', @.return OUT
IF @.hr <> 0
BEGIN
PRINT "error VerifyConnection"
RETURN
END
SET @.exec_str = "DECLARE script_cursor CURSOR FOR SELECT name FROM " +
@.dbname + "..sysobjects WHERE type = 'U' ORDER BY Name"
EXEC (@.exec_str)
OPEN script_cursor
FETCH NEXT FROM script_cursor INTO @.tbname
WHILE (@.@.fetch_status <> -1)
BEGIN
SET @.exec_str = 'Databases("'+ @.dbname
+'").Tables("'+RTRIM(UPPER(@.tbname))+'").Script(74077,"'+ @.filename +'")'
EXEC @.hr = sp_OAMethod @.object, @.exec_str, @.return OUT
IF @.hr <> 0
BEGIN
PRINT "error Script"
RETURN
END
FETCH NEXT FROM script_cursor INTO @.tbname
END
CLOSE script_cursor
DEALLOCATE script_cursor
-- Destroy the object
EXEC @.hr = sp_OADestroy @.object
IF @.hr <> 0
BEGIN
PRINT "error destroy object"
RETURN
END
How to execute
EXEC GenerateScript @.server = 'Server_name',
@.uname = 'sa',
@.pwd = 'password',
@.dbname = 'msdb',
@.filename = 'c:\a266uss.sql'
Thanks
Hari
MCDBA
"Joe Green" <the_3_project@.yahoo.com> wrote in message
news:a5b86892.0403310456.b234473@.posting.google.com...
> How can I export all the tables in a given database, without the
> data.. to later import them elsewhere, with MSSQL7.
> Preferably, without having to use the Enterprise Manager -- but even
> that would be fine.
> Thanks
Export Access Memo field to SQL Text field
Hi,
Can anyone point me any solution how to export a MEMO field from an Access database to a TEXT field from an MS SQL Server 2000. The import export tool from SQL server doesn't import these fields if they are very large - around 9000 characters.
Thanks.
You can use the TEXTCOPY utility in SQL Server 2000. You can find it in the BINN directory of the server instance. This is a DBLIB utility to import a single text/ntext/image value into a row. You can also use BCP to import the data.Wednesday, March 21, 2012
Export / Import Aggregations
Hello,
Is there a way to export / import the partition aggregations ?
The thing is - I ran the usage base optimization (+ using a bit of SP2 AggMgr.exe), but everytime I change the cube and redeploy, it overrides the aggregations and i have to rerun the usage base optimizer.
Thanks,
Haggai
What exactly do you intend import or export: aggregation design object or physical aggregation?
I don't know if there is a tool to export/import aggregations but if it exists I think it would be very dangerous because aggregations strictly depend from metadata.
When you say "everytime I change my cube" what does it means? Probably that something changed in your metadata so AS have to overrides aggregations.
Anyway like any other object aggregation can be defined using DDL so you can try to look at yours .partitions file.
|||Good question.
I dont know of any automated tool or way of adding aggregation desing into a measure group. Though I can see someone enhancing AggregationManager sample application to allow for loading aggregation design stored in file. Or copying aggregation design from one measure group to another. I might have some time doing that :)
As for now, the easiest way would be to create a XMLA script of your old measure group and save only AggregationDesign object part of it in the separate file. Then create XMLA script of new measure group and add AggregationDesing object to it.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Based on your answer - I Altered my new measure group and pasted the old AggregationDesigns object. It works fine.
Export / Import Aggregations
Hello,
Is there a way to export / import the partition aggregations ?
The thing is - I ran the usage base optimization (+ using a bit of SP2 AggMgr.exe), but everytime I change the cube and redeploy, it overrides the aggregations and i have to rerun the usage base optimizer.
Thanks,
Haggai
What exactly do you intend import or export: aggregation design object or physical aggregation?
I don't know if there is a tool to export/import aggregations but if it exists I think it would be very dangerous because aggregations strictly depend from metadata.
When you say "everytime I change my cube" what does it means? Probably that something changed in your metadata so AS have to overrides aggregations.
Anyway like any other object aggregation can be defined using DDL so you can try to look at yours .partitions file.
|||Good question.
I dont know of any automated tool or way of adding aggregation desing into a measure group. Though I can see someone enhancing AggregationManager sample application to allow for loading aggregation design stored in file. Or copying aggregation design from one measure group to another. I might have some time doing that :)
As for now, the easiest way would be to create a XMLA script of your old measure group and save only AggregationDesign object part of it in the separate file. Then create XMLA script of new measure group and add AggregationDesing object to it.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Based on your answer - I Altered my new measure group and pasted the old AggregationDesigns object. It works fine.
export (from mdb)-> import (to MS Sql server)
In database MyDB.mdb I have table for example: ORDERS with colums:
- Id int
- Name varchar(20)
Also I create same table in SQL Server 2k.
I can manualy export this data from mdb database to SQL Server. But I want
to make this more automatic.
Is is possible? To import automaticaly data from mdb format to table in SQL
Server 2000?
please, help me :)
best regards
Piotr Leib
ps.
sorry for my terrible english language"BUSHII" <piotrl@.robcom.com.pl> wrote in message news:<cd3vki$6pk$1@.nemesis.news.tpi.pl>...
> I have big problem.
> In database MyDB.mdb I have table for example: ORDERS with colums:
> - Id int
> - Name varchar(20)
> Also I create same table in SQL Server 2k.
> I can manualy export this data from mdb database to SQL Server. But I want
> to make this more automatic.
> Is is possible? To import automaticaly data from mdb format to table in SQL
> Server 2000?
> please, help me :)
> best regards
> Piotr Leib
> ps.
> sorry for my terrible english language
Have you looked at DTS? It can move data directly between different
data sources. To get started quickly, you can use the "Import and
Export Data" option in the start menu. Another possibility is to
create a linked server from MSSQL to the Access DB, and then simply
INSERT...SELECT... directly - see "Linked Servers" in Books Online.
Finally, if you can export to a flat file from Access, then you can
import that file with bcp.exe or DTS.
Simon|||I just create an ODBC connection to this database server and MS Access can
export directly to ODBC. It even will create the tables for you.
Oscar...
"BUSHII" <piotrl@.robcom.com.pl> wrote in message
news:cd3vki$6pk$1@.nemesis.news.tpi.pl...
> I have big problem.
> In database MyDB.mdb I have table for example: ORDERS with colums:
> - Id int
> - Name varchar(20)
> Also I create same table in SQL Server 2k.
> I can manualy export this data from mdb database to SQL Server. But I want
> to make this more automatic.
> Is is possible? To import automaticaly data from mdb format to table in
SQL
> Server 2000?
> please, help me :)
> best regards
> Piotr Leib
> ps.
> sorry for my terrible english language
Export & import DTS Packages
I have a problem with exporting and importing a DTS package from one
server to an other.
Saving a package like a VB-file is an option I have seen, but how can I
import a VB-file on the new server. Do I need a separate program?
Is there a possibility like exporting and importing a Job (Create SQL
script and run it in the Query analyser)?
Thanks,
Hans
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!How about using our utility
Transferring DTS Packages
(http://www.sqldts.com/Default.aspx?204)
--
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Hans de Korte" <hans.de.korte@.prominent.nl> wrote in message
news:4097b18e$0$206$75868355@.news.frii.net...
> Hello,
> I have a problem with exporting and importing a DTS package from one
> server to an other.
> Saving a package like a VB-file is an option I have seen, but how can I
> import a VB-file on the new server. Do I need a separate program?
> Is there a possibility like exporting and importing a Job (Create SQL
> script and run it in the Query analyser)?
> Thanks,
> Hans
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!|||Thanks, it's succeeded
Hans
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!sql
Export & import DTS Packages
I have a problem with exporting and importing a DTS package from one
server to an other.
Saving a package like a VB-file is an option I have seen, but how can I
import a VB-file on the new server. Do I need a separate program?
Is there a possibility like exporting and importing a Job (Create SQL
script and run it in the Query analyser)?
Thanks,
Hans
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!How about using our utility
Transferring DTS Packages
(http://www.sqldts.com/Default.aspx?204)
--
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Hans de Korte" <hans.de.korte@.prominent.nl> wrote in message
news:4097b18e$0$206$75868355@.news.frii.net...
> Hello,
> I have a problem with exporting and importing a DTS package from one
> server to an other.
> Saving a package like a VB-file is an option I have seen, but how can I
> import a VB-file on the new server. Do I need a separate program?
> Is there a possibility like exporting and importing a Job (Create SQL
> script and run it in the Query analyser)?
> Thanks,
> Hans
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
Export - Import Failing on One Table
I used the SQL Enterprise Manager to export the database, several
times successfully, between two nodes. During the last two attemps,
the largest table (called item) does not import the data only the
table definition.
There is a item$ table that looks like it's twice the size of the item
table, but that data doesn't apprear complete either based upon some
queries.
Any suggestions?
Also, the application is Microsoft RMS. These backup files are in a
..bck format. Can SQL Enterprise Manager restore this type of file
directly?
Jerry
hi Jerry,
"Jerry Penna" <jerrypenna@.msn.com> ha scritto nel messaggio
news:3ac97809.0410050853.5b78f3a3@.posting.google.c om
> Also, the application is Microsoft RMS. These backup files are in a
> .bck format. Can SQL Enterprise Manager restore this type of file
> directly?
you can perhaps have a test using RESTORE LABELONLY syntax to verify the
xx.Bck file IS a SQL Server backup, like explained in
http://msdn.microsoft.com/library/de...ra-rz_6hkp.asp
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks Andrea, I'll try your recommendation ~ nice to hear from Italy!
My grandfather/grandmothers homeland (Penna).
I found errors in the import, many similar to this..
"Error at destination for Row Number 33. Errors encountered so far in
this task 1. Unspecified error".
This occurred during the copy data using the step table in about 8
tables out of 30 to 40 tables.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message news:<2sg22pF1l010eU1@.uni-berlin.de>...
> hi Jerry,
> "Jerry Penna" <jerrypenna@.msn.com> ha scritto nel messaggio
> news:3ac97809.0410050853.5b78f3a3@.posting.google.c om
> you can perhaps have a test using RESTORE LABELONLY syntax to verify the
> xx.Bck file IS a SQL Server backup, like explained in
> http://msdn.microsoft.com/library/de...ra-rz_6hkp.asp
|||hi Jerry,
"Jerry Penna" <jerrypenna@.msn.com> ha scritto nel messaggio
news:3ac97809.0410051757.75ce90e4@.posting.google.c om
> Thanks Andrea, I'll try your recommendation ~ nice to hear from Italy!
> My grandfather/grandmothers homeland (Penna).
=;-D
> I found errors in the import, many similar to this..
> "Error at destination for Row Number 33. Errors encountered so far in
> this task 1. Unspecified error".
> This occurred during the copy data using the step table in about 8
> tables out of 30 to 40 tables.
it's actually very difficult to give an advice in this situation... if you
can verify the table causing problems you can eventually check the data
stored in it and possibly perform a DBCC CHECKTABLE on it...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply