Answer Questions

• David A. Windows Authentication for Linked Server Login Mappings: SQL Server Management Studio

  I was unable to use a local login based on Windows Authentication when adding a login mapping to a linked server using SQL Server Management Studio. The Windows Authentication based logins on the local server would not show up in the list of choices and you cannot type in the login you wish to use like in Enterprise Manager for 2000. So I went through Enterprise Manager to add the mapping and then deleted it. Now the Windows Authentication based login I used for the mapping in Enterprise Manager does show up in the list of local logins in Management Studio for creating linked server login mappings. However, the rest of the local Windows Authentication based logins do not. Does anyone have an explanation for this Is this some ...Show All

• Keith Hill ssis dinamic build variable

  hi, i have a global variable that is a file dir param lets say: d:\input\2006_07_18.bcp. this param supposed to be built from other 3 params i.e: day, month and year. how do i build it dinamically i need the exact syntax. i have already put the filedir param as an evaluated expression but when i try to do somthing like: @[User::Filename] + @[day] + @[month] + @[year] i get an error, although i succeed in putting only one param at its expression i.e: @[user:filename]. the question is how do i build the parameter that will b built from these 3 params in its expression. Brian, i will b happy to hear from you in regard. thx, Tomer tomerlev wrote: brian, i think i am soon ...Show All

• PaulMD From MySQL to MSSQL 2005

  Hello! I'm installing the MSSQL 2005. And i want to transfrom the DB from my old MySQL DataBase to new MSSQL Database. How can I do this With Import|Export Utils I can't do this task =( Pleasure Help me. Thanks I managed to get the "copy all tables" option enabled in the SSIS import wizard if I use the mysql.oledb connector (from Feb 2001) instead of the ODBC driver. Reads the meta-data fine (so far ...). Caveat: I'm connecting to a MySql 4.0 DB and still in the experimental stage. Has anybody else gone down this path Bill I've MySql ODBC driver 3.51 installed on the same box as SSIS and have created ODBC data source. What now ...Show All

• NewToVBInAR how can i delete my matrix's header ?

  I want to delete my matrix's header, set header not displays . I set the header 's content with none and can't set the height with 0cm. I don't know what to do, I give up at this point and need help from someone here . hi jarret thank you for you my control is matrix, is not table table's column not have group change the 'Hidden' setting to True. one matrix header header header total 1,7468 100.0% 48193 27.9% 562,68 32.2% 31102 18.0% 186,6 10.7% 168,878 ...Show All

• Ori' CTP version and release version

  we have a backup of a database from a release version with version number 9.00.1399 and we wanted to restore it to a server with version number (9.00.1116) CTP release. we were issued a version incopatibility message. is it possible to backup from a 9.00.1399 release with a backup file compatible for a CTP release, is there an available option during backup thanks! CTP versions are no longer supported. You should be using the released version of the product. Ideally, you should be at SP1, as we fixed quite a few bugs there. Backup is a physical operation. If the structure of the database pages has changed in any way, we have no way to do the conversion during restore. For moving up, we have the logic in the startup code to re ...Show All

• ANTRASOFT Insert or Update SSIS for Composite Primary Key

  Hi , We have scenario like this .the source table have composite primary key columns c1,c2,c3,c4.c5,c6 .when we move the records to destination .we have to check columns (c1+ c2 + c3 + c4 + c5 + c6) combination exist in the destination. if the combination exist then we should do a update else we need to do a Insert . how to achive this .we have tryed useing conditional split which is working only for a single Primary key . can any one help us . Jegan.T Hi Jegan, Have a look at the "slowly changing dimension" data flow transformation element. It does exactly what you need. Here is what you need to set in each page of the wizard: In the first page you will need to set c1,c2, etc ...Show All

• KitGreen Can't see ServiceBroker node with Management Studio Express

  Hmmm ... even though SQL Server 2005 Express edition allows you to build applications that use Service Broker, there doesn't seem to be a way to look at the Service Broker node on a local express edition server with SQL 2005 Management Studio Express. I can only see this node using a (remote) full Management Studio. Am I missing a setting somewhere, or is this "a feature" Thanks Josh ...Show All

• kbradl1 Disable Event Logging to Windows Application Log?

  Hi, We are starting to work with SSIS in our production environment & due to support issues; we are trying to get rid of the "Package xxx started" log entries inside of the Windows Application Event Log... So far, I have tried many different things, including setting the LoggingMode to "Disabled", as well as adding a new logging reference with a different destination... All of which still do not get rid of the extra log entries... Is this possible & does anyone know how to get this done Thanks! After I read your poost twice I realized this is a SSIS thing. The current implementation will always post the "Package xxx started" event and there is no wa ...Show All

• kjak Parameters in a OleDb Command Transformation

  Hi there, In order to prevent lookup errors in a lookup transformation, I've decided to go for an OleDb Command Transformation. This transformation should check the lookup and, if it turns out to be null, ir returns a dummy value. Otherwise, it would return the lookup value. This should be done by doing something like this: select coalesce( (select ID_Table2 from ID_Table2 where FK_Table1 = ), 0) suposing Table2 has an atribute called "FK_Table1" that should match a column in the data flow. Now, such command result in this message: " An OLE DB record is available. Source "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Syntax eror, permission violation, or other nonspecifi ...Show All

• bbg CREATE ASSEMBLY error: could not be installed

  I ran the following: CREATE ASSEMBLY A3rdPartyDLL FROM 'C:\Program Files\3rdPartyComponents\3rdParty.dll' WITH PERMISSION_SET = EXTERNAL_ACCESS and got the following error message: Assembly 'A3rdPartyDLL' could not be installed because existing policy would keep it from being used. How can I change the 'existing policy' I've tried all three: SAFE, EXTERNAL_ACCESS & UNSAFE. I get the same message everytime. But, thanks for the link. nope This message means that although the assembly itself is fine, some type of machine configuration would prevent it from running under Sql Server. The error message isn't very specific, but you should be able to fix the p ...Show All

• Kent Boogaart Master and SubReports

  Hi All, I am new to Rs2005. I have 4 seperate reports, r1, r2, r3, r4,.....etc. I want these reports to be called in sequence in a Master report. I want to make all 4 reports 1 big report. Can this be done, and if so can somebody please point me in the correct direction. Many Thanks in advance. Kenny   What exactly are you trying to display, page header in subR to pagehearde in masterR . Hi, I have now managed to display my 4 reports within a master report. But i am faced with another problem. Each SubReport has its own page header and page footer. But when i run the master report, the master header and footer is displayed on each page instead of t ...Show All

• LeoXue Upgrade MSDE to SQL Express. Connection problem

  I have just done an in-place upgrade from MSDE to SQL Express with Advance Services for my customer. After upgrading, the program was not enable to connect to SQL Express and threw an error (the program connect to the server through OLEDB provider) Code -2147217843 (80040e4d) - IDispatch error #3149 - Source : Microsoft OLE DB Provider for SQL Server It only works if I replace the string "Provider=SQLOLEDB.1" with "Provider=SQLNCLI.1". I wonder why I have to do that because in my working PC and other customers, I don't get this. The customer's PC use Windows 2003 Server for Small Business Server SP1 Thanks in advance Huy Le I know problems that you mentioned above. If I ...Show All

• Timothyjb Package execution fails in Windows service but runs fine as a Windows application.

  I am attempting to write a Windows service that watches a database for uploaded files to import. When a new file is found, the corresponding SSIS package is run from the file system with variables passed through. I started development as a Windows app and copied the functionality to a service. The app runs fine. The service does not. I get a "Failure" each time a package is executed. Everything is identical behind the scenes with the obvious exceptions that OnStart and OnStop handlers are buttons in the app. I added a script task at the beginning of one of the SSIS packages to notify me that it is even running at all. It doesn't even hit that initial task. Again, the app will run all packages just fine. The data is imported and t ...Show All

• Ricardo Francisco Daylight Savings Patch for 2000 Server

  I was wondering if there is a simple patch for 2000 server. It seems that the only fix is to edit the registry and to use the time zone editor app. If there is a simple patch like there is for the 2003 servers i would appreciate it if anyone can show me where. I have about 80+ servers with 2000!!! Much appreciated! Which is precisely the point. You patch WINDOWS. You do NOT patch SQL Server, because there is no SQL Server patch for this. Hi Guys I think I found a better way!!! Tech Republic had an article ( HTTP://articles.techrepublic.com.com/5100-10877-61680.htlm ) that has a tool called TZEdit where you set the new times zone setting without having to hack the registry. I installed i ...Show All

• Tryin2Bgood Triggers Priority

  Hello, I've got 4 triggers on the table A, all of them are executed when an insert occurs, which trigger is executed first (how does the dbms which one is going to be executed first) Could I assign a priority for triggers execution Thanks Hi, the trigger order is undefined except for the last and the first trigger which can be set. see the sp_settriggerorder for more information on that. HTH, Jens K. Suessmeyer. ---- http://www.sqlserver2005.de ---- Jens K. Suessmeyer wrote: Hi, the trigger order is undefined except for the last and the first trigger which can be set. see the sp_settriggerorder for more information on that. HTH, Jens K. Suessmeyer. ---- http://www.sqlserver2005.de ---- ...Show All