Answer Questions

• SPQR_ROME How to migrate from server to server.

  Hi, I could do migration from one database to another on the same server.But not sure how to do when it comes to server to server.Can anyone explain this Iam sending data from one database on one server to another database on another server..... In ssis when i try to put connection manager and refresh, the source server is not shown....what should i do pls help! Regards, pls help! Regards, sg. If you're trying to communicate with two servers then you need two connection managers. How many do you have -Jamie What are you trying to migrate Data If so, you should take a look at the Import/Export wizard in BIDS. -Jamie Hi Jamie, Iam trying ...Show All

• baswegan Homophones and Synonyms

  Anyone knows if Sql Server supports homophones and synonyms in the full text search on eastern asian languages such as Japanese and Chinese if so can you provide some link or some tip to getting started TIA Seems that Homphones aren't supported by sql server                           "Hope that helps :)"                             Carlo Pagliei . sw developer .  www.carlop.com           ...Show All

• xna3der Automatic failover failure

  Hello, we're running a mirrored database with High Availability for Automatic failover including a Witness instance for a web application. When doing a manual failover on the database in Management studio, the roles are switched correctly and the database is in "Principal, Synchronized" and "Mirror, Synchronized/Restoring" mode. The web application has no problems switching servers by using client failover with the jdbc driver. There is no problem accessing the database with Management Studio. However, if we stop the SQL service on the Principal server the role is automatically failed over to the Mirror server by the Witness. The database is then in the mode "Principal, Disconnected" which should be f ...Show All

• Vaish Newbie looking for direction

  Happy Friday afternoon, all, My task is seemingly simple. I have data on the server in MS Excel Files. I need to get the data into multiple tables in a SQL Server db on the same server. I have been only working with SSIS for a bit, so please bear with me. I can load the data directly from the Excel worksheet to one table, but I need to run an already defined stored procedure on the data from Excel before putting it into tables. I need to loop over all the rows and run the data from each row through the stored procedure. So, I think I need an Execute SQL Task withing a For Each Loop, but neither is available on the Data Flow page, and I don't see how to use them in the control flow page. I don't see that any of the Data Flow tr ...Show All

• progames25 add border in matrix report with 2 row group

  I have matrix report with 2 row group. I want to add border to the first Row group. when I Try add border in the layout tab. the border added to all the cell. here is my image to show: http://img2.tapuz.co.il/forums/1_92118232.jpg is it possible thanks! try again ...Show All

• Ferdinand Kuiper Query builder bug?

  HI, in a lookup component, when I want to use the query builder, it will show tables from a different connection manager than the one I picked for being the lookup source. E.g. connection manager A points to a schema that contains table1 and table2 and connection manager B points to a schema that contains table 5 and table 6. When I configure the lookup component to use connection manager B, I still see connection manager A tablles; isntead of seeing table 5 and 6 I see table 1 and 2. Am I missing something Thank you for your help, Cctoe Please report the bug on the Product Feedback site. Thanks. ...Show All

• BarrySumpter Efficient way to transfer huge amount of records

  Hi All, I used a data flow task, and when trying to transfer data from a OLE DB Source (records ~ 75 lac) to a destination OLE DB Source, SSIS fails at the middle giving an error saying the Transaction log got filled, try again after clearing the same. My query is what is the most efficient way to transfer say records more than 50 lac ensuring that it doesn't fail in the middle Thanks in Advance, Mithun. Thanks for the comments!! I'll try out the options. Michael, But if you need to copy from .xls source into a table you can't use Sql Destination. Correct me if I'm going wrong. enric vives wrote: Michael, But if you need to cop ...Show All

• johnnyXNA how do i use if inside sql task editor

  hi, lets say i have an input param calld x. i want to use it inside sql task: i try to put if( = 0) begin do somthing end but i get an error. the variable is configured correctly in the mapping input as i have succeeded to do the same with insert: insert into y values( ) why it does not work with if statment how can i use it thx, Tomer I recommend you use an expression to build the SQL statement as this is not susceptible to the vagaries of using parametes. This may help: Using dynamic SQL in an OLE DB Source component ( http://blogs.conchango.com/jamiethomson/archive/2005/12/09/2480.aspx ) -Jamie ...Show All

• z-one Multivalue Parameter against Oracle 9 datasource?

  Everything I have read says that this is possible in Oracle 9 and greater versions, but I can't get it to work... Here is my query: select * from employee where employee_id in ('111','222') This works fine in the data tab until I replace the values with a parameter. I get the pop-up to enter the parameter values but no matter how I enter them, I don't get any rows returned. I've tried entering them as '111','222' and as 111,222 and changing the parameter type from a string to an int, but nothing seems to work. I am running this on SQL Server RS 2005 and my Oracle driver (Oracle in OraHome92) is version 9.02. Executing queries with multi-value parameters is not supported on the data tab (thro ...Show All

• JIM.H. Is server downgrade possible?

  Hello, my question is simple, i guess, if anyone can help me solve this problem: I just installed Windows 2003 SBS Premium R2 but i have a software using SQL Server 2000 and not the one included in this version, 2005 wich is not compatible with. How can i downgrade, where cand i get the older server if the downgrade is possible and what else can i do before i shoot myself Is there any license issue that will not allow me the downgrade Thank You!!! Don't you love it when they omit the details! Here's a link to MSDE 2000 download... http://www.microsoft.com/downloads/details.aspx FamilyID=413744D1-A0BC-479F-BAFA-E4B278EB9147&displaylang=en MSDE is the equivalent of SQL Server 2000 Engine, but ...Show All

• syhzaidi Bulk Insert -- Access denied issues

  Problem: Insert a network file in the DB using BULK Insert Works for a local sqlcmd connection. Does not work for a remote sqlcmd connection. SQL Server is running on Machine 'WalRepTest'. User account for SQL Server Service: 'Domain\vivek_uppal'. This has admin privilieges on SQL Server machine and the machine hosting the file. I have 2 scenarios. Scenario 1 behaves as expected, Scenario 2 causes error. Scenario 1. Connect using sqlcmd from local machine Machine:                      WalRepTest Windows user:              Domain\vivek_uppal Sql login using the cmd ...Show All

• TA123 Cannot install SQL Server 2005 Standard WinXP Pro SP2

  Hello, I have SQL Server 2000 Developer Edition already installed. Before starting the SQL Server 2005 Standard setup, I exited the SQL server agent running in my system tray. I am logged on as Administrator and no other desktop apps are running. SQL Server 2005 Setup reports several "Setup failed." error messages after the install. I am choosing (for now) ONLY the workstation tools and books online check mark. The installation presents a screen that says that these products were successfully installed ("Setup finished"): - MSXML6 - OWC11 - SQL Server Backward-Compatibility Files However, these items have a red x next to them: - SQL Server Books Online - SQL Server Support Files - SQLXML4 - SQL Native Client - Wo ...Show All

• IB00 SOLUTION! - VB.NET 2005 Express and SQL Server 2005 - NOT saving updates to DB - SOLUTION!

  VB.NET 2005 Express and SQL Server 2005 Express - NOT saving updates to DB - SOLUTION! ----------------------------------- The following article is bogus and confusing: How to: Manage Local Data Files - Setting 'Copy to Output Directory' to 'Do not copy' http://msdn2.microsoft.com/en-us/library/ms246989.aspx You must manually copy the database file to the output directory AFTER setting 'Copy to Output Directory' to 'Do not copy'. Do not copy The file is never copied or overwritten by the project system. Because your application creates a dynamic connection string that points to the database file in the output directory, this setting only works for local database files when you manually copy the file ...Show All

• Shen Yizhe How to nightly copy 1 database to another

  I know this is probably an easy thing to do but I've been struggling with this on and off for the past month or so. All I want to do is copy two databases (our app db's) to two other databases (for app testing and training) on the same server every night. The databases aren't used during this time so they can be taken down if necessary. I've tried using the Copy Database wizard and scheduling the resulting job but that isn't working... Thanks in advance for any direction/help! Thank you all for the help. After some testing, this is the final T-SQL set that does what I want. Use Master GO ALTER DATABASE Testing1 SET OFFLINE ALTER DATABASE Testing1Sys SET OFFLINE GO EXEC sp_detach_db 'Testing1', 'true' EX ...Show All

• TheRolle Matrix title

  I have the following report using RS2000 (1) In my page header I have a textbox(title of the report). (2) In my report body, I have a matrix report that can extend horizontally. My issue is that I don't know how to make sure that my page header title (1) stretches as far as the last matrix row (2). Any help Has anyone ever come across this issue and is there a solution to it Thanks, YADGOR2000 I am not sure I can understand your response. Can you give me step by step break down for either option 1 or 2. Thank you yadgor2000 Two options: 1. You can add an outmost status column (or a dynamic column with a constant group expression) in ...Show All