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...

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...

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,

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,

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...

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...

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.

It may be something as simple as using the MS Access Linked Table manager and refreshing the links.

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...

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...

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...

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...

Have you tried SQL Server's GetDate() function?

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...