Answer Questions

• Shan McArthur 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 Use expressions to assign the filename to the Flat File Destination (property Connection = User::variable) Add a Script task before your data flow task. This script task will prompt for the file location and set the User::variable. Can I just question this approach Is this for end users If so then I don’t think using SSIS in this way is appropriate. SSIS is a server, so it is licensed as part of the full SQL Server license, and is not somethi ...Show All

• catalinione '..product level is insufficient...' running package; I have SP1 installed

  I read other threads with this problem and one solution was to install SP1 on the workstation. Our server is running 9.00.2047(SP1) and my workstation SSMS version is 9.0.2047.00 so I'm assuming it's SP1 and I am still getting this error. To make matters worse, I have jobs set up to run these packages ON the server, but they aren't working either because I have '...error authenticating proxy...Logon failure unknown user name or bad password'. I'm trying to use my Windows login because it has sysadmin rights; I created credentials, assigned them to a proxy under SSIS Package Execution; in the SQL Agent log I get the error '...SQLServer Error: 22046, Encryption error using CryptProtectData.'. Any suggestions appreciated. &l ...Show All

• Diegota TSQL Disable / Enabling Distribution Agents

  I want to write a script that I can easily disable or enable all my distribution agents that live in my distribution server. Any ideas I tried to find some TSQL commands but couldn't find this feature. Thanks Nate Although not documented yet (we're looking to document them for SP2), you can play around with sp_startpushsubscription_agent/sp_stoppushsubscription_agent. To see the parameters these procs accept, do select object_definition(object_id('sp_startpushsubscription_agent')). Since these types of procs aren't officially supported, and you have policies in place to prevent you from using this, you'll have to query the replication metadata tables to grab the agents and their job names, then stop/start them v ...Show All

• 041661K Got BIDS working, was there another way?

  i re-installed the SQLEXPR_TOOLKIT.EXE several times(4) trying to get the BIDS part to work. Each time i had the issue of it looking for the devenev.exe as others have mentioned. I gave up on a 5th install and went for the unsupported option of running vs_setup , after the toolkit.exe dumped all the install files to its temporary directory i went in there and ran it sperately... but essentially i did it the same way as this method... http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=368549&SiteID=1 while this did work, it seems to be the unsupported way. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=665067&SiteID=1 Im not opposed to going back and doing it right, but was there ever a conclusion as to why the BIDS prog ...Show All

• faraaz_malak_c92eb4 Adding Data Viewer causes BI Studio to crash

  I am having this issue with BI Studio when I add Data Viewer to a relatively large data set, it causes the Visual Studio to crash. Has anyone experienced this Any help on this will be highly appreciated. Thanks, Ashish aharuray wrote: Thanks for the information. You are right. Changing the settings didn't help. It crashes regardless. I saw your bug report. It makes sense. Nevertheless, hopefully you will keep the new property values. Setting them to an arbitrarily large number is a very very bad thing to do. -Jamie   aharuray wrote: Yes those are the properties. I needed to change the properties because the load was slow and I need to increase the throuhput.   ...Show All

• sharpMoon CLR vs T-SQL

  Hi, I bought Pro ADO.NET2.0 but could not find a clear description of the optimum use-case for CLR and T-SQL Stored Procedures in general. (although the book is great) It seems for complex or recursive tasks CLR SP is useful. But would you recommend using CLR SP for basic INSERT, UPDATE, DELETE, SELECT queries Thanks, Bahadir Hi there, check this post http://www.yukonizer.com/dasblogce/PermaLink,guid,59a1fbee-1df3-4f9c-be64-de1c778c198e.aspx Might help you. Cheers, -DS Hi Bhadir, You get some insight from the whitepaper that we published on CLR integration---you can find it here . The basic guidelines are that for procedural, computational work, the CLR will outperform T-SQL. ...Show All

• Douglas H. Troy Group by on a concatenate field

  Select TOP 100 CONVERT(VarChar(10),Service_Prefix)+ '' + CONVERT(VarChar(10),Service_Code) as CODE, Date_Issued, sum(Amount) from dbo.Enterprise_Credits_Import_90_days where CONVERT(VarChar(10),Service_Prefix)+ '' + CONVERT(VarChar(10),Service_Code) <> ' 0' and Service_Prefix like 'F' Group by How can I group by the field that I selected as CODE Not disagreeing with you...Just adding my 2 cents worth to clarify/back you up :) Im going to test it today. Ill let you know if I get it to work. Thanks for alll the help ! Rob Farley wrote: Or if you're interested in readability you could make it: select top 100 code, date_issued, sum(amount ...Show All

• Daniel Hilgarth SQL 2005 Upgrade Options for SBS 2003 Premium Customers

  All, If this questions is misplaced please forgive me. I have a customer who has a Win SBS 2003 Premium installation with a Win 2003 Standard member server running SQL 2000 housing a Practice Management App. The new release of the Practice Management App only runs on SQL 2005. My question is what are my options for obtaining SQL 2005 in the most cost effective way The SBS Premium install was not a candidate for the 'free' upgrade to R2. Is there an 'upgrade' release of SQL 2005 for existing SBS Premium customers Any information would be greatly appreciated. Thanks! Ray I am not exactly sure, but I dont think you are going to get an upgrade SQL release for SBS. You will get better ans ...Show All

• Jeroen Bransen - J-Thread MDX help

  Hi All, I have a calculated measure in my OLAP cube which is a distinct count of one of the keys in the Fact table. This is a semi-additive measure so I need Distinct count of the last child of this measure. How can I do this Is there a built-in function to handle this. I am using AS 2005. Any help would be greatly appreciated. Rohit Sorry, I left an extra parentheses on the end of the calculated member definition. Here is the corrected definition: ( TAIL(DESCENDANTS(Calendars.Calendars.CurrentMember, [Calendars].[Calendars].[Month]), 1).Item(0) , Measures.MarketCount) PGoldy Have you thought about what you want the users to see when the data is incomplete For example ...Show All

• polomasta How to Redistribute sqlExpress

  Hi, I asked this question in another thread that was already going but has had no activeity for a month or so.. I have read the command line artical and the clickonce artical about installing the sqlExpress on the client as a silent install. There are alot of holes in the articals and i am in big time need to get this resolved. I would like someone to point me in the right direction on: 1. Client install sqlExpress from a link from my site ( with only click here type prompts ) 2. Client install sqlExpress from msi that is with my application 3. The absolute mininum componets for sqlExpress to run on the client 4. Is it possiable to install sqlExpress in my application directory and not under the clients ...Show All

• Seiggy Incomplete Print output from ReportViewer Control

  We are experiencing a problem where a server report is rendered in the ReportViewer control successfully but when the user chooses to print the content, the print output is incomplete (ex. only 18 of 23 pages are printed, etc.). This is happening consistently and has been reproduced for multiple different reports. It does not happen if the same report is printed via the Report Manager web interface. I have also found that if I switch to Print Layout mode and then initiate the print from the ReportViewer that the problem does not occur. This is our current workaround, but it would be nice to know what is causing this and have it fixed. Has anybody else seen this Is this a known issue with my current version (SQLR ...Show All

• Erik Bertrand report services matrix report,

  I have a matrix report, and I have some design. question. my report picture: http://img2.tapuz.co.il/forums/1_92074436.jpg 1. I change the report to be RTL, but the page title align to the left side, is it possible to align the title to the right 2.is it possible to add title to the group 3. in my matrix I grouped with 2 fields, I want to add border to the first group, I try and didn't success. thanks! and again sorry on my English. ...Show All

• mrbelk AMO Security Scripting Problem

  Hi! I have a little program that creates roles for a catalog and cubes. The roles is created fine and all the read permissions on the different cubes as well. Also adding different users to the roles is no problem. Then when i look in BIDS( open analysis services database) everything looks exactly as it should. However, the different roles does not work for the users that are added through the script. But, if i manually add a user to one of the created roles, it works for that user. Anybody who knows what is going on   The roles both have users and user groups in them. Hi! This is basically what i do. Role role = _oDb.Roles.Add(_sRoleID); role.Members.Add(new RoleMember("domain\user"); role.Update( ...Show All

• bpeikes How to pass variable values between tasks

  Hi Everybody, I have to generate a seq num and increment it by 1,i used execute sql task and wrote a proc using a variable(out) now this out variable has that value.Now i need to add a extra column to all the records coming in this current batch with the value in the variable. I know that i can use derived column transformation ,but its not working,giving the following error. the errors thrown are: [OLE DB Destination [16]] Error: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80004005 Description: "Unspecified error". An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: ...Show All

• JakeBree Error Locating Server/Instance Specified from ASP.NET site

  I'm currently learning my way around with SQL Server 2005 and asp.net 2.0, and for this I wrote a little site that uses SQL Server for it's backend. I developed it on my laptop, and it works great, until I deployed the website to my test server, so it's visible to the outside world. The instance I try to access any page that invokes the database, I get the following error: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified). The server doesn't differ much from my laptop setup, except t ...Show All