SQL Server

Page 3105




  • Topics
    Replies
    Last post
  • Adding static column of data from properties file to DB import
    by quadritic
    3 Replies
    Last post by jwelch
      • Hey all- I put togehter a package that opens a flat file, parses the data based on the semi-colon delimeter, and imports the rows into a database table. Thats the fun easy part. What I cant figure out is how to add a variable that will hold a constant ID value that will be persisted with the same value to all rows inserted to the DB. Making the problem harder, I would like that thi
  • query designer very slow loading tables
    by moldypenguins
    14 Replies
    Last post by Lisa Nicholls
      • when i use the query designer and add tables it takes 15-30 mins to load a table....so if i need 6 tables in my query thats like 6 times 30 minute load times...i'm using oracle as my data source when i switch the source to oledb it adds tables within seconds the only thing is i need to use named parameters any ideas
  • How to concatenate stored procedure varchar variables
    by Ajay Raj
    6 Replies
    Last post by Ajay Raj
      • Hi , I am trying to write a stored procedure (i have given it below). i am basically trying to join 4 strings into one based on some if conditions. But the result gives only the intially assaigned string and rest are not getting concatenated. i have provided teh stored procedure below along with the inputs and result i got. Can anyone Please help me to acheive this set ANSI_NULLS ON set Q
  • Parse text file (csv, fix width), Perl or something newer?
    by ydbn
    6 Replies
    Last post by MatthewRoche
      • I need to parse some text files and load them to database - these files are mostly CSV files or fix width columns format and the column names (first line) may vary in text (e.g. different abbreviation), order and extra columns, etc. Is it a good idea have this done using script task of SSIS How it compare to Perl on performance Or any other tools good for this
  • SSRS Execution Log RSExecutionLog_Update Job Error
    by Tae Lee
    0 Replies
    Last post by Tae Lee
      • I have set up RSExecutionLog_Update using the following instruction: http://technet.microsoft.com/en-us/library/ms161561.aspx But when I execute this job, I get the following error: Executed as user: SAVERSRPT1\SYSTEM. ... 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 11:29:36 AM Error: 2007-09-07 11:29:45.39 Code: 0xC020902A
  • The task "Send Mail Task" cannot run on this edition of Integration Services. It requires a higher level edition.
    by Anonymous141414
    9 Replies
    Last post by DumboG
      • I have a developer here that created an SSIS package that contains a Send Mail Task. When this developer runs the package in the Business Intelligence Development Studio (BIDS) the send mail task runs without issue. But when he tries to run it using command line and the DTEXEC program it errors out with the following error message: Error: 2007-08-01 15:57:44.37 Code: 0xC0012024 Source
  • unicode to non-unicode error
    by arkiboys2
    1 Replies
    Last post by DarrenSQLIS
      • My ssis package exports .xls file data into a sql server table. The fields in the sql server table have to be nvarchar instead of varchar. If I use varchar then the ssis package gives an error about converting unicode to non-unicode... Another ssis package exports .csv data into the sqme sql server table as above. This time the sql server table fields have to be of type varchar bec
  • Web Service doesn't work from Script
    by Eric In OK
    4 Replies
    Last post by Eric In OK
      • I'm trying to get this to work, but seem to be running into a problem. I've used the wsdl.exe tool to generate a .VB class and added it as a reference to my Script Task The Web service I want to call from my Script task has a method 'GetAndPublishPriceHistory()'. When I code my Script task: Imports System Imports System.Data Imports System.Math Imports Micr
  • Creating an Windows Rdl on the fly using .net programming
    by p4Pratik
    28 Replies
    Last post by p4Pratik
      • Hi, I would like to know that can I create an .rdl file programmatically based on the user selection (USING .Net programming) . Please help with some link / examples. P.S: I am giving very less number of static reports to the client. I want to give a more of a dynamic report , wherein in each case, I will give the user a selection criteria to select the fields fro
  • Connecting Tables
    by AtlasCreed
    4 Replies
    Last post by Jens K. Suessmeyer
      • Hey everyone, I am beggining in SQL and the .NET framework and have been running into some problems trying to design a relational database. I am completely new to it so I bought a book that was recommended in this Forum called "Handbook of Relational Database Design" and it has been pretty usefull so far. RIght now I am trying to make the Logical Data Model before I make the Relational
  • SQL 2005 Management Studio SP2 - New Maintenance Plans Fail
    by Jorge Pereira554310
    2 Replies
    Last post by Todd
      • We have SQL 2005 Enterprise Server (no SP) on a two node cluster (Itanium, Windows 2003 Enterprise Server R2). All our pre-existing maintenance plans run well. But if we create a new backup maintenance plan from a Management Studio with SP2 (and the post-gdr fix) on our 32-bit Windows XP workstations, they faill to execute (nothing shows up in MP History but the job history says 'syntax error on l
  • Format Y axis label as percentage
    by Kiranvukkadala
    6 Replies
    Last post by Kiranvukkadala
      • I have entered the code as P0 when formatting my Y axis to show 0% to 100%. This showed me percent values as 0% to 10,000%. Then after reading the forums I put the major gridline interval as 0.2 to get jumps of 20% but this just puts a lot of lines on the chart as 0,0.2,0.4 till 10,000%. How can i fix this one .. Thanks Kiran
  • Read/Write for Variables
    by cherriesh
    5 Replies
    Last post by PedroCGD
      • Hi, I am using a Script Component and I have a Read/Write Variable varStatusCase (as assigned in the Custom Properties of my Script Component). I used this inside my script to get a specific value. However, when I ran it I get this error: The collection of variables locked for read and write access is not available outside of PostExecute. How do I repair this Thanks,
  • Problem Creating View from Management Studio
    by karfast
    8 Replies
    Last post by karfast
      • Hi: I have a parent table and 5 child tables with a PK,FK reference. I designed a view in Management Studio by dropping the master and Child tables, so that I could see the parent data, and all details from child rows. My view does not contain any data though my tables do. What have I done wrong To describe what I want: I have Parent table with PK, ParentFields. I have Child1 with F
  • Book Data Mining with SQL Server 2005
    by hipswich
    3 Replies
    Last post by Cristiano74
      • Hi all, Is this book still the only book written for SQL2005's data mining Does anyone know where I can find its errata I have never seen so many editorial errors (typos, mislabeling, etc.) in other books. I am not worried about those obvious errors, but I am afraid that some errors may be so deceiving that when I find out, a lot of time will have been spent on misguided effort.
  • Add Extra Error Columns - From The Component?
    by John Saunders
    3 Replies
    Last post by Martin S
      • I've read a MSDN article on enhancing error outputs with a script component. This solution added the script component astride the error output, and it was able to add a column with the error description text. I would like to do something a little different. I'd like to add information from my custom component. When the component causes an error, it generally "knows why" - it has a
  • Deploying a Report
    by Stephen Burke
    4 Replies
    Last post by Stephen Burke
      • I'm having a little bit of trouble deploying the report project I have set up. In fact, I'm not even sure that deploying the project is what I want to do. All I want is to have something so I can view the report I've created in HTML or PDF form, something that was advertised when I downloaded the reporting services. Any help with what I would need with this would be appreciated.
  • Telnet connection works, sql cmd connection works, SQL Server Managment Studio 2005 does not
    by MountVesuvius
    5 Replies
    Last post by MountVesuvius
      • I'm having a strange problem with this but I know (and admit) that the problem is on my PC and nowhere else. My firewall was causing a problem because I was unable to PING the database server, switching this off gets a successful PING immediately. The most useful utility to date is running netstat -an in the command window. This illustrates all the connections that are live and ports that are be
  • Analysis Server 2005 (SP2, Version 9.0.3042) returns wrong results (from cache)
    by Frank Kruse
    6 Replies
    Last post by JesseO
      • In some cases the Analysis Server returns wrong results: If You at first make a query containing several restrictions and after that make a similar query with less restrictions, You sometimes get the result of the first query (which is wrong for the second query). Of course this error does not occur in every situation. In our environment it occurs when CustomRollupFormulas of ParentChild-Dimens
  • Problems with DTS execution
    by Susant
    3 Replies
    Last post by Michael Entin - MSFT
      • I am new to this thing so don't know where exactly to post this thread. Pls help me to solve the problem. I am having DTS package which uploads a database table in SQL server 2000. When I am executing the package manually I get the desired results. Now when I call the pacakge execution from C# directly without using stored procedures,I get a customised label which says the package was execut
  • provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
    by anomani
    1 Replies
    Last post by Anton Klimov - MSFT
      • Hi, I have been stuck up with this error. I am using SQL Srver express edition with asp.net 2.0 on windows XP SP2. When I open the SQL Management studio and execute queries it works fine. When I exute query in command prompt using SQLCMD -E -S Servername\Instance It conect with database and I can freely execute queries in command prompt. I have also tried to connect with Clas
  • How about getting a dedicated server to run and manage SQL jobs
    by daijun
    1 Replies
    Last post by Crispin
      • Hi all: Give me some feedback. In my company, we have 10+ sql servers and many sql jobs running on every SQl server. What about the idea that running all jobs on a dedicated sql servers at least 2 advantages 1.easy to managment 2.if agent server down, we restart the server not to impact the downtime of the production server. any suggestion is welcome.
  • User Manuel/guide
    by Hossam Abdel Wahab
    9 Replies
    Last post by Hossam Abdel Wahab
      • Hi all, Search for any samples or whatever help writing professional user Manuel for SSIS any suggest or help is Grateful thanks in advance
  • ::FN_VIRTUALFILESTATS doesn't work in Sql2k critical
    by enric vives
    2 Replies
    Last post by enric vives
      • Hi everyone, I perfectly know that this post is bad allocated but it's a critical one. We've a cluster and there it don't get rows. I'm trying this sentence: SELECT * FROM ::FN_VIRTUALFILESTATS and from our production server doesn't return results. Why the hell not However from other servers it returns data. Thanks for your time,
  • Changing SQL Server Management Studio "My Projects" path
    by Mike Koerner
    3 Replies
    Last post by Arnie Rowland
      • Hi, I want to change the default "My Projects" save location from "My Documents\SQL Server Management Studio\Projects" to somewhere else. I didn't see the My Projects path in the SQL Server Management Studio Options. How can I change the path Thanks, Mike