Answer Questions

• Hassan Ayoub SQL Agent Step Notification

  I have several SQL Agent jobs that each contain multiple steps. I want the job to continue, even if one step fails, as they are not dependent on each other. However, if I set it up so that the goes to the next step on failure, it appears that I have no way of being notified of the failure, since the job ends successfully. Am I missing something Is there a notification that can be sent if a step fails Thanks Bob I have submitted the feedback/suggestion. The link is: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx FeedbackID=244623 Thanks! BobP See this http://www.sql-server-performance.com/dh_sending_sql_notifications_CDOSYS.asp is any help. If you could submit a suggestion o ...Show All

• Jassim Rahma How do I create a package that imports an excel file where column names are changing.

  Hi, Our company wants to allow our customers the ability to import employee data. Each customer's employee data changes depending on things like organisation structure etc. so the format of the data to be imported needs to change. We can do a lot of this with dynamic SQL, but are looking at moving it to SSIS as we think it will save us a lot of pain later on and for other features in SSIS. We're stuck at a fairly early part of the process as we don't know how to dynamically import our spreadsheet. So far our best idea is to connect to the excel connection as the only step in the data task and then to use a script task on the control task, write code to connect to the excel source (set the excel source to not treat the first row as he ...Show All

• khaladu error message "running IIS failed ...see hresult "

  hi, I'm working on "MERGE REPLICATION"...i followed the procedure same as the book "SQL SERVER CE DATABASE DEVELOPMENT WITH the .NET COMPACT FRAMEWORK"Author Rob Tiffany, ch9,10 i got one error msg that..."a request to send data to the computer funning IIS failed,for more information seeHRESULT " ..When my program hits rep.Syncronize()... here my codes \\\\\\\\\\\\\\\\\\\\\\\ rep = New SqlCeReplication rep.InternetUrl= " https://seawolf/fieldagentrda /sscesa20.dll " rep.InternetLogin = "robtiffany" rep.InternetPassword = "pinnacle" rep.Publisher = "seawolf" rep.PublisherDatabase = "IntelligenceData" rep.PublisherLogin ...Show All

• Scott_P OLE DB Source to Flat File Destintation using Fixed Width Columns - determining source column width

  Hi, I am trying to create a program that transfers tables to flat files. At this point in time, I have suceeded in created one that creates delimited files. However, I am now trying to create fixed-width files as you can do with the SSIS designer, but programatically. Is there a way to programatically determine the width of a column from the source table I can not seem to find any kind of function or member that stores this information or allows me to retrieve it. I know what I need to change in order to set a width for a column, but I just don't know how to find the width without just asking the user to provide one. Hi theddern, Have you looked into the system provided views under the "master" database ...Show All

• Jordanspringer SQL Express

  Hi: I'm trying to replace MSDE with SQL Express 2005, I would like to know if Window XP Pro SP1 is OK to use Can I write code with VB6 with SQL 2005 Express Any Step by Step Installation of SQL Express 2005 Thanks and regards I could use OLEDB but not SNAC. I get Error Message trying to connect using SNAC. By the way, what does SNAC really meant in lay man term If the Client used SQLOLEDB then why need SNAC. Does Client PC need .Net Framework 2.0 and ADO 2.8 I do not have the ERROR Message with me. I post later. Thanks for your help I once wrote an article for that, although being in german, you should get the information from image on the first side which show the relation from ODBC and .NET cli ...Show All

• FireFreak Dynamically create text file as destination

  I am trying to create a text file from an SQL query on a SQL table. I would like the SSIS package to prompt for the file name and path. The text file is tab delimited and the text qualifier is a double quote. Thanks, Fred Couldn't you create a package variable called FilePath (for example) of type string and then read into it through a script task Something like the following would give you an input prompt and then store the value into the variable created: Public Sub Main() Dts.Variables( "FilePath" ).Value = InputBox( "Enter your file path" , "Prompt" ).Trim() Dts.TaskResult = Dts.Results.Success End Sub Then, you could just set the ...Show All

• mitchwardrop Try-Catch RESTORE Error Messages

  It seems that the RESTORE command processes 2x error messages when it fails. The @@error or Error_Number() only capture the second of these messages - rather annoying as the good stuff is in the first error. Question is: Does anyone know how to capture the first error message or disable the second, unuseful message Example: Begin Try Restore Log [dbName] From Disk = '\\serverA\LogShip$\dbName_20070206094607.trn' With NoRecovery, StopAt = 'Feb 9 2007 11:30PM' End Try Begin Catch Select @@Error, Error_Number(), Error_Message() End Catch In an error situation produces (in one go): Msg 4305 , Level 16, State 1, Line 1 The log in this backup set begins at LSN 25000000086900001, which is too recent to apply to the database. An ...Show All

• Michelle A. History Cube Design Question

  Hi, In SSAS 2005 - I have History cube with 2 partitions 2005 and 2006 data. Both has different tables in data source view. In cube both partitions are map to same measure group, so there is no different measure groups for 2005 and 2006 just to make it clear. Time to time I need to add new measures in latest cube (2006 partition) data those measures don't have data for 2005 partition. Right now when I add new measures in 2006 I have to full process the 2005 and 2006 both partitions. Is there any way or way to design my cube so that when I add new measures to cube I can only full process 2006 partition. If user selects my new measures with 2005 date they can get null/zero that's fine. Thank you for sharing your ideas - Ashok ...Show All

• PublicError Log file cant acquire connection while working offline

  hi As I trun Work offline - true, my connection manager for log file says-it cant acquire connection while work offline is true.Where as other oledb connections work fine. Even it tried to get around by putting DelayValidation as true, but didnt work. Is there is anyother setting that has be set. Thanks and Regards Rahul Kumar yes Rafaels Both are on similar lines.But fact is problem still exists and i have given it many tests. Are there any tasks using the connection managers that apparently don't throw any errors -Jamie Hello, are you referring to messages you see when you open the package with 'Work Offline'=true When you say & ...Show All

• paramjeet Replication without initialize subscriptor with the snapshot

  Hello all, I am developing a system using SQL Server replication between SQL Server EXPRESS 2005 clients and SQL Server 2005 servers. I initialize the replica databases with a script, then I do not want to initilize the subscriber with the snapshot; I configure each subscriber to "not initilize", but when I run the first synchronization the snapshot copy process is always is executed. Maybe am I forgetting something Can I use this SQL Server EXPRESS - SQL Server replication scheme without initialize the subscribers with the snapshot Thaks for reading! Thanks Greg! Merge replication, the article was very helpful. Hi Greg! I've met the same problem that was discussed here: http://forums.micr ...Show All

• wannabe_2 Error while executing SSIS package from other SSIS package

  Hi, In our project we have two SSIS package. And there is a task (Execute SSIS package) in First package that calls the execution of second package. I m continuously receiving an error "Failed to decrypt protected XML node "PackagePassword" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available." As we are running first package by job, job runs successfully logging above error The protection level of second package is set to "EncryptSensitiveWithUserKey" Can anybody please suggest how to handle it ...Show All

• Jillaint insufficient system memory

  Just wondering if anyone else has seen any memory issues with cross instance communication. Just this last week we moved from single instance to cross instance communication. I started up a process that will move 3,000,000 messages through service broker, but after a couple of hours the server tanks out and we get insufficient system memory errors in the sql error log. If no one else has seen or experienced this then I'll probably get a ticket opened to see what it may be. It's just that the change in our service broker network was the only change I was aware of on this instance. Regards. Can you confirm that is SSB who consumes the memory Run this query to see where the memory goes: select ...Show All

• Peer Larsen A transport-level error has occurred when receiving results from the server

  Hi all, I am trying to run a stored procedure which retreives 3 lakhs of records and updates the data and moves few of those records to some tables. Since the number of records are more , the time taken for the storede procedure is around 30 minutes when i directly execute it in query analyzer. But I need to execute it from Visula Studio.Net 2005 (c#). Whole of the application contains only one form with a single button.When I click on the button , this stored procure has to be executed. But I am getting an error as shown below. "A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified networ ...Show All

• Josh Alldredge Replicar SQL 7 ( Publisher ) y SQL 2005 ( Subscriber )

  Quisiera saber si se puede y como llevar a cabo la replicacion con SQL 7 (Publisher) y SQL 2005 (Subscriber). Desde ya muchas gracias. One other thing to note, for SQL7 publisher to work with SQL2005 subscriber, you have to use SQL7 distributor, it's not supported if publisher is SQL7 and distributor is SQL2005. Fore more information, please check SQL 2005 Books Online topic: Using Multiple Versions of SQL Server in a Replication Topology http://msdn2.microsoft.com/en-us/library/ms143241.aspx Thanks, Zhiqiang Feng For your SQL 7.0 publisher and SQL 2005 subscriber, only Transactional/Snapshot Replication is supported. You will limited to the functionality of 7.0 publications. ...Show All

• Marlun Port Conflict and IPv6-Adress Resolution Errors when Creating Endpoint

  Hello, executing the first script listed below resulted in the error message (translation): Message 7890, Level 16, Status 1, Line 1 Error when registrating Endpoint. Potential port conflict ... use AdventureWorks ; go CREATE ENDPOINT SQLEP_AWPersons STATE = STARTED AS HTTP ( PATH = '/AWpersons' , AUTHENTICATION = ( INTEGRATED ), PORTS = ( CLEAR ), SITE = '*' ) FOR SOAP ( WEBMETHOD 'PersonInfo' ( NAME = 'AdventureWorks.dbo.uspGetPersonInfo' ), BATCHES = DISABLED , WSDL = DEFAULT , DATABASE = 'AdventureWorks' , NAMESPACE = 'http://Adventure-Works/Persons' ) I changed the port in the script to 8084: PORTS = ( 8084 ), Error Message 102: Wrong Syntac near ')'. I chang ...Show All