Transform data from DB on sql server 2000 to another on sql server 2005?

SQL Server Integration Services

Index ‹ SQL Server

- Previous
  - 1
    - Cascade Issue By: IT In: microsoft. public. sqlserver. programming I have 2 tables A and Table B respectively: Table A: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aa]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[aa]( [aa1] [int] NOT NULL, [aa2] [int] NULL, [aa3] [int] NULL, CONSTRAINT [PK_aa] PRIMARY KEY CLUSTERED ( [aa1] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END Table B: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[bb]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[bb]( [bb1] [int] NOT NULL, [bb2] [int] NOT NULL, [bb3] [int] NOT NULL, CONSTRAINT [PK_bb] PRIMARY KEY CLUSTERED ( [bb1] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_bb_aa]') AND parent_object_id = OBJECT_ID(N'[dbo].[bb]')) ALTER TABLE [dbo].[bb] WITH CHECK ADD CONSTRAINT [FK_bb_aa] FOREIGN KEY([bb2]) REFERENCES [dbo].[aa] ([aa1]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[bb] CHECK CONSTRAINT [FK_bb_aa] IF NOT EXISTS (SELECT * FROM SYS.FOREIGN_KEYS WHERE OBJECT_ID = OBJECT_ID(N'[DBO].[FK_BB_AA1]') AND PARENT_OBJECT_ID = OBJECT_ID(N'[DBO].[BB]')) ALTER TABLE [DBO].[BB] WITH CHECK ADD CONSTRAINT [FK_BB_AA1] FOREIGN KEY([BB3]) REFERENCES [DBO].[AA] ([AA1]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [DBO].[BB] CHECK CONSTRAINT [FK_BB_AA1] creating FK_BB_AA1 fails with the following error: Msg 1785, Level 16, State 0, Line 3 Introducing FOREIGN KEY constraint 'FK_bb_aa1' on table 'bb' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints. Msg 1750, Level 16, State 0, Line 3 Could not create constraint. See previous errors. Msg 4917, Level 16, State 0, Line 1 Constraint 'FK_bb_aa1' does not exist. Msg 4916, Level 16, State 0, Line 1 Could not enable or disable the constraint. See previous errors. How to get this working. Tag: Transform data from DB on sql server 2000 to another on sql server 2005?
  - 2
    - The same element in all pages. Hello : I have a report with several pages, I want poster the same element in all pages, it is what the solution or the property for that Thank you very much. Tag: Transform data from DB on sql server 2000 to another on sql server 2005?
  - 3
    - [DBNETLIB][ConnectionWrite (send()).] General network error. Occurs when SQL times out on new Windows 2003 sp2 server We just replaced an older Windows 2000 sp4 server with a new Window 2003 Standard Edition sp2 server to run our batch processing. We noticed that when the SQL command times out we now get the following error in the ADO command object error collection. [DBNETLIB][ConnectionWrite (send()).] General network error. Check you network documentation. Native Error: 11 SQL State: HY018 msado15.dll version 2.82.3959 is on this server. On other servers running Windows 2003 Enterprise Edition sp1 the error on the ADO command object is normal with. Timeout expired Native Error: 0 SQL State: HYT00 msado15.dll version 2.82.1830 is on this server. The SQL server they are talking to is on the other side of a firewall. It is SQL 2005 sp2 running on Windows 2000 sp4. I have also tested this on a Windows 2003 sp2 server that doesn't have to cross a firewall and get the correct Timeout error. It also has the same version of msado15.dll as problem server. The application is a collection of VB6 Components that are running in COM+ applications. I have isolated the test application to our one SQL interface component and have build a test vbs that can reproduce this on demand. The VB6 Components were not modified in any way for this change and have been working fine for many years prior to this. All other aspects of our batch processing works as expected. Transactions are working fine. As long as the SQL doesn't timeout everything is normal. DTCPing was used to ensure both servers have correct ports open to allow DTC traffic. Checked the SynAttackProtect setting on SQL and this is not an issue since other clients have no problems. One point I would like to add is that this new server was initially setup with a temporary server name and then was changed to use the name of the original server on move day. Don't know if this has any impact or not. Tag: Transform data from DB on sql server 2000 to another on sql server 2005?
  - 4
    - SQL 2005 does not work with ADO query on SYS.sysprocesses after Update installed from Microsoft str = "select nt_username, hostname, nt_domain, loginame, login_time, program_name " & "from master.sys.sysprocesses where spid=@@SPID " -This is the Query to display the username in the application. -The client is MS-Access 2003, MDAC 2.8 -It was and is Ok both on SQL 2005 and SQL 2000. The qury runs under Query Analyzer 2000 or Management Studio 2005 without problem -After Downloading the updates from Microsot Website. The embedded code returns no result set: Data provider or other service returned an E_FAIL status If anybody has any idea, I will be thankful. Tag: Transform data from DB on sql server 2000 to another on sql server 2005?
  - 5
    - Datareader Query Timeout Hello, I am running a query via a ado.net data flow source. It works great for a small number of rows, but if I try to execute a long running query it times out with a communication error. I have looked through the doc and every property sheet that I can find in my package, but I can't find anywhere that a timeout is specified. Any help on finding this would be appriciated. The query is running against DB2 on z/os and I know it is timing out on the server side because I can watch the query run on z/os and it continues to run after SSIS gets the error. Thanks! Harry Tag: Transform data from DB on sql server 2000 to another on sql server 2005?
  - 6
    - Accessing April CTP OLAP cube from Excel 2003 I installed Office 2003 first on a Windows XP machine. I then installed SQL 2005 April CTP. When I try accessing cubes from Excel, I get the error "An error was encountered in the transport layer" This error occurs when I try to setup the connection to my OLAP cube. Thanks for any help you can offer Taylor Tag: Transform data from DB on sql server 2000 to another on sql server 2005?
  - 7
    - Regarding running batch files and different packages I have created a master controller package which runs as follows deletes all the log files -> deletes few flat files on different drives -> preprocess task(execute package task) -> c# executable (execute process tasks) -> postprocess tasks (execute package tasks) i need a create a task just before the preprocess task with an user input asking whether he wants to run a particular batch file before proceeding to preprocess. if the user says yes it should run a batch file followed by preprocess tasks, c# and post process or else it should directly goto preprocess, c# and post process (neglecting batch file task) can anyone help me how to do it. Tag: Transform data from DB on sql server 2000 to another on sql server 2005?
  - 8
    - Differences between 2000 and 2005 Hi, Just want to validate that, contrary to 2000, 2005 will tolerate the use of SELECT statements within functions. Thanks Tag: Transform data from DB on sql server 2000 to another on sql server 2005?
  - 9
    - Reporting Services Add-in Installation Error I have tried several times to get the Reporting Services Add-In to install. It seems as if everything is going along well except when the installation gets to "Removing Backup" files it hangs and then completely uninstalls the product. Moreover, the event log simply notes "installation failed". Has anybody else encountered this Thanks in advance for any help. Tag: Transform data from DB on sql server 2000 to another on sql server 2005?
  - 10
    - Ever See This? No Borders or Icons on Tasks I'm setting up a new computer, and opening an SSIS project I've worked on elsewhere. Here's what I'm seeing (see http://tkfiles.storage.live.com/y1pX-TdM6iRI3cSQsl2V4GLd5RAuX2ygIeBbMSb-VM7vTauMSqehrm7pFvpA6N2sFLQFrb4a-1iXnk ): The borders and icons come back if I resize the window by dragging an edge of the window. They disappear again if I maximize the window. It's very odd, but I'm wondering if it means that something sinister is going on. I didn't set up all of the software on this machine, so I don't fully trust that it was set up correctly. Tag: Transform data from DB on sql server 2000 to another on sql server 2005?
  - 11
    - Can't connect to sql express 2005 I have an very big application written in vb6 running on msde 2000. I tried to change it to sql express 2005 and I cannot connect to the database. I wrote a sample app in vb6 using adodc and it works fine. From the other app I get no connection. I copied the same connection string!. I do not use the adodc control.I connect with a connection object.I have enabled pipes and tcp/ip. Any ideas or suggestions more than welcome. Tag: Transform data from DB on sql server 2000 to another on sql server 2005?
  - 12
    - Importing Data from Oracle 10g to Sql Server 2005 using Linked Server Hi, I am using Windows 2003 server and Sqlserver 2005 by the use of Linked server , I made a connection to Oracle 10g after that I am importing records from Oracle to sqlserver 2005. When I made tnsnames.ora in sql machine , it worked fine but when i am using tnsnames file from oracle server then i fiired importing procedure it returns below maintain error : OLE DB provider "MSDAORA" for linked server "BI_ORACLE_LS" returned message "Unspecified error". OLE DB provider "MSDAORA" for linked server "BI_ORACLE_LS" returned message "Oracle error occurred, but error message could not be retrieved from Oracle.". Msg 7311, Level 16, State 2, Line 1 Cannot obtain the schema rowset "DBSCHEMA_TABLES" for OLE DB provider "MSDAORA" for linked server "BI_ORACLE_LS". The provider supports the interface, but returns a failure code when it is used. Please let me know. Thanks Tag: Transform data from DB on sql server 2000 to another on sql server 2005?
  - 13
    - Missing Table Data in SQL 2005 Standard Hello, There has been a sudden loss of data in some (not all) of the tables in my database. I am using SQL Sever 2005 Standard with a simple recovery model for a single database. I can't find any specific hints in the logs to explain the loss, and this did not occur during a backup or scheduled maintenance routine. It seems the data just vanished at a specific point this morning, and I am not able to find out why. Do any of you have a suggestion that would help explain the loss of data in specific tables and not others in a given database without the known use of ROLLBACK or DELETE Or do any of you know a way that I can look back in the server to identify what may have happened Any help would be appreciated. Thanks, Billy Tag: Transform data from DB on sql server 2000 to another on sql server 2005?
  - 14
    - Odd characters added to T-SQL Automatically I am using Reporting Services 2000 and therefore VS 2003 and am having a problem editing the T-SQL query in the data view of Visual Studio. Basically if I manually edit the T-SQL query or touch anything in the designer view of the query I get odd characters added in the T-SQL and the query no longer works. I have tried re-installing VS2003 and RS 2000 but it's still happening. FYI I also have SQLServer 2005 and VS 2005 on my machine as all applications we develop are in .Net 2.0 and 3.0. We only use VS2003 for RS. Does anyone have a clue how to fix this Thanks Tag: Transform data from DB on sql server 2000 to another on sql server 2005?
  - 15
    - SQL CE 3.0 (Mobile 2005) Max DB Size Question Hi everyone, What are the consequences for just setting the Max DB Size to 4GB and letting it go at that Is the MAX Size any arbitrary value I want or must it be close to what the actual database is expected to be Also, why did they default to 128MB Wouldn't it have been better to set it to a larger value Thanks Dorothy Tag: Transform data from DB on sql server 2000 to another on sql server 2005?
  - 16
    - help? I need a little help to get me going. I have built a web app in visual web developer and made and inserted an sql db into the site with multiple .aspx pages. It all compiles and seems great. Info from the db is displayed,however when it comes to edit, insert or delete it bombs out " incorrect syntax near'nvarchar' or on delete........'int' some thing needs to be set to true... All conection strings seem fine and test ok. ps, whats the best way to to totally smash your dell laptop to pieces and send it to pluto Have included error Tag: Transform data from DB on sql server 2000 to another on sql server 2005?
- Next
  - 1
    - Please help! I downloaded the SQL Express and the trial package and all I am getting are the configuration tools. I con not get the actual program to get to the database....does anyone know what I should do Tag: Transform data from DB on sql server 2000 to another on sql server 2005?
  - 2
    - Report running very slow compared to Query Analyzer - high TimeDataRetrieval Hi, I have a report in SQL Reporting Services 2005 which calls a stored proc and the report takes a very long time to run and sometimes returns zero records. But when i run the stored proc in query analyzer it takes about 4 seconds!! I have checked the execution log on the RS using the below sql: Code Snippet use ReportServer Select * from ExecutionLog with ( nolock ) order by TimeStart DESC It shows that i have a large amount of time for the dataretrieval (601309ms, about 10mins) and does not return any records most likely because of a query timeout: TimeDataRetrieval TimeProcessing TimeRendering Source Status ByteCount RowCount 601309 2227 3 1 rsSuccess 4916 0 The weird thing is that when i run it in query analyzer, i get about 400 records in 4 seconds !! I dont understand what RS is doing to take up so much time like this to retrieve data. The report is very simple - it basically returns the records straight out into a table. The only thing I somewhat suspected was a parameter data type conflict between RS and SQL, specifically dates. I have a start and end date parameter in the report - i tried specifying this as date and string to see if it made any difference but it didn't. Any help would be greatly appreciated. Tag: Transform data from DB on sql server 2000 to another on sql server 2005?
  - 3
    - Refresh a windows form without closing it Hi all I have a couple of windows forms which share tables or parts of tables. When I edit a tables data on one form (form2), where it ,s data is linked to another form ( form1), when I go back to form1 I find that the fields have not been updated until I close the form and reopen it. Is there a way to refresh the field on form1 by using a button in the menu bar and what would the code behind look like. I use vb . Thanks Rob Tag: Transform data from DB on sql server 2000 to another on sql server 2005?
  - 4
    - CPU Usage by SSIS In my quest of writing a generic SSIS package programatically, I have another block. When I execute the exe seperately it consumes more than half of the CPU, some times its more than 90%. Is there any way where I can say how much of CPU to be used Thanks & Regards, Karunakaran Tag: Transform data from DB on sql server 2000 to another on sql server 2005?
  - 5
    - First attempt to connect fails I have a C# application that connects to a SQL Server Express 2005 instance. One of the testers here shuts his machine down every night and first thing in the morning when he fires up the application it fails to connect. If he tries to open it again right after that it connects. What would the failed attempt do that would fix the instance Tag: Transform data from DB on sql server 2000 to another on sql server 2005?
  - 6
    - Specifying different stylesheet in URL to customize ReportManager interface Thanks in advance to anyone who can provide insight into this... I am trying to specify a different stylesheet (other than ReportingServices.css) in the URL for running the ReportManager application; I am using the "rs tylesheet=<stylesheetname>" parameter in the URL. However, it seems that no matter which format of stylesheetname I use (i. e, just the stylesheet file name with no extension, stylesheetname + ".css" extension, "/reports/styles/<stylesheetname>", etc.), the ReportManager application only uses the built-in ReportingServices.css stylesheet. Is there some "magic" to specifying the name of an alternate stylesheet with the "rs tylesheet" URL parameter, or does this just not work Thanks again! Tag: Transform data from DB on sql server 2000 to another on sql server 2005?
  - 7
    - How could I know the version of Reporting Services in my machine? How could I know the version of Reporting Services in my machine thanks Tag: Transform data from DB on sql server 2000 to another on sql server 2005?
  - 8
    - changing a field's value when user updates data Hello, I am working on a project that involves one part where a field's value needs to be changed when the user updates the record. Here is the situation in detail: There is an InputData table where the user enters new records or changes existing records. There is a field called "calculated" in this table which has a default value of 'no'. A stored procedure runs math calculations on all the InputData records where the calculated field = 'no'. At the end of this stored procedure, it sets the calculated field = 'yes'. When new records are added by the user their "calculated" field value is 'no' by default so that the next time the stored procedure is executed, it only runs the math calculations on the new records. The problem is, if a user changes an existing record, the "calculated" field needs to be changed from 'yes' to 'no' so that the stored procedure recalculates the math for the modified record. How do I change the value from 'yes' to 'no' on records that the user modifies Thanks. Tag: Transform data from DB on sql server 2000 to another on sql server 2005?
  - 9
    - Reference for SQL SERVER 2000 Hello there everyone!! I've just joined this community and already feel alot better in doing so!! My question is aimed at SQL Server 2000. Part ofmy job role has swicthed to SQL Developer to Database Administrator. To learn SQL Server 2000 (latest version available to me) I wanted to find out about courses (based in London, UK) which help teach along the lines of the following topics: Fundamental concepts SQL Server installation and upgrade Database management Backup and recovery Alerts and jobs Security Replication Monitoring SQL Server Converting and migrating data This is what I understand to be prior importance for the role. My main question to you guys: Can anyone recommend a reference book which is a good desktop companion which covers all of these topics to detailed depth I'm running SQL Server 2000 on Windows 2003 Server. I'm aware some books may be old, but the later they are the better I've studied SQL at uni, covering RDMS, OLAP, Data manipulation, Data Definition. But now its to be applied to SQL SERVER 2000 Any suggestions please Thank you for your support 5SP Tag: Transform data from DB on sql server 2000 to another on sql server 2005?
  - 10
    - Attach DB Without Transaction Logs Hi, there, I have multiple transaction log files. I don't need the transaction logs and intended to remove them. I have tried detaching the database, rename the logs and trying to re-attach the database without the logs but to no avail. The error message mentioned something like file activation failed and SQL couldn't rebuild the transaction logs. Is there a way to get rid of the transaction log files Thank you. Regards, Yong Hwee Tag: Transform data from DB on sql server 2000 to another on sql server 2005?
  - 11
    - added two more user parameters I have a stored procedure that works fine in reporting services. It grabs the total of Yes's and No's by dates . But then i went ahead and added 2 more parameters to the proc, and now the totals are all wrong. I dont understand how that can mess everything up. Here is the previous stored proc, that gives the correct sum. Code Snippet ALTER PROCEDURE [dbo] . [Testing_Questions_ALL_YESOrNO] @Question char ( 80 ) AS BEGIN SELECT Qry_Questions . Question , Qry_Questions . Date , Qry_Questions . response , B . Total FROM Qry_Questions INNER JOIN Qry_Sales_Group ON dbo . Qry_Questions . sales_person_code COLLATE SQL_Latin1_General_CP1_CI_AS = dbo . Qry_Sales_Group . SalesPerson_Purchaser_Code INNER JOIN ( Select COUNT ( qq . response ) as Total , Question , Date , response FROM Qry_Questions qq Where qq . response in ( 'Yes' , 'No' ) GROUP by qq . [Question] , qq . Date , qq . response ) B ON Qry_Questions . Date = B . Date AND Qry_Questions . Question = B . Question and Qry_Questions . response = B . response WHERE Qry_Questions . [Response Type] = 'YesNo' and Qry_Questions . Question = @Question GROUP BY Qry_Questions . question , Qry_Questions . Date , Qry_questions . Response , B . Total ORDER BY Qry_Questions . Question , Qry_Questions . Date END SET NOCOUNT OFF Here is the edited version which only has two new parameters added to the proc. The edits are highlighted. Code Snippet ALTER PROCEDURE [dbo] . [Testing_Questions_ALL_YESOrNO_Totals] ( @Region_Key int =null , @QuestionCode char ( 5 ), @ Question char ( 80 )) AS BEGIN SELECT Qry_Questions . Question , Qry_Questions . Date , Qry_Questions . response , B . Total FROM Qry_Questions INNER JOIN Qry_Sales_Group ON dbo . Qry_Questions . sales_person_code COLLATE SQL_Latin1_General_CP1_CI_AS = dbo . Qry_Sales_Group . SalesPerson_Purchaser_Code INNER JOIN ( Select COUNT ( qq . response ) as Total , Question , Date , response FROM Qry_Questions qq Where qq . response in ( 'Yes' , 'No' ) GROUP by qq . [Question] , qq . Date , qq . response ) B ON Qry_Questions . Date = B . Date AND Qry_Questions . Question = B . Question and Qry_Questions . response = B . response WHERE Qry_Questions . [Response Type] = 'YesNo' AND REGION_KEY = @Region_Key AND LEFT( Qry_Questions . [Question Code] , 2 )IN ( @QuestionCode ) AND Qry_Questions . Question = @Question GROUP BY Qry_Questions . question , Qry_Questions . Date , Qry_questions . Response , B . Total ORDER BY Qry_Questions . Question , Qry_Questions . Date END SET NOCOUNT OFF Tag: Transform data from DB on sql server 2000 to another on sql server 2005?
  - 12
    - No servers available I've just downloaded and installed SQL Server 2005 Trial Edition in an HP 2660rx Itanium server. I can see from the Configuration Manager that there is a service running a database instance which I created during the installation but when I try to connect to the new database thru the SQL Server Management Studio it doesn't find any (when Database Engine is the selected server type) server names. In SSMS console only when I select Integration Services as the server type it detects the server name. What could be wrong In my server I just made a clean installation of Windows 2003 Server and SQL Server is the only software I have installed since that. Any help availabe Einomies Tag: Transform data from DB on sql server 2000 to another on sql server 2005?
  - 13
    - Pivot Sheet error I have deployed a cube and provided access to the users. When my user tries to access the cube he can access the dimensions, but not the Measures. Basically, when they pull the measures in the excel pivot data area it displays 'NA#' regards Josh Tag: Transform data from DB on sql server 2000 to another on sql server 2005?
  - 14
    - "Post Execute" method not being called - LockReadWriteVariables I have a strange bug when trying to run SSIS. I get the message in the output window " Information: 0x40043008 at Data Flow Task, DTS.Pipeline: Post Execute phase is beginning. " in a script component but the Post Execute method is not being called. I have placed a firewarning as the first statement to try and debug that the procedure is being called but to no avail as it is not being output Has anyone come across this kind of issue before or have any suggestion on how to proceed After a long period of time I then got the following messge displayed at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSVariableDispenser90.GetVariables(IDTSVariables90& ppVariables) at Microsoft.SqlServer.Dts.Pipeline.ScriptComponent.LockReadWriteVariables(String readWriteVariables) at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.PostExecute() Within the package I have two script components one that uses a readwrite variable to set the variable to be a date in the first script tasks PostExecute and then the second component uses the date variable in its PostExecute method. Running the package seemd to imply that the first postexecute write t the variable is somehow locking out the next component from reading the variable. Tag: Transform data from DB on sql server 2000 to another on sql server 2005?
  - 15
    - SEND/RECEIVE and Message Order I understand that SQL Service Broker will RECEIVE messages in the same order of SEND, so long as the messages are on the same conversation. I would like to accomplish queue-level ordering instead of (or in addition to) conversation-level ordering. There is a significant business case for this level of ordering. Consider an order processing system which is specified to fulfill orders in the sequence they are received. The reason for the ordering is as follows. Suppose the process(es) that RECEIVEs from the queue is down for several hours and the messages back up in the queue. Various customers place orders throughout this period of time. If more orders are placed than there are quantity for an item, the customers who placed their orders earliest in the day ought to be the ones that receive the merchandise and the later orders should be placed on backorder. Limited experimentation showed that SQL Server totally disregards the order in which the messages were sent (on different conversations to the same queue). The potential solution to use the same conversation has some drawbacks: 1. Difficult to do error handling because of the way error handling works in conversations. 2. It is not possible to RECEIVE using multiple threads. (Yes, RECEIVEing on multiple threads also would reorder the messages, but the reorderings would be localized in time so this would be tolerable by a lot of applications. In other words, orders from 1:00 AM would not be mixed with orders from 9:00 AM.) Can anyone see a good solution to this in the current version If there are no good solutions, it would be great if Microsoft considers adding a feature where you can declare an ordering requirement when you CREATE QUEUE. Even support for an "approximate" ordering (messages can rearrange +/- several seconds) would be helpful, but the current way which seems to totally randomize the message order is not good for certain kinds of significant applications. Tag: Transform data from DB on sql server 2000 to another on sql server 2005?
  - 16
    - Is this possible without using cursors? Hi! I have 2 tables: Person and Address Person ( PersonID int PK ) Adress ( AddresID int PK, PersonID int FK, Default -- 1 if address is default for person ) so when I join those table it yelds (for example): p1 a1 1 p1 a2 0 p1 a3 0 p2 a4 1 p3 a5 0 p3 a6 0 Person may: - have one default addres and some non-default; - haven't default address; - have only default adres So proper result is: p1 a1 p1 a1 p2 a4 OR p2 a4 p3 a5 p3 a6 I want to get list of persons and their adresses in following manner: Get person and - default adress ID if exists for this person - any address ID else Is this possible without using cursors Regards, Walter Tag: Transform data from DB on sql server 2000 to another on sql server 2005?

MagedSalah

Hello everybody,

Can anyone give the best way to transform data from a DB on sql server 2000 to a DB on sql server 2005

Note: - the source DB and the destination DB are different in their structure

- We need the conversion way to be scripted to can be done on different site.

thanks

Top

Re: Transform data from DB on sql server 2000 to another on sql server 2005?

NigelRivett

Depends on what you need to do.

Could be best to use SSIS, DTS, bcp the data out and in, copy via a linked server or openrowset, write a VB, C, .net application, ...

Top

Re: Transform data from DB on sql server 2000 to another on sql server 2005?

MagedSalah

Thank you for your reply

but i need more details ..........

i know that i can use DTS but DTS edit button disabled when i mapp two tables in the source and destination DB ....

I heared about using SSIS in sql server 2005 ..... but i don't know if it is suitable my transformation case or not ....

I don't know what u mean by "bcp"

Thanks

Top