Search Results | SQL Server Performance Forums

SSIS Package performance tuning - 5 tables betwenn 5000 and 15 million rows

Thread by: SQL_Guess, Feb 28, 2008, 15 replies, in forum: SQL Server 2005 Integration Services

The challenge: I have to extract and convert data between 2 SQL server systems - only 4 tables on the source systems, 8 tables on the target system....

Possible issues with SP2 and sp_send_dbmail?

Thread by: SQL_Guess, Apr 25, 2007, 4 replies, in forum: SQL Server 2005 General DBA Questions

Have a funny one that I've not yet resolved, and was wondering if I am the only one. SQL2005 SP1 server, Ent Ed, 64 bit, clustered machine. SP2a...

DTS Data pump question

Thread by: SQL_Guess, Dec 6, 2006, 1 replies, in forum: SQL Server DTS-Related Questions

This may be a simple question, but I've had the good fortune (?) until now of not having ad to do anything with DTS. Unfortunately, that has changed,...

heavy CPU on on 1 of 16 cpu's...

Thread by: SQL_Guess, Oct 17, 2006, 2 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi all. We have an interesting situation we are trying to understand. Running SQL 2005 64 bit SP 1 hotfix rollup (9.0.2153) on SQL 2003 SP 2. We...

CASTING binary to char but NOT converting

Thread by: SQL_Guess, Oct 9, 2006, 3 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hi all, I'm trying to find a way to chagen a binary value into a char string with the SAME binary values, in a performant manner. In SQL 2000, it...

SQL 2005 long running job threshold exceeded

Thread by: SQL_Guess, Sep 22, 2006, 3 replies, in forum: SQL Server 2005 General DBA Questions

We are seeing, on a Test server running SQL2005 SP 0, several MOM alerts with the following type of message: "Description: The SQL Server Agent Job...

[SOLVED] SSIS dynamic SMTP mail server name

Thread by: SQL_Guess, Sep 13, 2006, 3 replies, in forum: SQL Server 2005 Integration Services

Hi All, I'm trying to make my SEND MAIL TASK in SSIS dynamic, by retrieving SMTP Server name (amongst other email message information) from a table....

Using XML variable as a table

Thread by: SQL_Guess, Sep 11, 2006, 1 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hi All, Using SQL2005, I'm trying to improve the performance of some code that is currently using: OPENXML, sp_xml_preparedocument and...

trying to change data when importing

Thread by: SQL_Guess, Aug 31, 2006, 1 replies, in forum: SQL Server 2005 Integration Services

Hi all, Having some fun with an excel import. I have a excel sheet that has data that needs to be UpSert'ed into 2 different...

SSIS using excel source to update/insert sql table

Thread by: SQL_Guess, Aug 29, 2006, 1 replies, in forum: SQL Server 2005 Integration Services

Hi all, I've had little success gooling/searching for this (so far). Given a simple spreadsheet: StoreNumber StoreName 1...

Trying to generate full XML result with CDATA

Thread by: SQL_Guess, Aug 21, 2006, 2 replies, in forum: SQL Server 2005 General Developer Questions

Hi all, I'm using SQL 2005, sp0 and sp1 (that is, I've tested against both). I've trying to find a way to have my SP return the...

export to excel - formatting number output

Thread by: SQL_Guess, Aug 17, 2006, 7 replies, in forum: SQL Server 2005 Integration Services

Hi all, Once again, SSIS is giving me a 'F.U.N.' time (ask for definition of the F.U.N. acronym another time <img...

a way to generate dynamic 'for xml path'?

Thread by: SQL_Guess, Aug 4, 2006, 7 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

I currently have some T-SQL generated as a column: SELECT BL.[CatalogueItemBuyListSequenceNumber]as "@__Value" FROM...

SQL 2005 check for existance of proxy

Thread by: SQL_Guess, Jul 28, 2006, 0 replies, in forum: SQL Server 2005 Integration Services

I'm try to find a good way to create the LOGIN, USERS, GRANTS, CREDENTIALS and PROXY for an SSIS Package to be executed from an agent job using...

advice/suggestions re: pivot usage

Thread by: SQL_Guess, Jul 6, 2006, 2 replies, in forum: SQL Server 2005 General Developer Questions

Hi all, Please look at the attached - I think it works, but I'm looking for some comments/advice. Included is table creation, samepl data...

SSIS Script Task to check for File Existance

Thread by: SQL_Guess, Jul 3, 2006, 5 replies, in forum: SQL Server 2005 Integration Services

Hi all, Let me apologize in advance for what I know is a very basic question, but so far I'm not being terribly successful trying to find sample code...

Problem with ForEach container for Excel file impo

Thread by: SQL_Guess, Jun 30, 2006, 3 replies, in forum: SQL Server 2005 Integration Services

What I'm trying to achieve is a SSIS package that will pick up 1 or more excel files, process the data in them via the conditional splitter, pushing...

Importing an entire text file into a varchar(max)

Thread by: SQL_Guess, Jun 19, 2006, 2 replies, in forum: SQL Server 2005 Integration Services

Hi all, It's another work day, which means it's another question from the bemused... [:I] I have a flat file source - a text file that will...

SSIS invoking SP and getting output

Thread by: SQL_Guess, Jun 15, 2006, 1 replies, in forum: SQL Server 2005 Integration Services

Hi all, I'm having some fun tryhing to understand/use variables and parameter's and expressions with SSIS. I have a Execute SQL...

Import XML file via Bulk Insert?

Thread by: SQL_Guess, Jun 12, 2006, 2 replies, in forum: SQL Server 2005 General Developer Questions

Hi all, Looking at trying to get an XML file imported into a table for manipulation. Given this piece from BOL, I have hopes that Bulk Insert in...