Msg 102, Level 15, State 1, Line 1

Incorrect syntax near ','.

is the error message I receive. The command runs in full

Jeff

Thanks for the Idea. The commands I need to run are above. They will not fit into the space.

This code counts the records in a database by table....

I have not been able to code a request for file metadata (date created)

I am able to delete a file there providing I have the name of the file.

I...

I was just informed the machine and environment of my ftp server is

Mac OS 9.1

sorry Forfiles is not a command on my machine or the ftp server. But thanks for the idea

Wayne

Windows Vista Ultima

Service Pack 1

on a Dell Studio 1737

Intel (R) Core(TM)2 Duo CPU P8600 @ 2.40ghz 2/40ghz

4.00 gb

32 bit operating system

Mark

Wayne

Thank you so much. I was attracted to thei article because a vendor is using SP_OACreate and SP_OAMethod. And I wanted to learn more about those commands.

I...

Here you go. I places an attachment of a screen shot

Phil

this seems to be a problem. After I save the dtsx file, close and try to reopen the file is in an error state and I cannot reopen the...

I am currently having the same problem did you ever have a resolution to this issue.

And If so can I please have it

Demin99

That is exactly the one that gives me the error. I started with that example and move to the msdn link

I have tried this method several differant ways.

I get the fowwong error

TITLE: Package Validation Error

------------------------------

Package Validation Error

------------------------------

ADDITIONAL INFORMATION:

Error at Data Flow Task [Excel Source [1]]: The AcquireConnection method call...

Is this going to be a one-time job? Yes Daily

So you receive MYFILE01012009.txt, then MYFILE01022009.txt... each day? Yes

Will all the MYFILE... have the same format? Yes

Will all the YOURFILE... have...

I have a table with the names in it. Or the directory could and should be polled for the names of the actual files.

Try this to write output to text files

😛

Set ANSI_Nulls on

set QUOTED_IDENTIFIER ON

Declare @cmd varchar(1000)

Declare @WorkfileName varchar(128)

Declare @WorkDir varchar(100)

Select @WorkfileName = 'test1.txt'

Select @WorkDir = '\\Phivmfile001\ds\Production\Input\Tests\'

Select @cmd = 'echo ' +...