Viewing 15 posts - 316 through 330 (of 381 total)
I couldn't believe what you were saying until I tried it. My only guess is that the collection cannot handle a variant (all variables in VBScript are variant, not string...
May 26, 2005 at 6:23 am
Enjoy these moments. SQL Server 2005 will morph to SQL Server 2020 and the kid is going to wish that you were not around (and definitely not a geek).
There are...
April 12, 2005 at 7:32 am
Still think we need to figure out how to harness the energy of 8 year old boys.
Russ
April 5, 2005 at 4:30 am
Would there be some way to put a COM wrapper around the assembly and use com in your stored procedure?
Russ
January 25, 2005 at 5:31 am
What tool are you using to connect to SQL Server? I think that information will help people find a solution.
Russ
January 25, 2005 at 5:27 am
What you need to do is create a pseudo index. Create a new query in Access, go to the SQL View. Then enter
Create unique index PK_TableName on TableName (FieldName) with...
June 22, 2004 at 5:54 am
Are there any locks on the files?
You can set a setting in the package properties to log to sql server (which puts information from the steps into a table in...
June 9, 2004 at 5:58 am
Look at http://www.sqldts.com/default.aspx?225
Russ
PS: As if you needed reassurance, I think that your plan will work very well. I have done the same thing with other components. It prevents users...
June 8, 2004 at 8:43 am
There is a little note in BOL "Guidelines for Using the FOR XML Clause:" Generally, FOR XML cannot be used for any selections that do not produce direct output to...
May 28, 2004 at 1:03 pm
To me the major advantage to certification is what you learn in the process. I am a database developer, who has acted as dba in a couple single server shops. ...
May 13, 2004 at 6:40 am
I cut my teeth on DTS by using the import wizard. I do an import, choose the objects to import, then rather than running the import right away, I save...
May 13, 2004 at 6:30 am
I'm not sure what you are doing. Let me suggest what I think you are saying and a solution.
You have 20 steps in your package. I am going to guess...
April 6, 2004 at 5:49 am
Is the ODBC a system (machine) DSN or a User DSN? It needs to be a System DSN to work.
Russ
February 24, 2004 at 5:21 am
A couple things to look for: What version is the SQL Server ODBC driver on the Web box?
Run profiler and connect to the server that your web page is connecting...
February 20, 2004 at 6:49 am
There is no way to do this using T-SQL.
You can do it using visual basic. This http://www.sqldts.com/?208 explains how to run a dts package. You can run a similar program...
February 20, 2004 at 6:37 am
Viewing 15 posts - 316 through 330 (of 381 total)