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.
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?
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.