Answer Questions
BennyAndGisela How do I install SQL Enterprise Manager?
Hi All, I'm pretty new to SQL anything... I'm wondering if there is a way to install just Enterprise Manager on my local workstation so I can open it up and manage or at least look at all of the SQL db's that are spread out on various servers - all in one place 1. How can I install just Enterprise Manager (if possible). I ran setup on SQL2000 Personal Addition and it didn't look like it was going to get to a 'custom setup' screen so I canc ...Show All
Toan Column metadata from Connection Manager programmatically
Hi all! My problem I've been struggling with is the following. I have a set of text files (around 70), each with different column numbers and types. I define Flat File Connection Managers for each of them where I can nicely rename, set data types and omit certain columns. I do this once and this will be the basis for the rest of the data process (would be nice programmatically too actually). I would like to pump each of these text files into ...Show All
PiperNavajo ETL using SSIS
Hi guys, I have been able to put together a simple SSIS package and familiarize with how it works. Now as I am trying to put together this ETL job I am stuck and am looking for some recos: I need the source system to be able to do a join on my Datawarehouse table and push thru only those rows which I am interested in. Can this be done using one of the Data flow task Presently we do it by using staging area, creating temp tables, doin ...Show All
GIS_Developer Management Studio Express CTP update now available
There is a new Management Studio Express CTP download available at http://www.microsoft.com/downloads/details.aspx FamilyId=82AFBD59-57A4-455E-A2D6-1D4C98D40F6E&displaylang=en . This update fixes the defect where installing the full Books Online documentation prevented Management Studio Express from starting. With the update, Management Studio Express and Books Online no longer interfere with each other. To update Management Stu ...Show All
metafedora General error handling
Hello, Originally we had laid out how we wanted our packages to work. In that concept we never really wanted our packages to fail but to offload the problem data to a file so that we could examine it (finding a problem in 1, 10, or 100 rows is easier than finding problems in 100,000 lines). The 2nd thing we want to achieve is to audit each task at the beginning and at the end. Very similar to how the the number of rows is shown in the dataflo ...Show All
Gaetano77 Regarding Querys
HI All, at the time of data exporting from dts to Text file in the query builder i gave a sql statement as select max(...) from <table name>. at the time of parsing its working fine. but at the time of exporting its throwing error like 'Please specify a valid name and ordinal values for the column' in dts we can use group function or not Thank you very much for your help and you solved my problem also. ...Show All
olapdummy SQL Server 2005 Express - UI Questions
I apparently overwrote the content of this question when I edited it, so I'm reentering it. Question: What UI is provided with SQL Server 2005 Express, in terms of building tables and relationships, and other basic DB construction functions _______________________________________________ My own answer: MS's page on SQL 2005 Express http://msdn.microsoft.com/vstudio/express/sql/ describes a "download free management tool" and has a brief ...Show All
mornevr SQL Authentication and SQL Express
(FYI - the Search box throws a scripting error when I type in it) I see in SQL Express Manager that I can connect using either Windows Authentication or SQL Authentication. Is the SQL Authentication for use with SQL Server 2000 and perhaps the full SQL Server 2005, but not for SQL Express My product uses SQL Authentication with SQL Server 2000; I am testing my product with SQL Express, but it fails on the authentication step: Event Type: F ...Show All
stephensells Return Job Status
Although this should be painfully obvious, I cannot seem to figure out how to return the status of a job. I want to use something similar to the following to control the execution of a statement based ont he status of a Job. DECLARE @intStatus int EXEC msdb.dbo.sp_help_job @Job_Name = 'jobname' If @intStatus = 4 Begin <execute statement> End What I don't see in the above is how to set the variable @intStatus to the returned value ...Show All
Crend King &#40;Old Profile&#41; Problem in ERD creation in sql server management studio
I have downloaded adventurework database intall it then configure the databases in managemnt studio and then make a ERD of the db all works fine. Then I have intall asp.net 2.0 starter kits. 1,Club Starter kit 2,Commerce Starter Kit 3,eBay Selling StarterKit 4,Jobs Site Starter Kit 5,Personal Site Starter kit 6,Time Tracker Starter kit install them and configure the databases in managemnt studio.all thing works fine but when I create erd ...Show All
SwitchBL8 Access Cube Detailed Info
Hello, Could I write ActiveX Script in a DTS Package to return cube info (such as CubeName, CubeStatus, CubeSize, CubePartitions, CubeLastProcessed) If that's possible, I could then pump in the result into text file and import them into a table for reporting purposes. Please let me know if this is the best route to explore DSO objects or any alternative way of extracting this type of Cube data. -Lawrence ...Show All
richqwerty SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has be
Hello, I have a sql 2005 server, and I am a developer, with the database on my own machine. It alwayws works for me but after some minutes the other developer cant work in the application He got this error Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: 192.168.1.140] and When I see the log event after that error, it comes with another error. SSPI handshake faile ...Show All
talia Bulk Insert won't compile if file doesn't exist, no Try Catch either
I first noticed that the try/catch did not seem to work when the text file did not exist and I tried to execute this block of code from a stored proc. Then, when I tried to compile the proc using a file that did not exist at the time of compilation, I can't even get it to compile. If I compile, then remove the file, the try/catch does not work. TRUNCATE TABLE LoadDaily; BEGIN TRY BULK INSERT LoadDaily FROM 'c:\temp\daily.txt' ...Show All
ingmiguelmejia Unhandled Exception in Management Studio
At work we run a large SQL Server 2000 database that is usually administered using Enterprise Manager. I recently started playing around with SQL Server 2005 Management Studio and have been encountering an interesting problem. Whenever I browse tables/views in the Summary window, and then select a table/view (by hitting enter or double clicking) Management Studio encounteres an unhandled exception (below). Oddly, this behaviour only occurs when ...Show All
Quintesv Pckg variable not getting set
I have created a simple package to zip a file. I am determining the file to be zipped dynamically at runtime using the Script task. I have a package variable defined as ReadWrite in the script task; I am attempting to store the dynamically determined file name to this package variable. The code I am using to assign the value to the variable is: Dim LatestBackupName As String Dim ZipName As String Dts.Variables ...Show All