SQL Server

Page 2120




  • Topics
    Replies
    Last post
  • The SSIS package does not run using SQL Server Agent job
    by john zhang
    10 Replies
    Last post by IgorB
      • Dear All, My SSIS package is "Extract" data from Oracle and Load into SQL Server. The SSIS package does not run when I call the SSIS package from a SQL Server Agent job step I have gone through all the steps in the doc http://support.microsoft.com/kb/918760 , but it still doesn't work. Is it because of connection to "Oracle" database and SQL Server Agent ser
  • cursor + rounding?
    by MeMe_89765
    4 Replies
    Last post by MeMe_89765
      • Hi Guys, I've created a cursor inside a function. When I break it down and execute the code piece by piece, no problem. However, try and parse it together and I get an error - 'Mixing old and new syntax is not allowed ' Something to do with the return statements as I can alter the function to a procedure and it parses fine. Anyone come across this before Also, the values are being
  • OLE DB DESTINATION and SQL Server Destination
    by daijun
    12 Replies
    Last post by daijun
      • Hey All: I was totally confused. When designing the SSIS dataflow part, firstly , i tried SQL Server Destination because my target server is a sql server. then execute the task with failure. Then i tried to use OLE DB DESTINATION instead of SQL Server Destination. This Dataflow worked. i can not figour out why. By the way , i used the connection is OLE DB.And i choosed
  • Cannot edit packages
    by SSAS
    6 Replies
    Last post by James K. Howey - MSFT
      • I have sql server 2k5 sp2 cluster, IS is installed on both nodes. There are a few maintainence plans that work well until today, when I try to edit it, I got the following error message: TITLE: Microsoft SQL Server Management Studio ------------------------------ Cannot show the editor for this task. ------------------------------ ADDITIONAL INFORMATION: Value of '
  • Using Dynamic SQL in Reporting Services 2005
    by Fike
    4 Replies
    Last post by RayClark096
      • Hi, I have a dynamic SQL statement like 'Select * from Table name where month=@month' ..Exec(SQLStatement) Dynamic SQL does not recognizes @month which is a reporting services multi select parameter...An suggestions
  • Dynamic SSIS Configurations
    by r4enterprises
    7 Replies
    Last post by dba72
      • Hey there, I know that many articles have been written describing configurations for packages but I have yet to have found one that describes if it is possible to use SQL Server configuration type for a package that is to be tested on DEV, then UAT, then PROD boxes. I would like to know if there's a way to store values in a config table in a database on DEV, UAT and PROD but never have
  • UPDATE FAILED
    by Pintag
    2 Replies
    Last post by Pintag
      • Hi there ! I am getting the following message while trying to update Windows : Some updates were not installed Failed: 1 update Error(s) found: Code 65B I am running windows Vista. I have had this problem since one month ago. I do not find any help in your web sites about this situations. Any help will be appreciated. Need to know what to do th
  • DTS to SSIS ExecutionStatus Inactive
    by Raja Sekhar Parakala
    2 Replies
    Last post by Raja Sekhar Parakala
      • Hi , I have code in SQL Server 2000 (DTS). what is same code to inactive execution status in SSIS If returnValue <> "" Then DTSPackage.Steps("DTSStep_DTSDataPumpTask_2").ExecutionStatus = DTSStepExecStat_Inactive Else DTSPackage.Steps("DTSStep_DTSDataPumpTask_3").ExecutionStatus = DTSStepExecStat_Inactive End If Thanks
  • Truncate Table Statement And Transactions(using retainSameConnection property of OledbDestinationConnection)
    by Manish Dudeja
    14 Replies
    Last post by MatthewRoche
      • Hi Can we have truncate table with in a transaction using SSIS package. here is the scenario. OledbDestinationConnection 's "retainsameconnection" property has been set to true. I have added a Execute SQL Query task to "begin transaction". second Execute SQL Query task to truncate a table. say table "A" . truncate table a(table does not exists in th
  • Not associated with a trusted SQL Server connection
    by Li556035
    2 Replies
    Last post by Satya SKJ
      • Hi I am using the sql server migration assistant for oracle to connect sql server 2005 database, but I got an error message saying "Login failed for user xxxx. The user is not associated with a trusted SQL Server connection" To fix this error, I changed the connection method to sql server and window autheticatoin mode in sql server management stodio, but it still doesn't wo
  • How to retrieve large string from stored procedure?
    by Cheng Yik, Tay
    5 Replies
    Last post by Raj Kasi - MSFT
      • Hello! This is my scenario... Development - Visual Studio 2005 Database - MS SQL 2005 I have written a stored procedure that has a output parameter whose type is NVARCHAR(MAX). Then I use C# to wrap this stored procedure in OLEDB way. That means the OleDbType for that parameter is VarWChar. This works fine if the string size is less than 4000. If more than 4000, the remaining part will be chopped
  • SSIS - Connection String Issue
    by MA2005
    14 Replies
    Last post by Phil Brammer
      • Hi I have been trying to resolve a connection string issue all day, and havent figured out whats the problem. I keep getting the Acquire Connection error everytime I run my package. Can you someone review the format of my connection string, and confirm that it is indeed the correct format: I have two conn strings specified in my config file, one is to connect to a remote database and one is
  • How to extract domain name from an email address??
    by Sam_dia
    6 Replies
    Last post by Arnie Rowland
      • Hi do you know incase a script which extracts domain names from an email address like foreg. we have xyz@dmc.com or abce@dmc-int.com should give dmc and dmc-int
  • maintenance plan issue with missing databases
    by danschl
    1 Replies
    Last post by James Todd [MSFT]
      • I have sp 2 installed on the desktop and on the server But it still doesnt show the databases that were selected when you edit a backup or transaction log plan and if i go in and try to add 1 new database to the plan, it wipes out all the others
  • how to , SSRS 2005 single sign-on.
    by sql1
    9 Replies
    Last post by Amit
      • Our web application uses forms authentication and it's working. Is it possible to use the same logon credentials to automatically login to the report manager, we would like to be able to navigate from our web app to the report manager without login in again-. In other words is it possible to share cookies between report manager and our web apps to achieve single sign-on. How do we achieve that Any
  • SP - Strange problem
    by Tovdb
    14 Replies
    Last post by Tovdb
      • Hi everyone, I don't know where to ask this question, so I'm trying here. I'm developing an application which interacts with a db through Stored Procedures on SQL Server 2005. I've created a mass search functionality which goes through 2 tables with one string seeing if it can find something. The stored procedure I use is the following: Code Snippet
  • Error:The precision must be between 1 and 38.
    by Paarul
    5 Replies
    Last post by Paarul
      • Hi All I am trying to pull data from Oracle to SQL Server but if I use Oledb Source than I get this error Error at Data Flow Task [DTS.Pipeline]: The "output column "CUST_ID" (590)" has a precision that is not valid. The precision must be between 1 and 38. ------------------------------ ADDITIONAL INFORMATION: Exception from HRESULT: 0xC0204018 (Microsoft.Sq
  • Database services install fails when install SQL server 2005 SP2
    by Rex583305
    5 Replies
    Last post by Vidhya Sagar
      • The error I got is: Hotfix.exe has encountered a problem and needs to close. We are sorry for the inconvenience. EventType : sqlsesetup P1 : sysdbupg.sql P2 : 0x7361 P3 : odbcstatement__execute_batch@sysdbupg.sql@3 P4 : 0x7361 P5 : lib_odbc_statement.h@91 P6 : unknown P7 : sql9 P8 : hotfix@ P9 : x86 P10 : 3042 Log Location: C:\Program Files\Microsoft SQL Server\9
  • Recordset.update with SQL Native Client doesn't work
    by DoubleDee
    5 Replies
    Last post by Dino_RPG
      • We recently migrated from SQL Server 7 to SQL Server 2005. Now there's a curious thing with some legacy applications. I have pasted some code below. Don't judge me, because like I said, it's legacy. You can see, that I have two connection strings. One is commented and accessing via SQL Native Client. The other one is doing this through the old SQL Server driver. Funnily enough, when I use the new
  • Is there any sample code to demo the SSB send messages with same sql instance?
    by Anonymous553803
    1 Replies
    Last post by MladenP
      • Is there any sample code to demo the SSB send messages with same sql instance my case is very simple: I want write a stored procedure to send a xml to another database. The stored procedure is called by tables triggers when some data is changed under the specific conditions.
  • 64 bit reporting services with 32 bit wss 3.0
    by Nestor393595
    2 Replies
    Last post by Nestor
      • Hi all, I'm trying to find out if there will be any problems if I have a 64 bit Reporting Server integrating with a 32 bit Wss (3.0) server farm Thanks. Nestor
  • Not able to install SQL Server 2005
    by MannuBhai
    6 Replies
    Last post by MannuBhai
      • Hi All, I have a problem again. i am trying to install SQL Server 2005, but on the verge of completion of the set up, it says " the set up encountered an error and SQL Server 2005 was not installed" (This is not the exact error message though; it meant this). It ultimately ends up installing only the configuration tools. Though all the services and groups are created, the DB engine is
  • Maintance plans corrupted after sp2...
    by kiranDBA
    3 Replies
    Last post by Jonas Larsen
      • Posted - 03/19/2007 : 09:14:02
  • Could not set "Ignore Failure" for OLE DB Destiantion component
    by Jun Fan
    3 Replies
    Last post by Jun Fan
      • I am using Microsoft SQL Server Integration Services Designer Version 9.00.1399.00. My OLE DB Destiantion component is inserting data into a table. When there is duplicate it will failed. But I want ignore this since I know data is same. But even I set Ignore Failure from OLE DB Destioantion Editor. It will not work and every time you reopen editor, the buttom drop down box always showing as &q
  • SSCE Transaction Log
    by AndrewBuyan
    5 Replies
    Last post by ErikEJ
      • Hi, Are there any pecularities of Transaction Logs in SSCE comparing to the same log in full scale SQL Server How are they stored And when they are considered to be expired in order to safely delete them Thanx in advance