Viewing 15 posts - 1 through 15 (of 44 total)
The way I work this is:
Declare
@CrLf char (2)
SET @CrLf = char(13) + char(10)
select @cmdtxt = "echo "+ @string1_to_write + @CrLf + @string2_to_write + @CrLf" >> c:\temp\myfile.txt"
I had a rough time...
February 8, 2008 at 10:48 pm
Yelena,
Well, I finally figured it out. I had the 'table name' misspelled! What a bummer, but if you're still interested, here's the script:
'ListApps.vbs
' by Butch Hoffman - 29-Jan-2005
' This script...
January 29, 2005 at 12:45 pm
Yelena,
I understand, and I have several scripts actually working, but I'm still new at this and I was looking for the piece that would add the records to a database.
Thanks,
January 24, 2005 at 3:54 pm
Yelena,
Do you by any chance have a .VBS example that will read the registry and stuff the info into either an Access or SQL database? I'd be most interested.
Thanks,
January 23, 2005 at 2:28 pm
Connor,
You didn't state whether your files to import all have a common .EXT, but if they do, you can use a DOS Copy command like this
copy /y drive:\path\*.csv drive:\path\import_me.txt
Then you only...
December 12, 2004 at 7:51 pm
I, too, think that this site is ACES! I've learned so much here and BOL is sometimes so hard to find stuff in it's rediculous. I'm sure there'll be lot's...
December 12, 2004 at 4:56 pm
Karen,
Look at this article on sqlservercentarl.com:
http://www.sqlservercentral.com/columnists/CCathers/searchingthefilesystem.asp
It has ALL the code you need, all you have to do is make some simple changes to meet your needs and it works.
November 15, 2004 at 8:38 pm
It may be something as simple as using the MS Access Linked Table manager and refreshing the links.
October 24, 2004 at 12:34 pm
Mitch,
Check BOL for "Cast and Convert"
Here's some examples of JUST date or JUST time or both:
select CONVERT (varchar(20),GetDate(),100) --Gets default date/time
select CONVERT (varchar(12),GetDate(),101) --Gets JUST the date
select CONVERT (varchar(12),GetDate(),102)
select CONVERT...
October 21, 2004 at 10:03 pm
Larry,
If it was MY call it would be FOUR drives, system, SQL, Databases and Log Files.
Right now we have System on the first drive, SQL, the databases and logs on...
October 21, 2004 at 9:32 pm
I ran into this problem a couple weeks ago. Found that if I gave the SQL machine (not a user) access to the folder on the network with all privs EXCEPT...
October 19, 2004 at 12:04 am
October 19, 2004 at 12:01 am
I think you could do something in your DTS packages that has a VB Script to check for the DONE file. Something like:
'**********************************************************************
' Visual Basic ActiveX Script
'**********************************************************************
Function Main()
Dim objFS
Set objFS...
October 18, 2004 at 11:23 pm
I ran into this problem a couple weeks ago. Found that if I gave the SQL machine (not a user) access to the folder on the network with all privs EXCEPT...
October 18, 2004 at 10:55 pm
Viewing 15 posts - 1 through 15 (of 44 total)