Hi Jim P.,If you just follow the DTS Import Wizard in SQL 2000, use the text provider for the source (NOT EXCEL for CSV!!), point to your CSV file, then in the file format dialog, use delimited, text qualifier Double Quote, and First Column has column names if your file looks like your sample... Then […]
2004-12-03
I'd dig into the data. If it's returning things you don't expect, I usually look for data problems.
2004-10-19
IT would not be difficult to use SQL-DMO to iterate throught each of the instances and run sp_who or sp_who2 then display ther results on a web page or in an application.
2004-08-18
Another question that has been posted incorrectly. Isn't anyone validating these questions before they are being posted? Come on. So they slip 1 every now & then. Look at the discussion, realize what you & the rest of us are learning. I am far more curious about how the submittant of this QOD came to […]
2004-07-27
Currently when using DTS, I am doing so using the wizard. All I do is choose a source, namely the text flat file on the server and then I select the fixed field format and then set the columns. After that I choose the destination SQL Server. At this point I have tried to transform […]
2004-07-15
nothing like using a sledgehammer to kill a flea, but how this function which you pass the begin date, end date and what date part you want using 1 or 0 (year, month, weeks, days, hours, minutes) Function is: Alter FUNCTION ExtendedDateDiff(@BeginDate datetime, @EndDate DateTime, @iYear integer, @iMonth integer, @iWeek integer, @iDay integer, @iHour integer, […]
2004-07-13
I get the following message after a file has been locked by a long running job (which fired a DTS package) which I had to stop. "Cannot delete filename. There has been a sharing violation. The source or destination file may be in use." Other than reboot the server, is there any other way of […]
2004-07-13
486 reads
i assume your using 2005 express beta...?? if so then when you get it working can you tell me how to create a datbase?????? i've installed and all you can do is turn services on and off...WOW!!! i've installed VB 2005 as well and that will only allow me to access the SQL 2000 installation […]
2004-07-13
in the Jump to URL box try:="http://www.website.com/default.asp?ID=" & Fields!Quote_Header_ID.Valuenote the equals at the beginning and the position of quotes.hth.
2004-07-13
2004-07-12
1 reads
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers