SQL Server

Page 3557




  • Topics
    Replies
    Last post
  • Catching Events
    by Albertoim
    6 Replies
    Last post by Albertoim
      • Hi, I'm trying to catch an error and trigger a control flow to handle it. I introduce a control flow to catch "OnError" event, but , despite muy package has some errors it doesnt work... Another issue, if i omit an error on a transformation object ( in order let the flow continue executing), can this error be managed by an event or record it in a log Thanks
  • Vista SQL 2005 SP2 client to Windows XP SQL 2005 (non-sp2) workstation.
    by EnvisionOne
    14 Replies
    Last post by Xinwei Hong - MSFT
      • I'm trying to use SQL Management Studio to connect from a Vista SQL 2005 client w/ SP2 over to a Windows XP workstation running SQL server developer edition (non-sp2) using windows authentication. I'm already preauthenticated by network shares to the xp workstation. This worked just fine in windows xp but stop working in vista. After searching around, i found out that vista handles t
  • Trigger(its very urgent)
    by Khalil_ck2002
    5 Replies
    Last post by Khalil_ck2002
      • Dear Sir, Hello I Need To Know ABout Trigger What Is The Trigger ,and i need to Make Example On the Trigger that I Have Two Table,Employees, Department i nedd to make Trigger That when i make insert into the Employees Table , The No-of Employee Column on the Department table will increase With My Best Regard Khalil.T.Hamad
  • Cant find data source
    by Joske XP
    3 Replies
    Last post by Jose Miguel Torres
      • Hi, I use Visual Studio 2005 Pro. I installed Microsoft SQL Server Compact Edition Developer Software Development Kit . When i try to make a connection , i can't change the datasource to the compact version.(Not vissible) What could be the problem. Sorry for my bad english, Thx JoskeXP
  • Unable to Edit or Create SSIS packages or Maintenance Plans
    by Martin Elliott
    3 Replies
    Last post by DattaKhanolkar
      • Hi, I am running SQL 2005 Enterprise with SP2. In the past I have been able to successfully create SSIS packages using the BIDS and also Maintenance Plans from within Management Studio. Today I tried to edit a maintenance plan and got the following error message:- TITLE: Microsoft SQL Server Management Studio ------------------------------ Retrieving the COM class factor
  • Select expression Type
    by PSReis
    3 Replies
    Last post by NigelRivett
      • Hi, I'm executing the following Query : SELECT FC3 . Quarter , FC3 . Service , FC3 . TOTALIS , FC2 . Quarter AS Expr1 , FC2 . Service AS Expr2 , FC2 . FCtIS , cast (( FC2 . FCtIS / FC3 . TOTALIS ) as decimal ( 4 , 2 )) as Value , getdate () as DateUpdate --INTO FC4 FROM FC3 LEFT OUTER JOIN FC2 ON FC3 . Quarter = FC2 . Quarter AND
  • The dreaded subreport could not be shown error
    by WesleyC
    2 Replies
    Last post by WesleyC
      • I seem to have run across the feared "Error: Subreport could not be shown" problem. I have very carefully checked everything I could find on the issue, but nothing seems to help--and I must admit, I'm at my wits' end here (though it's probably something absurdly simple). I have a main report with one subreport. I am running ASP.NET, with a ReportViewer control on my ASPX page. The main r
  • Looking for a component
    by MatthewRoche
    4 Replies
    Last post by MatthewRoche
      • I'd like to incorporate the "package component tree" UI component that is used within the Visual Studio designers into an SSIS utility I'm building. This is the one I'm talking about: Edit: Apparently using the IMG tag on these forums works in the editor preview, but not in the actual posts, so I've replaced images with links... Example 1 Example 2 I've don
  • Can we use Excel file (source) for Bulk Insert Task
    by sam33r
    2 Replies
    Last post by itsAshish
      • Can an excel file be used as a source for a Bulk Insert Task in SSIS instead of a delimited flat file
  • Identity Primary Field in Merge Replication
    by terbs
    1 Replies
    Last post by Martin_McNally
      • Hello I currently have a merge replication set up with 4 subscribers. A primary field for one of my tables is set to a integer indetity. What Ive noticed is that depending on which database I enter data into, the indentity field (primary key) is set within a certain range I.e On Server 1 - Values start from 1 then 2,3,4 etc etc Server 2 - 24001, 24002, 24003 etc etc Ser
  • An internal error occurred. [ ID = 3639 ] on delete query
    by Nebu Jacob
    6 Replies
    Last post by Nebu Jacob
      • Hi, When I am trying to execute a delete query i'm getting the following error An internal error occurred. [ ID = 3639 ]. This is happening for some specific rows only. Other rows are getting deleted without any issues. Some 7 rows are there which i'm not able to delete. I am able to run update query on that rows. but not delete query Pls help Thanks Nebu
  • JULY CTP (WORKSTATION COMPONENTS FAIL INSTALL)
    by SteveBouff
    4 Replies
    Last post by Rajesh Nagpal - MSFT
      • AMD ATHLON 64-BIT WINDOWS XP PRO X64 EDITION SQL SERVER KATMAI X64 BIT INSTALLTION (JULY CTP) I've been trying to install the WorkStation components from the JULY CTP. I previously had the JUNE CTP installed. The entire instllation of the database engine and integration services went fine. The workstation components failed. After this failure, I removed the JUNE CTP workstation compon
  • Great New Resource for Books Online Information
    by Buck Woody - MSFT
    2 Replies
    Last post by Buck Woody - MSFT
      • The SQL User Edutcation Team has been working hard with our teams here to get better/more/good information out to our users. WeĦŻve created a new a customized Windows Live search, that limits results to Books Online. Check this out, and make sure you let your contacts know to visit it and provide feedback: http://search.live.com/macros/sql_server_user_education/booksonline We want to g
  • VERY slow stored procedure performance on datetime parameter
    by GeneTekA
    10 Replies
    Last post by GeneTekA
      • A relatively straight-forward stored procedure is working fine until one day it becomes incredibly slow. We look into it assuming it to be an index related issue, but it's not. If we run the SELECT on its own it runs in 0-2 seconds. That same SELECT within a sproc is taking 1:52 consistently. I began hard-coding the parameter values into the SELECT to find out which one was causing the problem and
  • query format date
    by daniel ku
    1 Replies
    Last post by hunchback
      • Hi I wrote query to get date from database SQL 2000 server. Sometime I get different date format not MMDDYYYY but number as Julian calendar Do you know what wrong with this How can I wrote SQL so that all date will be MMDDYYYY Thanks Daniel
  • How do i start playing with sql server???
    by harveyb
    2 Replies
    Last post by harveyb
      • Hi all, please help me!! I've downloaded and installed the express edition file (SQL Server 2005 Express Edition with Advanced Services - 234mb) but all I'm getting on the program menu are the configuration tools! Something appears to be missing - can someone shed any light on this THanks in advance
  • Foreach Loop - Value back to 0
    by MrHat
    4 Replies
    Last post by Benorama
      • Hi, Let's say you have a Data Flow Task that connects to a Foreach Loop, looping through the data. Somewhere inside the Foreach Loop, you set an int variable MyInt to a value. My question: Is it possable when each iteration begins to set MyInt to 0 Thanks in advance.
  • How to set douplicate id in sql server 2005?
    by Tamizhan
    11 Replies
    Last post by Phil Brammer
      • Hi There, Some one please help me to achieve this task. I have task to join 2 tables and insert values.The table which i am inserting values has typeid column which is primary key column.I supposed to insert values except this column(TypeId).When i m trying insert values its throw an error saying Error: Cannot insert the value NULL into column column does not allow nulls. INSERT fails.
  • Programmatically aborting a package
    by JeffJohnsonMVPVB
    11 Replies
    Last post by jaegd
      • Can a package executed from code be aborted in code The Package class has an Execute() method but no Abort() method. Clearly the debugger can stop a package at any point, so it must be possible somehow.
  • SQL 2005 Management Studio Query Designer suggestions / questions
    by DaveBoltman
    6 Replies
    Last post by Steve Kass
      • Hi MS, the 2005 Manangement Studio looks great, but ......... Based on a comment in http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=290394&SiteID=1 where MS says " It is our goal to provide consistent experience to both developers and database administrators regardless of which IDE they choose to use." Here are some sad inconsistencies... 1\ In the Open Table query designer
  • Error on Date Data During Insert
    by tampa_dba
    10 Replies
    Last post by tampa_dba
      • Hi Folx, I am new to SQL Server and I am struggling with source data for a table with two db_datetime columns. The data can be inserted using native SQL, but errors when I build a Data Flow Container. Versions: Microsoft SQL Server Integration Services Designer Version 9.00.1399.00 Microsoft SQL Server Management Studio 9.00.1399.00 Error: [Flat File Source [1]] Error: The "output column &q
  • Auto Filter in 2005 Reporting Services
    by ray_newbie_SSIS
    5 Replies
    Last post by ray_newbie_SSIS
      • Hello Experts, I have been playing around with RS 2005 and like it so far. I am in the process of replcating some excel reports in RS. I was wondering if there is any way to replicate the Auto Filter Functionality of Excels sheets where column is a dropdown with disticnt values of that specific column and also has Top 10 and Custom filters attached to it. So when selected from dropdown the report
  • ForEachLoop task not behaving as expected
    by sadie519590
    2 Replies
    Last post by K108
      • Hi, I have a ForEach Loop that has 3 script tasks in it. I have them set up so that they execute in order, such as: script1 ---> script2 ---> script3 script1 creates a file script2 creates a file script3 compares the files using a diff command Problem is, when I execute the container, it shows that script3 finishes BEFORE script2, which of course give
  • The variable "System::LocaleID" is already on the read list.
    by Zack Turnbow
    14 Replies
    Last post by Zack Turnbow
      • I've been getting the error below inconsistently when kicking SSIS packages off from a custom windows service. This same service works fine on our development and integration servers but not on our production servers. When I run the packages manually, it works great. Can someone provide any insight as to what is going on Error: The variable "System::LocaleID" is already on t
  • Import and Export Data Wizard missing in SQL Server 2005 Express Edition
    by rrudolph
    14 Replies
    Last post by rrudolph
      • After some weeks evaluating tools and platforms for developing an application, I decided to move to SQL Server 2005 Express Edition. Everything was fine till last night, when after creating my tables, I needed to populate them. I tried to find the Import and Export Data Wizard that SQL Server 7.0 and 2000 used to have, but great was my surprise when I found -  in this forum - a post that