Answer Questions

• szesteve OLE DB for DB2 Built on Dev run on Standard

  I have built a simple package using the Microsoft OLE DB provider for DB2 with SSIS Developer. If I schedule this on a Standard SQL2005 machine the package will not run. The error is blank, just says it had an error. Can I not run this package because the provider is not installed on this machine If so is there a work around for this you probably have to run your package on the box that has DB2OLEDB physicall ...Show All

• ChrisHanMSFT DHCP Service fails to start after installing SQL Server 2005 April CTP

  I have a Windows 2003 Server SP1, Active Directory, Application Server and RIS installed on my computer. After installing SQL Server 2005 April CTP my DHCP Service fails to start. In the Event Viewer I see the following Events. Event Type : Error Event Source : Service Control Manager Description : The DHCP Server service terminated with service-specific error 20013 (0x4E2D). Event Type : Information Event Source : Appl ...Show All

• DFMartinJr Returning objects from CLR Stored Procedure

  Hello All I have a few questions about how to return a DataSet object from a CLR Stored Procedure as an output parameter: Can this be done  I am having problems at execution time with declaring an output parameter of the type "DataSet". "Cannot find type DataSet" message, compiler/build does not complain, error occurs at execution time. This seems like one of the most obvious ways to create a more object-oriented approach using the tec ...Show All

• Kevin Blakeley "large value" data type(bcp)

  I want to store some binary things(pic and so on), so I create a table which contain a a "varbinary" data-type column. but 1. I used OPENROWSET to insert the large file in this table. 2. I used master..xp_cmdshell to retrieve data out as a file. One strange thing happened: the size of the input and output is really different(output is 1k bigger than the input file). and it seems that the file is broken with different file format. ...Show All

• ArthurNicholson The task "FTP Call" cannot run ...

  Hi I have created a SSIS package with an FTP call. I have it set to EncryptSensitiveWithPassword. I can manually run the package from my IDE. Once I build it, create a job, it fails. If you try to run the package directly from the Stored Packages in Integrations Services it fails with the following error: Error: The task "FTP Call" cannot run on this edition of Integration Services. It requires a higher leve ...Show All

• MSNBuger DataRecordTypeToBufferType not declared

  When I try to use the DataRecordTypeToBufferType and ConvertBufferDataTypeToFitManaged helper functions in my SIS script it tells me they are not defined. According to the doc they are in the Microsoft.SqlServer.Dts.Pipeline namespace, which I have included and the reference is there. It has been a few years since I have worked with visual studio so I am a little rusty, can anyone tell me what I might be missing Thanks! Harry Harry, Thes ...Show All

• Robbertos How to import files via HTTP in SSIS

  Hello, How can I import data into SQL server via http server Thanks The code is VB.Net which can be used within a Script Task in your package. To start, add two variables. Hope fully the names are self-explanatory- RemoteUri LocalFileName Ensure they are type String, and set some suitable values. Add a Script Task, and replace Sub main with Ash's code. The script references a variable to get the file - Dts.Variables("LocalFileName" ...Show All

• io1 Mailing Labels - Reporting Services 2005 - Multi-Column format

  I created a report to print Mailing Labels in 3-up format via mulitple column (3) Report Layout. Problem I am having is third column will not print. Print Preview mode shows all three columns just fine .... Whole Page, 100%, etc. I adjusted Column Width, Text Box Width, Report Body Width, everything. I am printing to fairly current HP LaserJet printers - LaserJet5 and LaserJet 9000n models. The only way to get third column to print is switch to ...Show All

• IanMB Did SP1 fix Query Optimizer issues w/ Partitioned tables?

  Hi there, We've implemented a partitioned table to a large table within our EDW. However, we'd discovered that the Query Optimizer was not able to understand parameterized queries. It basically was scanning all the partitions even though a parameter was passed defining the partition to use. Consequently, the queries need to hard code parameter values! Does anyone know if SP1 addressed this problem Thanks -Walter ...Show All

• lydiatwin Creating Reports on SQL Server 2005 Mobile Edition

  I am looking for a reporting software to create reports (Invoices, Receipts) for PocketPC 2003 using Visual Studio 2005 and SQL Server 2005 Mobile Edition. Any recommendations will be appreciated. Thanks, Alla In our development, we do it "by hands" and send to printer via a third party "PrinterCE". HTH, Fabien. At present SQL Server 2005 Mobile Edition doesnt have integration wi ...Show All

• Fraadl Full Text Search (2005) - How to determine word offset in CONTAINS query?

  Does anyone know if it is possible to determine the relative word offset (the Occ) from a simple-term query such as:- SELECT Comments FROM Production.ProductReview WHERE CONTAINS(Comments, ' "mountain biking" '); So, given the text:- "Maybe it's just because I'm new to mountain biking, but I had a terrible time getting used to these pedals." I would like the query would return both the text and the word offset of 8.  To me, it ...Show All

• chjl.cn Schema versioning - change schemaLocation, but keep same namespace ?

  Where you have an XSD schema, and want to create a new version of the schema that adds a couple of elements, is changing the schemaLocation hint a sensible way to indicate that an XML document is using a newer version of the schema Or is changing the targetNamespace the way to do this For example: notice the different value for schemaLocation: <mt395 xmlns="urn:incident:mt395" xmlns:xsi="http://www.w3.org/2001/XMLSche ...Show All

• moreno1978 save data selected in cube browser tab

  Hi, I'm using cube browser tab for browsing for interesting cube data. Once selection is made, I want to save results to file.  Also, I would like to use cube actions and their involved features to accomplich that. Is it possible to make my own custom save method, wich will be used from various application for cube browsing, such ProClarity is. Does someone know something about... with regards   ...Show All

• jimthesqlguy How to setup Sharepoint Portal Server 2003 with SQL Sever 2005

  Hello, everyone I try to set up Sharepoint Portal Server 2003 in SQL Server 2005 database (on Windows 2003 Server R2). But It cannot create new portal site... the Error message told about "cannot access instance..." (in fact that I input the correct instance, user, and password)... I wanna know that How to setup it... Setapong Hi,   Read the topic Deploying ...Show All

• Kuldeep R. Modi Can we download the DTS Designer?

  I am using SQL Server Express 2005 CPT April, and I would like to use the DTS Designer with it.  I have been looking for a download but have not found it yet.  Does anyone know where I can download it from or if DTS Designer is included in the tools that come with SQL Server Express   I haven't gotten those tools working yet. Thanks If you mean the Integration Services (we re ...Show All