Answer Questions

• Suresh1977 Package running other packages

  Hi everybody, I have to create a package that executes other packages I've already created... Every one of these packages run with the same Configuration File, but if I try to execute the main one, including the path of the file, I get errors from the other packages because they can't find it... How can I manage to pass this file and its content to the other packages Here a little explanation of te process: Main Package needs confi ...Show All

• korn deleting sql server 2005 deployed packages?

  Hi there This is probably a dead easy question. I have deployed 3 SSIS packages to sql server, but now i cannot find any option anywhere to delete them How do i delete SSIS packages from the SQL Server instance they were deployed to Thanx   KirkHaselden wrote: Oh, and, you're welcome for the post too Sean. :) Oi, I'm claiming all the credit for this one :) Sean, Kirk has posted on this: http://www.sqljunkies.com/WebL ...Show All

• tomdeloford HELP - Problem with Replication

  Hello, I have transactional replication running between two SQL Servers. It's a push subscription and the distributor is on the local publisher. Recently after running for a year the replication stopped working and we get the following two errors. 1 - The process could not bulk copy into the table "History_Rep" String Data, Right Truncation. Error Number 22001. ----------------------------------------------------------- ...Show All

• KillerAppz Problem when creating a new named calculation

  I have a Customer dimension in my model, and now I want to count the # unique customers in one of my fact tables. Therefore I created a new named calculation in the fact table which does a count distinct of the customerkey in the fact table. And when I try to add a new report model i get the following error message, even when I don't select anything in the Select report model generation rules screen: TITLE: Microsoft Visual Studio ...Show All

• VladSoft ODBC connection failing on 64 version of Windows 2003 server

  I have an application that talks to a SQL backend using an ODBC DSN connection. It works fine when running on a 32bit machine but fails in the 64bit environment. The DSN is setup properly on the 64bit box and the Test Connection returns sucess. However when my application tries to use the DSN to connect to the database I recieve the following error. IM002 - Data source name not found and no default driver specified. The data source nam ...Show All

• Ramkumar S.N. New RDL Spec differences

  Is there somewhere that explains the major differences between the 2003 RDL spec and the new one released in November I will be going through the two specs in detail in January looking at the differences but I was just wondering if there's a quick synopsis out there somewhere. Are there any major differences Darren #10: You are right - we should have only one DataValue element in the spec and e ...Show All

• NaturalAnthem SQL Management Studio 2005 SEPT CTP

  Hi, I have Sept CTP running happily on Windows 2003 SP1. Like you, a clean install. Let's go back a step. Which management tools did you choose to install Locally, on what I assume is a dev/test server Which .exe are you trying to run You said it was a clean install. Any warnings on the system check before install Anything in Summary.txt Thanks Andrew Watt MVP - InfoPath wrote in message news:92b5ce30-e21d-48 ...Show All

• Jordi Valldaura Riqué Database Diagrams - SQL Server 2005 Express

  I have installed Visual Basic 2005 Express and SQL server 2005 Express. I am reading the ebook: "Microsoft Visual Basic 2005 Express Edition - Build a Program Now" that you download when you register the products (it is a PDF file named 6-2213-2.pdf) Page 139 of the book (or 151 in the file) is about "To Create Relationships between Tables". So I follow the instruction and get stuck on Step 1. When I right click on the Database Diagra ...Show All

• BobGun Wildcard Searches

  I have a number of functions that require the input of parameters in order to ultimatly create a report under Reporting Services by making use of a Stored Procedure. All the functions etc work as does the stored procedure, but it only works if I specify data that I know exists e.g. DECLARE @return_value int EXEC @return_value = [dbo] . [spWTRalldatareportsummary] @dt_src_date = N '04/28/2006' , @chr_div = N 'NE' , @v ...Show All

• MAXamillion Internal Activation - calls stored procs in other DBs

  Hi all I am using internal activation on a queue to process the messages, should an error be encountered I call stored procedure A in the same database to log the error. Part of the processing in stored procedure A is a call to stored procedure B in another database (on the same server), however I have not been able to get this call to B to work. Currently I get the error "The server principal XXXXXX is not able to access the database YY ...Show All

• Jinnyminto Insert and Outer Left Join

  How does one write INSERT queries for tables that have LEFT OUTER JOINS I have 5 tables (Company_Name_and_CIK, Date_Filed, Form_Type, SEC_Web_Address, Form_XML) that all have left outer joins to one other table (_Company_Info_01) The first 3 tables above (Company_Name_and_CIK, Date_Filed, Form_Type) generally don't change, but when a new record is added to the _Company_Info_01 table, there will be new values added to the last 2 tables (SEC_Web ...Show All

• kwing Error processing events

  Let me start by saying this is my first crack at NotificationServices.  I installed a sample from "Microsoft SQL Server 2000 Notification Services" that processes stock events (I think it may be a copy of the one in the help file).  I get the following error when I place a file in the EventsWatchDirectory.  I have uninstalled and reinstalled SQLXML and MSXML3 (I already had MSXML4 sp2).  Any help is appreciated. <Notific ...Show All

• dotnetfrage Send Email as HTML

  It seems that using the Send Mail Task, there is no option for me to format my email as HTML. I have all my HTML code in a string and need to format my email to send the string as an HTML email. What would be the best way to approach this Hello, What is the namespace: Imports Microsoft.SqlServer.Dts.Runtime I don't seem to have that reference. Equally, what does it do in relation to the html ...Show All

• Bryan Janes SSIS Script Component

  Dear all, Such a pain, I know. Yesterday I did a couple of questions regarding transformation rows and very kindly I obtained answer (Thanks Jamie and Michael) But now I face another stupid issue and is how to map source with destination columns inside Script Component Task. On my Flat File Source I’ve got defined thirteen columms (from Column0 till Column13); that’s fine. And then, I’ve got a sql table as destination with another ...Show All

• ohansen Parameter is missing a value

  I have a report parameter with Allow null value checked (and also Allow blank value). The report works as expected when viewed in Visual Studio, i.e. if I don't supply a value for the parameter, the report still renders. However, when I try to view this report through the web ReportViewer I get the error message "The X parameter is missing a value". It works fine when a value is supplied but I want that parameter to be optional. Any ...Show All