Urgent DB Export Issue

Jul 23, 2005

hi everybody,
iam soory maybe my question is easy, i heard about a product that can
solve such problems, but i forgetted.

the problem:
we have several foxpro6 systems, each one with seperated DB.
Now we build a new complete DB for all systems using MS_SQL Server
2000, we need to transfer/export old Data to new DB taking all
situations such as the data for one system (SALARY system) that
working on employee table is not comaptible with other data from other
system (emplyees system) that worked on the same table employee. How
we can solve such issue using MS products or other products if
available.

thanks inadvance for any advice.

best regards

eng thaar

CNS

View 1 Replies


ADVERTISEMENT

Automating Export Using Dts (urgent)

Feb 15, 2001

i want to automate the exporting of data from an excel database to sql using dts.i don't want this to do manually.can u help me out in solving this.what are the things i have to do for this ?expecting u'r earliest reply

View 2 Replies View Related

Export To PDF In Landscape (Urgent)

Oct 12, 2007

Hello, I have a report that I am creating in sql reporting services, I want my report to be exported in landscape PDF file format. I Went to the report properties then set the width = 11 in and height 8.5.

When i export my report to a PDF file it did not display it in landscape format!

Do i need to make the report go sideways? if yes how! for example

how would i write a textbox which has the label Time sideways?

Thanks


View 4 Replies View Related

Script For Import/export URGENT!!

Jan 16, 2001

Can anyone give me an idea where I can find the equivalent SQL scripts for the GUI process(DTS) for importing or exporting any DB from a given ODBC source.
Thanks!

View 1 Replies View Related

Query Problem : Export Data : URGENT PLZ

Jun 1, 2001

Hello!

Can someone help me writting a query to export data in following fashion :

Old Structrure: I've a single table (Countries) with columns CountryID, CountryName, CityName

New Structure: I want to break this single table into two tables now (Countries) and (Cities). New Structure should be like following:

Countries Table:
- CountryID
- CountryName

Cities Table:
- CityID (Auto Generated)
- CountryID (FK from Countries)
- CityName

I would really appreciate if someone can help me to write the query which can export the Data from Countries Table to the new Cities Table.

Thanks.

View 1 Replies View Related

Using RS.EXE To Export A Report From Command Line (URGENT)

Oct 26, 2007


' File: Test.rss
Dim format as string = "Excel"
Dim fileName as String = "C:Export2.xls"
Dim reportPath as String = "/TimeByEmployee"

Public Sub Main()

' Prepare Render arguments
Dim historyID as string = Nothing
Dim deviceInfo as string = Nothing
Dim showHide as string = Nothing
Dim results() as Byte
Dim encoding as string
Dim mimeType as string = "ms-excel"
Dim warnings() AS Warning = Nothing
Dim reportHistoryParameters() As ParameterValue = Nothing
Dim streamIDs() as string = Nothing
rs.Credentials = System.Net.CredentialCache.DefaultCredentials

Dim parameters(3) As ParameterValue
parameters(0) = New ParameterValue()
parameters(0).Name = "Employee"
parameters(0).Value = " "
parameters(1) = New ParameterValue()
parameters(1).Name = "Departments"
parameters(1).Value = " "
parameters(2) = New ParameterValue()
parameters(2).Name = "Week Number"
parameters(2).Value = WeekNumber
results = rs.Render(reportPath, format, _
Nothing, Nothing, parameters, _
Nothing, Nothing, encoding, mimeType, _
reportHistoryParameters, warnings, streamIDs)

' Open a file stream and write out the report
Dim stream As FileStream = File.OpenWrite(fileName)
stream.Write(results, 0, results.Length)
stream.Close()

End Sub

'End of script



here is how i run it



rs -i RunReport.rss -s http://localhost/reportserver -v WeekNumber=90 -e mgmt2000



this is the error i get:

The value of parameter 'Parameters' is not valid. also how can i cgange this line to pdf

Dim mimeType as string = "ms-excel" i tried this but it did not

work

Dim mimeType as string = "ms-pdf"


Thanks

View 1 Replies View Related

Using RS.EXE To Export A Report From Command Line (URGENT)

Oct 26, 2007

' File: Test.rss
Dim format as string = "Excel"
Dim fileName as String = "C:Export2.xls"
Dim reportPath as String = "/TimeByEmployee"

Public Sub Main()

' Prepare Render arguments
Dim historyID as string = Nothing
Dim deviceInfo as string = Nothing
Dim showHide as string = Nothing
Dim results() as Byte
Dim encoding as string
Dim mimeType as string = "ms-excel"
Dim warnings() AS Warning = Nothing
Dim reportHistoryParameters() As ParameterValue = Nothing
Dim streamIDs() as string = Nothing
rs.Credentials = System.Net.CredentialCache.DefaultCredentials

Dim parameters(3) As ParameterValue
parameters(0) = New ParameterValue()
parameters(0).Name = "Employee"
parameters(0).Value = " "
parameters(1) = New ParameterValue()
parameters(1).Name = "Departments"
parameters(1).Value = " "
parameters(2) = New ParameterValue()
parameters(2).Name = "Week Number"
parameters(2).Value = WeekNumber
results = rs.Render(reportPath, format, _
Nothing, Nothing, parameters, _
Nothing, Nothing, encoding, mimeType, _
reportHistoryParameters, warnings, streamIDs)

' Open a file stream and write out the report
Dim stream As FileStream = File.OpenWrite(fileName)
stream.Write(results, 0, results.Length)
stream.Close()

End Sub

'End of script

here is how i run it

rs -i RunReport.rss -s http://localhost/reportserver -v WeekNumber=90 -e mgmt2000

this is the error i get:
The value of parameter 'Parameters' is not valid. also how can i cgange this line to pdf

Dim mimeType as string = "ms-excel" i tried this but it did not
work
Dim mimeType as string = "ms-pdf"
Thanks

View 1 Replies View Related

Timeout Expired -- URGENT, URGENT, URGENT!!!

Sep 27, 2000

This morning I can not connect to our SQL Server 7.0 whatever from client or server. The error message which I list below:

++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++
A connection could not be estabished to server--Timeout expired
Please verfy SQL Server is running and check your SQL Server registration properties and try again.
++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++

We use windows NT authentication. We did not do any change on NT. The SQL Server daily schedule job usally stoped at 10:00AM, but today from the Window NT Task Manager, we can see that the SQL Server is still running untill now.

Please help!!!

View 3 Replies View Related

How Can I Export Foreing Key And Primary Key With SQL2005 Management Studio/Database/Tasks/Export Data Wizard.

Jan 4, 2008

How can I Export Database with foreing Key and primary key.

Operation is that
SQL2005 Management Studio/Database/Tasks/Export Data


Before Version is SQL2000 we can Selected Copy Object and data between server and then Use Default Options click checked and Select Copy Index, Copy Foreing Primary key vs vs

But this options is not found in the SQL2005 Management Studio/Database/Tasks/Export Data wizard or I can't found it.

How can I export foreing Key and primary key with SQL2005 Management Studio/Database/Tasks/Export Data wizard.

Best Regards,

Athena.

View 1 Replies View Related

URGENT.Sql Server Does Not Recognise MAPI , Or Profile Name URGENT

Oct 26, 2000

hi, I have settup up sql mail and did the following:
1. created an E-mail account and configured Out look by creating a pop3 mail profile. tested it by sending and receiving mail, that is ook
2. I Created one domain account for MSsqlserver and Sql Agent service. both services use same account and start automatically in the control panel-services
3. I used the profile that I created in outlook to test the sql mail but got an error:
Error 22030 : A MAPI error ( error number:273) occurred: MapiLogon Ex Failed due to MAPI
Error 273: MAPI Logon Failed

I really do not know what went wrong. I followed the steps from bol and still having a problem. Am I missing something.

I do have a valid email account
I do have a valid domain account
I tested outlook using the email account and it worked. so why sql server does not recognise MAPI.

My next question, How to configure MAPI in Sql server if what I did was wrong.

View 1 Replies View Related

Urgent, Urgent !! My Sql Server Refused To Start Due To Encrypton

Mar 23, 2001

Hi, I have 2 windows 2000 server in cluster with sql server 2000 enterprise edition installed.
I have activated the Server-Requested Encryption by using the sql server network utility (Force Protocol Encryption). After this, I have stoped sql server service. But I can't start it at this moment.
The error is:
19015: The encrypton is required but no available certificat has been found.

Please help me to start sql server.

Thanks.

Michel

View 4 Replies View Related

Urgent Urgent Please.(Access SQL Pass Through Queries)

Jul 6, 2000

Hello,
I am facing a huge problem in my sql server database using access as a front end.The main problem is trying to execute queries "views" ,since they reside on sql server now,and using variables or parameters in reports and forms to filter on this query.
Ex.
how can the following be implemented using the same query but in sql server?
Access
------
SELECT MAT_Charts.YYYYMM
FROM MAT_Charts
WHERE ((([Area_Code] & "-" & [GROUP_CODE])=[Reports]![MAT_Chart_C1].[MAT_Key]))
GROUP BY MAT_Charts.YYYYMM;

It is specifically this statement in which I am interested:
[GROUP_CODE])=[Reports]![MAT_Chart_C1].[MAT_Key]))

Thank you very much for your concern.

View 2 Replies View Related

Import/Export Export Wizard

Oct 5, 2007

I'm trying to export data from a SQL Server 2005 database to a DB2 database through SSIS. However, I keep getting an error that says "Could not retrieve table list" with Invalid Conversion. SQLSTATE=07006. Does anybody have any ideas or what the problem could be?
-Kyle

View 7 Replies View Related

Export To Excel - Number Formatted Cells Export To Excel As 'General' ?

Feb 5, 2007

Anyone know why cells within a matrix that are formatted as numeric export to Excel with a cell format proprty of "General"? Cells within a table however export with an appropriate format.

Thanks

View 1 Replies View Related

BCP Export Has CHR(0) In Export File

Mar 28, 2008



Hello,

I am using BCP to export a Table to a TAB delimited file. This works great, but in some fields a NULL in the Table is being exported as a character zero in the Tab file. I confirmed this by looking at the Tab file with a Hex editor.

I am using the BCP options -T c -S.

Thanks for any ideas how to eliminate the chr(0).

Tom

View 6 Replies View Related

Scheduling(URGENT... URGENT)

Dec 20, 2000

Hi everybody,

I have a batch which needs to be run every day night at 2:00 am.I Using At command but it is not working. if u have idea, please let me know

I AM USING THE FOLLOWING COMMAND :
AT 2:00AM C:SCHED.BAT

Thanks in advance
Krishna

View 3 Replies View Related

Urgent Really Urgent Dbcc

Apr 19, 2008

hi all
its urgent really urgent
please reply soon

I am getting error in sysindexes when i run dbcc checkdb on a production db.
the error is Server: Msg 8928, Level 16, State 1, Line 1
please help me to remove this
all the options of dbcc checkdb as well as table are not helping me


thanks in advance

View 4 Replies View Related

Export To XMl

Mar 3, 2004

can abyone tell me how to export data to xml usng sql server 2000

View 2 Replies View Related

Export DTS

Apr 3, 2006

Hello,
Is it possible to export DTS to another SQL Server?

View 1 Replies View Related

DTS Export

Mar 5, 2002

I have created a DTS job that results in a very large text file. Is there a way to export to multiple (and smaller) text files?

Thanks,
rdchalker@hotmail.com

View 1 Replies View Related

DTS Export

Apr 9, 2002

I need to set up a DTS Package to export the contents of several tables to a single text file on a daily basis. This is easy enough. However, the name of the text file should change on a daily basis such that the first 4 characters of the file name should by yesterdays date as mmdd. The second 4 characters of the file name should be the end of a pay period, also in a format mmdd. Does anyone know if this can be done with DTS? Any ideas? I'm assuming I'll have to use ActiveX scripts, but with the wizard I'm forced to specifiaclly name the output text file name.

View 1 Replies View Related

EXPORT

Mar 21, 2001

hi all,
I am getting problem while importing data from excel file.
I am bale to do the same with flat files. But when i do with excel files
its throwing error : format error.
pls help me in this regard.

View 1 Replies View Related

Need Help With Export

Mar 20, 2000

I need to Export a SQL Server 7.0 database to a SQL Server 6.5 server (tables, data, users, etc.) Is there any easy way to do it? I have tried but have not had success. I'm VERY new to SQL, so the more details the better. Thanks in Advance for any help.

View 3 Replies View Related

Export Help

Jan 5, 2001

Hi there,

I've a table and i would like to export it to the another database frequently. therefore, i would like to schedule this process every end of the day. But, I do not want to export the whole table as it is a very huge one. I would like to export only the new data which has been added to the table since.

I looked at the export tool, but wasnt sure how to implement this. Would anybody put some light on this and help me with it.

Thanks,

Sindi

View 2 Replies View Related

Export To Txt

Jun 16, 2003

MS SQL 2k.

I want to export 34 tables to txt file, to make available for download via our website.

Does anyone have a script or could someone give me some hints on how to export, automated like all those tables to txt?

Thanx a bunch,
Mischa

View 3 Replies View Related

Export DBF

Sep 4, 2001

I would like to export data from table (With SELECT ... FROM) in a new Dbf File.

Do you now a methode like

SELECT FIELD1, FIELD2, ... INTO NEWTABLE FROM TOTO

but with SELECT FIELD1,FIELD2, ... INTO NEWFILE.DBF FROM TOTO

View 1 Replies View Related

Export Through DTS

Jun 8, 2004

Hi Everyone I got another problem every time I try to import data to Sql from Access 2000 it keeps give me an error message that says row 2271. Errors encountered so far in this tabel 1 insert error, column 8 (DOB, DBTYPE_DBTIMESTAMP), status 6: Data overflow. Invalid Character value for cast sepcification.

anyone got any suggestions

View 5 Replies View Related

Export To/from XML

Feb 23, 2005

I have Database with the following structure: Regions -> Countries -> Customers -> Fabs -> Products. All relationships are one to many.
I need to build query that returns all data of any Region as XML.

What is the best way to do opposite action (Export from XML to DB) ?

View 1 Replies View Related

Dts Export

Mar 1, 2004

I am trying to export all the records from 6 different tables from sql server to a text file using the DTS wizard. I want all the info of the first table to appear first, then all the info of the second table, etc.
Any ideas on how to do this type of query?
thanks in advance.

View 4 Replies View Related

Export To XML

Apr 4, 2008

Hi,

How do I export to XML file from sql server 2005?

View 2 Replies View Related

Export To Sql

May 12, 2008

Hi,
I used code

USE [AA3Dev];
GO
INSERT INTO OPENROWSET (‘Microsoft.Jet.OLEDB.4.0', ‘Excel 8.0;Database=c:contact.xls;’,
‘SELECT * FROM [Sheet1$]‘)
SELECT TOP 5 FirstName, LastName
FROM Person.Contact
GO

to export data from sql server to excel but i am getting this error

OLE DB provider “Microsoft.Jet.OLEDB.4.0? for linked server “(null)� returned message “The Microsoft Jet database engine could not find the object ‘SheetData1$’. Make sure the object exists and that you spell its name and the path name correctly.�.
Msg 7350, Level 16, State 2, Line 1

Cannot get the column information from OLE DB provider “Microsoft.Jet.OLEDB.4.0? for linked server “(null)�.

can anybody help me out to get rid of this?
Thanks!

View 2 Replies View Related

Export All My Db

Nov 16, 2006

Hello! I'm having a big problem!

I had my site in freewebdot but they cancel all accounts. The panel to mannage mssql was "sql web server admin"

With some luck, and using a script from here:
http://vyaskn.tripod.com/code.htm#inserts

I put all my online db to my local db (mssql 2000)

Then I rent a web hosting plan in www.godaddy.com but they use the same panel (sql web server admin)

I used the same query that i use to put all my db locally but somehow this query don't work in godaddy admin's panel ! :((((

I don't know whath i can do more...

I receive errors because quotes... because convert string to datetime... etc but i haven't receive this errors on my local query :(

Please... Did you know any script that create and introduce all the values from our local db TO online db ??

It could be with asp.net or something like this, but I have to resolve this! This db have all my forum database, with millions of lines...

I could not lose more time!!

Forgive the long text and my bad english!
Thank you very much!
Max

View 1 Replies View Related

Export Sql Into Xml

Feb 12, 2007

Mila writes "how to export and send xml as a string?"

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved