Viewing 10 posts - 1 through 10 (of 10 total)
Its sitting on a SQL Server 2008 table.
One thing that has helped is setting the On truncation to ignore rather than fail component. I looked through the data and...
November 26, 2009 at 2:42 pm
Well, granted this is different in that it returns the column names of those containing the queried value. I found it here: http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/the-ten-most-asked-sql-server-questions--1#2
CREATE PROCEDURE FindMyData_Number
November 23, 2009 at 1:18 pm
I have a number of questions.
1. Are you using the Excel Source?
Yes, although I've tried converting the data to csv format and importing it using the flat file connector. ...
November 17, 2009 at 3:20 am
Duh. Right, sorry.
November 12, 2009 at 9:06 am
Why not use SQL Server Integration Services? In SSIS 2008, you can use the import/export wizard to specify the input as an Excel file. You can then choose...
November 12, 2009 at 9:01 am
No actually I just want a monitoring tool that identifies the most common performance issues and allows me to export it into a common file format, such as csv, tsv...
August 5, 2009 at 2:10 pm
Is it customary for the customer or the remote DBA provider to furnish the VPN? I was thinking of setting up a VPN with SSL for my practice so...
July 30, 2009 at 12:47 pm
Do you want to send me your resume, location and hourly rate to firstname.lastname@example.org.
Looking forward to it,
July 19, 2009 at 11:46 pm
Hmm...thanks for the comments.
Obviously, coming from the developer world I might be "certified" but short on experience. I'm going to partner with a much more seasoned DBA to ensure...
July 19, 2009 at 7:24 pm
Would you mind emailing me offline to talk about the problems you've faced? I really want to make sure that what I offer people doesn't give them the...
July 19, 2009 at 5:35 pm