Search Results | SQL Server Performance Forums

Fuzzy lookup??

Thread by: jarrodr, Feb 26, 2009, 3 replies, in forum: SQL Server 2005 Integration Services

Hi all, I have 2 tables, a Persons table (alot of records, where the surnames could be enter incorrectly due to human error) and a Surname table (has...

Text file must be ANSI

Thread by: jarrodr, Oct 13, 2008, 0 replies, in forum: SQL Server 2005 Integration Services

I output information to a text file, it is in unicode and works perfectly but when I try output in ANSI I get an error. Whats the...

Edit the Report manager web page?

Thread by: jarrodr, Jul 31, 2008, 1 replies, in forum: SQL Server 2005 Reporting Services

I have SQL Reporting Services 2005, I have deployed my reports... now I can view them on a web page, but how do I edit the standard web page format?

Passing Parameters in select clauses

Thread by: jarrodr, Jul 9, 2008, 4 replies, in forum: Getting Started

Hi all,Making use of parameters, how do I pass parameter to choose the columns/fields of a table. I know parameters are used in WHERE clauses to...

How to convert mySQL to msSQL with SSIS, using SQL Server 2005???

Thread by: jarrodr, Jun 5, 2008, 9 replies, in forum: SQL Server 2005 Integration Services

I have a msSQL DB and want to convert some tables/DBs to mySQL... How do I do that using SQL Server 2005?

Comparing data and integrity between two tables

Thread by: jarrodr, Jun 4, 2008, 3 replies, in forum: SQL Server 2005 General DBA Questions

Hi everyone, I have recently converted my DTS packages to SSIS and deployed them to the new server. I have the 2000 and 2005 server running...

Error storing data in text file???

Thread by: jarrodr, May 27, 2008, 3 replies, in forum: SQL Server 2005 Integration Services

The error I recieve is as follows: "[Flat File Destination [13]] Error: Data conversion failed. The data conversion for column "SDATA" returned...