GarethKeen's Q&A profile

• SQL Server Can I use Custom UI for executing Package in C#?

  Hi I've a doubt. I don't know whether it is possible or not. I've a very less knowledge in DTS packages. When I execute a package in C#. it is displaying predefined GUI for showing process. Can I've my own UI when executing DTS. Thanks in advance. Thanks for the reply Michael I'm using SSIS I'm putting the C# code here public partial class Form1 : Form { public Form1() { InitializeComponent(); } Package package; ConnectionManager ConMgr; Package p; private void Form1_Load(object sender, EventArgs e) { string pkg ="Package.dtsx"; Microsoft.SqlServer.Dts.Runtime.Application app = new Microsoft.SqlServer.Dts.Runtime.Application(); p = ...Show All

• Commerce Server Biztalk Catalog Integration

  Is it possible to setup the Biztalk integration with the Catalog Manager to delete variants when importing with Incremental changes. I have tried creating the XML file with the variant I no longer want not present in the file but if I go into catalog manager I can still the variant after import. Please Advise. Hi, The variant delete worked after changing the Transaction Mode to "Non Transaction" on Send Port. Not sure, why it has to be Non Transactional.. ...Show All

• SQL Server Execute SQL Task speed

  I've created a SSIS package, in a sql 2005 instance, that uses an Execute SQL Task" to call a stored proc as its last step. When run from BIDS, the last step takes about 2 to 3 minutes, consistently. When I run the exact same query from Management Studio (either via exec <spname> or by copying the sp's t-sql code into a query window) it consistently takes about 1 minute. I've run sevral test and these number are quite reproducible. Any ideas to account for the "slowness" of the Execute SQL Task TIA, Barkingdog The first task truncates a table called Contact. The second task imports a CSV file into a table (uses a SQL Server Destination. Does a straight copy of the dat ...Show All

• Visual Basic Not able to include reference to Microsoft Excel 11.0 Object Library

  I am having problem in adding the reference of Excel com in to a Visual studio 2005 project. I can select the Microsoft Excel 11.0 Object Library in the add reference window, but the same is not added to the project reference. What is the deal I need help. I checked the C:\Windows\assembly for the assembly and it is there as Microsoft.Office.Interop.Excel. Thanks. Works fine for me.... You can ensure install the Office Primary Interop Assemblies and see if that helps. http://msdn2.microsoft.com/en-us/library/aa159923(office.11).aspx ...Show All

• Visual Studio Team System Multiple Batches on SQL Scripts

  We currently generate our SQL scripts as multiple batches, e.g. If Exists....Drop, Go,Create Store Proc, etc.. I receive errors that Create must be the first batch in a script and no GO statements are allowed. Will this be addressed as I would prefer to keep all SP/Views as Drop/Create statements instead of Alters. If not, can the build process be modified to include this behavior We always store create statements in the source files for each object. When the build script is generated, we will create alter scripts for the objects if they already exist in the target database. There isn't an option to force build to drop then create objects if the object already exists in the target database. But ...Show All

• SQL Server Date out of range?!

  Greetings! I have a data source that gets generated based on a variable with the following SQL : "select * from result where deletion_ind = 1 and when_deleted >= '" + (dt_str, 50, 1252) @[User::Last_Run_Date] + "'" But when I run my package I get an error message saying: The conversion of CHAR to DATETIME resulted in a DATETIME value out of range The Last_Run_Date variable is set to '2006-06-25 14:35:05.450' When I run the code in a QA session it works, but in the package it complains! What am I doing wrong Thanks for your help in advance. Does the error get thrown by SSIS eval;uating the expression or by SQL Server when it gets executed If the latter...use SQL Profiler to c ...Show All

• .NET Development wsdl.exe bug for wsdl with shared output message value

  I have generated web service client proxy use wsdl.exe from a wsdl file. But when I try to instantance the the proxy class I get "method XXX can not be reflected" error. I found out the reason seems to be that there is two web service methods that has same value for message attribute in the output element. For example: <operation name="method1"> <output message=" Output " /> </operation> <operation name="method2"> <output message=" Output " /> </operation> Is it a bug in wsdl.exe Because accouding to WSDL standard, the value for message attribute does not have to be unique. Since I can not modify the wsdl file, Is there anyway th ...Show All

• Windows Search Technologies Blue scrren of Death

  Not sure if i should post this on here but ill give it a go,my mums computer keeps getting the blue screen evreytime windows xp starts.she starts in safe mode and also last good config and evreything starts up fine,the desktop comes up but after a couple of secs the blue screen comes up with the usual message and a error code STOP[:0X000000F4,(0X0000003,0X86599448,0X865995BC,0X805C7478 and the only way to exit is to turn the power off at the back as anybody got any ideas please Hi, I can see that nobody has responded to this thread and I've done some research as I had the same issue and some other blue screens of death. Along with this one, I have also gotten 0x00000077 which is directly related to disk ...Show All

• SQL Server Derived Column or script

  Dear All, I am pretty new to SQL2005 technologies. I have a table like this: Name Code Peter 10 Eric 20 I am interested in translation of the “code” to “job role”: Name Code Job role Peter 10 Director Eric 20 Consultant I have tried to use Derived Column and also script – but I am unable to get it to work. Any hints/solution would greatly appreciate. Best Regards, T The translation is hardcoded which is fine. However the number of options are more than 2 "consultan" and "director& ...Show All

• Visual Studio 2008 (Pre-release) Resize window with transparent window

  Hi its possible enable resizing window, with params WindowsStyle="none" Background="Transparent" AllowsTransparency="True" With ResizeMode CanResizeWithGrip, is resizing possible only on right down corner. I need complex side resizing on transparent window. Any idea how do that I cant find any possible way to write custom resizing. Thx a lot There's no built in way to achieve this. However, you can use win32 interop to get this working. Please refer to my reply on this thread on how to listen to win32 messages. Now, to enable resize, you can start listening to WM_NCHITTEST message and return one of the suitable HT values defined in the documentation of WM_NCHITTEST . You will have to handle this message ie. set handl ...Show All

• Visual Basic Change system time using vb.net

  Does anyone know how to change the system clock using code. I want to be able to set the date and time in my code. Any thoughts Thanks!!! This is not doing what i want. what I want to do is connect the system time to my program i have a interface where the user can go in and click (for example: the + and - button to increase or decrease the number to change the hour and minutes.) I want them to be able to change the time and date as if they were doing it using the windows date and time properties. When they change the time in the program i want the system clock to also change accordingly. I know how write code to set the current date and time by clicking a button. I just need to know how to get the clock ...Show All

• SQL Server MDX Query never finishes

  I am populating flatfiles from MDX queries run i SSIS against AS databases. I have ran in to problems with MDX queries returning large resultsets that never finishes. The query performed is purchase calculations over different time periods for each member in the customer dimension. There are 6-8 calculated members created and the customer dimension contains about 3,5 million members. When query is run, after 1-2 hours the server stop allocating memory and starts to get data from cache in intervals. In the end of each interval, memory is dropped. In perfmon it seems to be no activity during long periods I have given it as long as over 3 days without any result. Server is 8 x 64bit cpu with 16 gig memory. Some help in this ...Show All

• .NET Development PrintDocument leaves a large bottom margin on some printers

  I'm trying to print a Bitmap which fills a complete A4 page (portrait). I use the following code: PrintDocument pd = new PrintDocument (); pd.PrinterSettings.PrinterName = printer; foreach ( PaperSize ps in pd.PrinterSettings.PaperSizes) { if (ps.Kind == PaperKind .A4) { pd.PrinterSettings.DefaultPageSettings.PaperSize = ps; break ; } } pd.PrinterSettings.DefaultPageSettings.Margins = new Margins (0, 0, 0, 0); pd.PrintPage += new PrintPageEventHandler (pd_PrintPage); pd.Print(); private void pd_PrintPage( object sender, PrintPageEventArgs e) { e.Graphics.InterpolationMode = System.Drawing.Drawing2D. InterpolationMode .HighQualityBicubic; e.Graphics.SmoothingMode = System.Drawing.Drawing2D. Smoo ...Show All

• SQL Server How do I quit the package ?

  Hi, I have a main package that drives other child packages and under some conditions in one of the child packages, I decide to quit the whole thing. How do I do this Thx, -chiraj Thanks for responding. What I am trying to do is I will be automating my package and under some conditions, I need to terminate the execution of the whole package. For example. the main package calls several child packages and in one of the child packages, I detect that I need not continue with the execution and I need to do a high level "exit". Not by kicking up a failure code. Just write a message to stdout and terminate the whole execution. How do you do that Thanks -chiraj ...Show All

• Visual Studio Team System running test cases on remote machines

  Hi, I want too run my test cases on remote machines. How an i do that using VSTS regards Vikas Hello Vikas, You will have to install the Team Test Load Controller on any machine and Team Test Load Agent on the target machines (the ones which will run the tests). Then in the test run configuration editor specify the tests to be executed remotely and point to the machine with Controller installed. Regards, Boris ...Show All