Search results for query: *

Apologies to all. The tracing being used in my case (not the same as MSDN example) was overwriting the last error value. The actual last error is now found to be 5 (ERROR_ACCESS_DENIED). This makes sense.

See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fileio/fs/findfirstfile.asp for example usage.

When using findfirstfile, it returns INVALID_HANDLE_VALUE, with getlasterror set to 183 (error_already_exists). Can anyone explain what this error means in this context?

bcp can be used instead of isql. The file output will exactly match the results of the query.

Thanks. I'll use bcp instead. I was already aware of bcp but was checking if there was another way of using isql to achieve what I wanted.

When outputting to a file with isql under SQL Server 2000, even if the select statement uses RTRIM on a column, it is still output with trailing spaces. Is there any way to force the removal of the trailing spaces?

In the copy of the package, when I explicitly changed the "Server:" in the Connection Properties for the "Microsoft OLE Provider for SQL Server" (this is also known as the DataSource property) from the original server name to the new server name, the package works as required. I was hoping not...

Under SQL Server 2000. I have a DTS Package which runs a query in an Execute SQL Task which references @@servername. This works fine. However, when I did a "save as" to copy the package to another server, and execute the package on the new server, @@servername strangely appears to return the...

Oops. It appears that I made a syntax error in the query. It should have read <b>SELECT '\\servername\folder\'+REPLACE(CONVERT(varchar(10),getdate(),3),'/','')+'.csv'</b> using single quotes in the REPLACE function. It then works. If I had tried clicking on "Refresh" when setting up the query...

I am trying to use a Dynamic Properties task for the first time. I have a DTS Package containing a transform data task which outputs to a file named "\\servername\folder\xxxxxx.csv". I have set up a dynamic properties task which uses a query SELECT...

For yymmdd format, try:- select convert(char(6),getdate(),12)

If you have a table, say, with 2 columns Nominal number (N1,N2,...Nn) Casualty? (Y/N) Is there an easy way of selecting (deriving) an (ordinal) casualty number, which is not stored as a column. e.g. if you had the following data N1 Y N2 N N3 Y N4 Y N5 N selecting...