Answer Questions

• Michal Laskowski Which system tables hold SSIS pkg information

  Hello Everyone, I need to know which system tables hold the pkg information when you import a pkg into SQL Server 2005. Thanks Shabnam The SSIS Packages are stored in MSDB..SysDTSPackages90 table. Thanks, Loonysan http://mystutter.blogspot.com/ Its in msdb.dbo.sysdtspackages90 -Jamie ...Show All

• AlphaGhost Avoiding deadlock

  I have a stored procedure spUpdateClient, which takes as params a number of properties of a client application that wants to register its existence with the database. The sp just needs to add a new row or update an existing row with this data. I tried to accomplish this with code somethign like this. (The table I'm updating is called Client, and its primary key is ClientId, which is a value passed into the sp from the client.) IF (SELEC ...Show All

• Wei Wang father of twins How do you use the upgrade.exe for sqlce 2.0 to sqlce 3.0?

  Does anyone have any instructions on how to go about uprading a .sdf file from sqlce 2.0 to sqlce 3.0 I found this on an msdn website (link: http://www.microsoft.com/sql/editions/sqlmobile/upgrading.mspx ) but as you can see its very lacking on detail. (I included the link and content referring to upgrading the database files so you won't have to go to the link to see the part referring to upgrading the database.) I tried to run the upgrade.e ...Show All

• LI Engineer error opening SQL 2k DTS Package in Management Studio

  I'm trying to open a legacy DTS package in Management Studio and am receiving the following error: SELECT permission denied on object 'sysdtspackages', database 'msdb', owner 'dbo'. (Microsoft SQL Server, Error: 229) The server has not been upgraded to SQL 2k5 and is still running SQL 2k. My permissions have not changed and I can execute the packages using Enterprise Manager. My boss can access the same dts packages fine through Management Stud ...Show All

• kpthekiller Partition tables in SQL Server 2005

  I'm studing the partitions of SQL2005 for future implementation and I have some questions to make: * Can I associate more then on Partitions Functions to a table With this feature I want to know if I can have partitions combined with 2 or more table columns. CREATE TABLE [dbo].[OrdersRange] (     [OrderID]        [int]             &nb ...Show All

• msbhvn Import/Export data with SQL Server 2005 Express

  Hello folks! I have installed SQL Server 2005 Express and SQL Server Management Studio Express. Everything looks ok and works fine, but I can't find the Data Import/Export Wizard.  Can anyone tell me how to Import/Export data Thank you!!! Hello, Try: C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe Worked for me! Hello Everyone, Just after read ...Show All

• I_P_3_LEE failure in starting the process for the user instance

  High everybody, I have a set of winforms (.NET 2.0 assemblies) ( 6 total ) that each tries to open a connection to the same Database file using the same connection string. In the connection string, UserInstance is set to true. If each winform is started manually after opening the session on the computer, the connection to the database performs well for every winform. If the same winforms are automatically started at the opening of the u ...Show All

• Meadensi replication system stored procedures parameter defaults ?

  Hi there This is a pretty straight forward question. When using sp_droparticle or sp_changepublication etc, basically any replication system stored procedure. There are many parameters for these sp's basically all i want to know is if i provide the relavant paramaters,that is publication name, subscriber name , specific parameter i wish to change etc, are all the other paramters defaulted to the current publication/subscriber properties. In othe ...Show All

• Raghu81 Transform update sql statements into a pipeline

  Hi guys. I have 5 execute sql task in my control flow and its task is for updating only. Is there a way in order to transform this task into a single pipeline or are there any SSIS feature that I can use in order to improve the performance of this 5 tasks. you'r advice or help will be greatly appreciated. Thanks and more power... Larry, You can do updates from the data-flow pipeline using the OLE DB Command c ...Show All

• RC_SSIS Cannot generate SSI Context

  New install of SQL Server 2005 (x64) Standard after uninstalling previous version SQL Server (x86) Standard. After installation, client connections are receiving "Cannot generate SSI Context" error messages. TCP/IP Integrated Authentication is being used. Kerboros authentication is failing when SQLService is running under a domain account and works when running under local system account by reverting back to NTLM authentication. ...Show All

• leafnode Insert code in report

  Hi! I want to use methods from Visual Basic into Reporting Service, for modify fields. Fo example, I want to use a method for to round a number. Thx!! VB function can be referenced from the report's code object. Here is an example:   If you want to use the Math.Round function, place code similar to this in report's code block : shared function RoundNum( byVal Number as Decimal ) as Decimal   & ...Show All

• Anekro Derived Shape - Replacing a column with itself.

  Hi there, I have a derived column shape in which I replace a column with an expression. The expression is an IF statement - a true result sets a value for the column and a false result just uses the existing value of the column (ie it replaces it with itself) Like this. ColumnName DerivedColumn Expression ColumnA Replace 'ColumnA' ColumnB != ColumnC "y" : ColumnA But whenever, the condition is NOT m ...Show All

• KenMcCormack device is ambiguous in the namespace microsoft.directx.direc3d

  Can anybody tell me what this error message means.  I get it when trying to use directx3d.  The code is included below. I have checked and double checked that I have all the necessary references and includes.  Obviously I am missing something. Thanks Dick Imports System Imports System.Drawing Imports System.Windows.Forms Imports Microsoft.DirectX Imports Microsoft.DirectX.Direct3D Public Class Form1 Inherits ...Show All

• NJDESI Customizing BI Studio

  Folks,    I am still looking for pointers onto how I can customize the BI Studio (SSIS) environment. I need to add a custom menu to the SSIS menu options which is visible only for SSIS projects in BI studio. Thanks, ...Show All

• _Michael_D_ Where has my SSIS Package gone?

  I created a Package in the Import\Export Wizard, requested it be Saved on the server, and ran the package. But I can’t find any trace of the Package under SQL Server Management Studio. Where has it gone TIA, Barkingdog P.S. I remember the “old” days of sql 2000 where packages were proudly displayed, prominently, under the ”Data Transformation Services” option folder. Sigh ); ...Show All