Hi
Can Anybody tell me the different ways of transfering data from ODBC Layer to SQL Server using C#.
I want to transfer using Threads,means by running 4 threads, I need to transfer 4 tables at a time.
Though we have SQLBulk copy Object in .NET it's not useful in multi threader env.
Can anybody help me in this.
hi all,I am trying to create a dts package to transfer data from tables in mysql server 2000 database to a db2 UDB v8.1.4 database. When I use ibmdb2 oledb driver for the destination this works fine except that rowsare committed on a row by row basis thus performance is slow. I wantto use the odbc driver but when I define it as the destination, i geterrors saying that the maximum number of rows failed has exceeded theminimum.Does anybody know what to do in order to get the transfer workingusing ibm db2 odbc as the datasource?ThanksLyn
View 2 Replies View RelatedI would like to transfer selected data from an ODBC-based table to a OLEDB-based table. However, there isn't a data flow source on the Data Flow Design screen to accomodate such an action. Please help!
View 1 Replies View RelatedHi Everybody,
On localhost this application works fine but when I put on remote server. I am getting following errors. For both localhost and server, I am using same remote sql 2000. I will appreciate any help.
Thanks,
Arif
Server Error in '/' Application.
--------------------------------------------------------------------------------
ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.]
Microsoft.Data.Odbc.OdbcConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode) +27
Microsoft.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method) +838
Microsoft.Data.Odbc.OdbcCommand.ExecuteNonQuery() +80
Calgary.venues.Page_Load(Object sender, EventArgs e) in c:inetpubwwwrootCalgarySitevenuesvenues.aspx.vb:32
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
My vendor requires data to be sent in Excel format. Some of my tables have rows over 65,536 so I need to use Excel 2007 (Max of 1,048,576). Right now my data sits in SQL 2000. I am using MS SQL Enterprise Manager 8.0 to prepare the data. Is there some kind of add on or selection I am missing to use DTS to export from SQL to Excel 2007?Thanks in advance.
View 3 Replies View RelatedI have two database(MYDB1 , MYDB2) on two different server's(SERVER1 , SERVER2) . I want to create an store procedure in MYDB1 on SERVER1 and get some data from a table of MYDB2 on SERVER2. How can i do this?
View 5 Replies View RelatedIs it possible/advisable when transfering very large amounts of data from server to server to:
trasnfer the data to a new table first
second alter new table adding indexes, defaults, ets based on original table
if it is what flow item would be used to transfer/alter the indexes and defaults?
I'm very new to ssis so the more detail you can give the better.
Thanks
Please give me a direction where to go to solve this problem...
our organization regularly pumps data from an AS/400 database (db2) to SQL Server 7 tables with the help of DTS. Some of the data transfers are straight column copy and several are ActiveX transformations. Also, we've got some of the transformations defined directly inside the select statement in the Source tab of the DTS designer. There is one stored procedure which collects and does computations with the data to put into a number of Excel reports. The strange thing is that some of the data seems to be getting corrupted somehow as it is transferred, because the resulting data in sql server is not identical to that which was transferred. We get outrageously high values for one of the columns with no apparent pattern. There are no error log entries for this, and we've already confirmed that all the transformation scripts and stored procedure functions that we've been using are correct. Would doing a server trace be of any help, and if so what should I be looking for and could you just brief me on how to start one, since I've never had the need to do one so far. Thanks for the help in advance.
we have 2 sql server 6.5 . i want to transfer the data of one to the other .both have the same database.
thank u
vineet
hi can somebody help me out on this.. is there a way to consolidate the data in different Sql Server 2005 database servers scattered at different locations into a single database without using REPLICATION.
p.s Data transfer should also be conditional and bi-directional
Ive have a website on SQL Server 2005 on my Localhost, that I need to transfer to a live test server, in MYSQL you can use dump to get the SQL script,can I do this in SQL server? If so how? if not how do I transfer the DB?
View 5 Replies View RelatedNew to sql scripting and am having a problem. I have two SQL servers:
1. Keeps track of all sales related activities.
2. I would like to use for backup and reporting of sales only.
I am wondering if there is a script that can be run to transfer only specific data from the first server to the second, and if so what is the setup and syntax.
I am looking to do something like:
insert into [database#2] [table]
* from [database#1] [table]
where database#1-table.result='Sale'
Please help...
Thanks.
I have an issue related to data migration.
We are developing a data migration tool that transfer data from the live sql server (used by customer) to another sql server.
we use SSIS packages to perform the migration. we have a engine (developed in c#) that reads the SSIS package and executes it.
Now, as the source sql server is live, it is certain to undergo changes during the data transfer operation. Changes would mostly be insert or update. After the data migration is completed the delta has to be taken care of.
I am looking for an efficient mechanism to transfer the delta from the live sql server to the target sql server.
HI,
Recently i copied data from one server to another server. Later i checked the data too. It was fine. I checked no of tables, views ,sps, users , roles and also permissions and no of records in each table.
Every thing looked fine, but my users are saying data got meshed up. I dont know why they are complainting like that? Can anyone tell me why it is happening. Did i made any mistake while copying data. i copied data using bcp.
Before that i copied structure without data using DTS.
pls tell me.
thank u.
--siva
Hi,
Which is the best way to transfer data from SQL server into Oracle?.
Thanks in Advance,
Ravi
i have an old database in foxpro. The table in foxpro now has been broken into more than tables in sql server 6.5 . how do i append the data to sql server database to the respective tables from the foxpro database.
vineet
My problem is aquisiton data with gdb extension.There is not driver of that type in DTS of SQL Server 2000.
Can anybody help??
Hi All:
I'm looking for some advice. We have multiple remote SQL Server 2005 systems at various clients that all contain the same WorkTrack database. We need to send this data on a daily basis from all of these remote servers to our main server (ChemWeb/Spindle) in our corporate office. The thing is that we need to do this over standard HTTP - no VPN connection, etc.
So I'm thinking of using SQL 2005 Web services to do such. Here's my plan (the name of the Database on the client side and server is WorkTrack, and SDP is the acronym I am using for a Spindle Data Packet which contains the data to be updated from the client)
1. Every day update a WorkTrack_SDP database on the client server that will contain all of the data from WorkTrack (name of Spindle Client Database) that has changed since the last SDP transfer. This WorkTrack_SDP database will only contain the tables from the WorkTrack database that are necessary for transfer to the ChemWeb/Spindle server
2. The WorkTrack_SDP database will have the same schema as the WorkTrack database with one additional Customer_No column in each table.
3. All of the tables in WorkTrack_SDP database will be truncated before insertion of updated data.
4. An acknowledgement of the previous SDP transfer and ChemWeb/Spindle Server update will be required before this process will proceed.
5. There will be an additional table in the Client WorkTrack database to track SDP transfers.
a. Date/Time range of updated data of each transfer
b. When the transfer was sent
c. When the transfer was completed.
6. Create SPROC’s on the ChemWeb/Spindle server to serve as SQL Endpoints (Web Services) to update/insert data from client systems to WorkTrack_SDP database on the ChemWeb/Spindle Server.
7. Create SPROC on ChemWeb/Spindle server that will transfer data from WorkTrack_SDP into WorkTrack
Any thoughts & comments are greatly appreciated.
TIA,
Ken Blum
Hello,
I am new to SQL server world.
I have a task to transfer data from excel sheet(s) to sql server.
I read I could do that using DTS.
But the problem is I have more than 1 excel files and in my table I need to get records from both the files with out duplication the data.
ex: one excel sheet conatins field 1,2,3
second sheet contains field 1,4,5,6 (now I should put data in the sql table as 1,2,3,4,5,6)
I will have to continue to do add data to this table as I get new excel sheets (the fields will remain same).
Can somebody help me with this?
If you can also give me some references for this it will be very helpful.
Thanks a lot in advance
Nicky
Hi All,
What is the best way to transfer data from a web-farm to another server for web-report?
Mirror?
Replication?
Daily Schedule job?
Other?
What are the advance and dis-advance of each type?
thanks
Hello, I like to know how to transfer current data displayed in my datagrid into a table in sql server. Any help is much appreciated.Thanks!
View 1 Replies View RelatedI have a live server running windows Nt and sql server We brought a new
backup server of higher configuration we wanted to swap the data we installed nt and sql server in the new server will a cut paste of the data directory of the live server to the backup server is sufficient or the data directory to be restored to the respective files through sql enterprise manager please do clarify me
Regards
Ramesh
When executing an inline insert into command from isqw/w the command executes perfectly. Yet when I try to create a stored procedure with exactly the same insert into statement it will not create. It does not like the database.owner.table prefix on the selected rows. Any suggestions ??
Thanks.... Tom
Hi,
I'm new to SQL server, and I would like to achieve below tasks. Kindly
provide brief guildline on how to achieve these:
1.) I have managed to schedule job in SQL server to download the access database from remote server.
2.) Second, I would like to transfer all the data from my acccess database to my SQL tables.
May I know how do I achieve my task no 2???? I believe I need to write some script (procedure) in order to achieve this.
pls advise....
Hi All,1. i want to transfer the .csv file data into sql server table, itried with the DTS but while creating DSN it not prompt to attechthe .csv file. give me the proper steps to perform the datatransfer...2. i want result of my query into excel or text file by using the sqlquery( like Select * from employee where emp_salary>10000 to 'c:emp.xls).i know the other way right click into query analyzer windowand select option result to file, but want the result by using SQLquery.....
Quote:
Hi all,
Thanks in advance,
I have to transfer data from sql express 2005 to sql mobile(.sdf).
Actually i have a sql server express 2005 (sqlee) in laptop...
and the .sdf (sqlce) handheld device (ppc) that has been connected by activesync.
Can you please make it clear for my following questions?
1. Is it possible to write a query like " insert into ....sdf select from...sqlexp...." between 2 servers...?
2. Is there any copy command like a BULKCOPY .. to insert all records to .sdf (sqlce) from sql server express?
(or)
3. Is it correct to create a smart device application (CF 2.0) to transfer data between sql express and .sdf by using active sync...?
I would appreciate your comments..
Thanks,
Kumaran A
I've got a problem:
I want to transfer data between an sql server 2005 and my pocket pc. So i've installed a sql server CE on it.
I know that i can use the merge replication but, i don't have any IIS. So, i've got to transmit data though email that have got a file attached. I Know how to email from sql server 2005. When the pocket receive that email, i don't know how to insert the data in sql ce from outlook compact. Doi have tu use SSIS , in that case how can i run the package?
thanks
Our mobile application using VS2005 with VB.net is ready and we are trying to set up the SQL CE on the server to test the remote connection procedures. Sql 2005 is based on a dedicated server and is accessed via the Web server which does not have Sql installed on it. We have installed the Sql Server Me Server Tools on the Web server and configured the Virtual directory with IIS. What we cannot get our heads around is how we link the database on the separate Sql server via the web server. When the Pda contacts the Web server via IIS we somehow need to redirect to the dedicated Sql server as it cannot be contacted outside of our network. We have been told that Sql Ce can link with an existing Sql 2005 database, how can we do this?
View 6 Replies View RelatedHi
We are planning to upgrade from sql server 7 to sql server 2000.The sql server 2000 will be installed on another server.
If we have to move back from sql server 2000 to sql server 7 (if there are any problems on sql server 2000).is there a way to do it?
Is there a way to restore the changes made on sql server 2000 to 7?
Thanks
Madhukar
Does Replication use linked server.
If not then how data will transfer from source to destination.
Note : As per my knowledge it is not backup and restore like logshipping.
Hi,
I have a Users table in Oracle database and same table (Users) in SQL Server 2000 database. I want to create a DTS Package through which I can copy the data from Oracle database to SQL Server 2000 database. This package should run automatically at mid-night daily so that if there are some entries done in Oracle database then it get copied in SQL Server 2000 database. Also is there any way to copy only those entries from Oracle database which are not present in SQL Server 2000 database. Please help me in this regard as I am new to DTS.
Thanks
Rohit
Hi all,
I have a task as creating a SSIS package to transfer all the 10 tables from a database to another. And I have used the Transfer SQL Objects Task to select a table list and let the component do the transfering.
But my problem is that the source database have bad data and some null data, so I have to find a way to transfer only 'NOT BAD' data, and remove the bad data (lost relationship) and change NULL to "N/A".
And I can't find a way to do this. Is there anyone have experiences with this problem?
Can anyone help me?
I will very appreciate you help?
Hi,
I am having one query regarding data transfer using SSIS. If we use
DTS packages for the data transfer between two databases then the source database and
destination database must be on different db servers or instances.Here, I
am talking about the DTS Packages with Distributed Transactions enabled.
I need to know that whether this constraint has been rectified with SSIS Packages or it still persists.
One more thing is that while transferring the data, can we view/insert/update source database or it is locked if the transfer is in process.
Please reply..........
Thanks and Regards,
Rajesh