Search results for query: *

...single quote as being the end of what is to be executed and will attempt to run that and the remenants of the string. It will try to run select x.*,getdate() as datum from openrowset(''SQLOLEDB'',''SERVER1'';''user'';''pw'','' select anr,alist,aidnr, (select sum(bpstueck) from...

...The format 109 wants the format to be mon dd yyyy hh:mi:ss:mmmAM (or PM) Using the replace function creates that format. Hope it helps Kevin ************************************************************** Rock is Dead (Long Live Paper and Scissors)...

...right("00" + val_in, 2) end function This can then be passed into the CreateFolder function at the end of any root path you want. Hope it helps ************************************************************** Rock is Dead (Long Live Paper and Scissors)...

....... With the number of columns you need to create, it may be easier to try to use syscols to help generate the case statement. Hope it helps ************************************************************** Rock is Dead (Long Live Paper and Scissors)...

...line set @as_select = 'bcp "DATABASENAME..ct_rl2cpcs"' where DATABASENAME is the database which holds the ct_r12cpcs table. Hope it helps ************************************************************** Rock is Dead (Long Live Paper and Scissors)...

...if it doesn't exist. Given that the file is for reading only, this doesn't make sense. Try removing the final "True" Hope it helps Kevin ************************************************************** Rock is Dead (Long Live Paper and Scissors)...

Olivia Apparantly, the port for 2005 Express is randomly assigned and can be viewed through the SQL Server Config Manager. Under Network Config and on the IP addresses tab, is TCP Dynamic Ports, this value is the one which you will need to connect the Content Store on. I think the port can...

...I used Access) you should use the original code to generate a new table, and replace the existing one with the new one. Hope it helps Kevin ************************************************************** Rock is Dead (Long Live Paper and...

...= t2.Status This gets the min status date as a sub-select and assigns it to each of the PO records with the same status Hope it helps Kevin ************************************************************** Rock is Dead (Long Live Paper and...

...'prefilter' to the end of the field/calculation. For the prefiltered fields, it will be as if the filter were not added. Hope it helps Kevin ************************************************************** Rock is Dead (Long Live Paper and...

...for the transform, make the source a sql statement rather than a direct table/view source. The sql statement will be along the lines of select *, sysdate, 'PICK' from table where sysdate is the pick sql command for the current system date c) in the transformations for the job, highlight...

...into a SQL table As the source for the transform, use both the excel data and the 7 record 'day' table with the following sql statement select a.*, b.* from 'excel data' a, 'day table' b Note there is no join. Create an activex transform and use code as follows: start code: dim retnet...

...data formatting. In which case, either change the variable data type, or put conversion functions into the sql statement. Hope it helps Kevin ************************************************************** Rock is Dead (Long Live Paper and...

...in the group by clause. That will then give you all of your 'duplicated' fields as a single record with the latest date. Hope it helps Kevin ************************************************************** Rock is Dead (Long Live Paper and...

...= DTSSource("Col001") & "-1" End If x = DTSTransformation_OK end if --end code Hope it helps Kevin ************************************************************** Rock is Dead (Long Live Paper and...

Hi, Have you renamed the database in the Catalog Tables section on the right hand side of the Menu>>Catalog>>Tables screen? The 3 database icons represent (from the top): The database definition (from the database drop down) The SQL Server database name (where data is actually stored) The user...

..."message" I hope that this is clear enough for you. I know it works as I use it to re-use batch files in my own DTS packages. Kevin ************************************************************** Rock is Dead (Long Live Paper and...

...cn.open "SQL SERVER NAME", "USER NAME", "USER PASSWORD" 'get the count for the source table str = "select count(*) from DATABASE..TABLE" set rs = cn.execute(str) no_recs = rs.fields(0).value 'close objects and set to nothing cn.close set rs=nothing...

...want to change the catalog, you can take a copy of the catalog, make the changes in the copy and then overwrite the main catalog. Regards, Kevin ************************************************************** Rock is Dead (Long Live Paper and...

...unique identifier). There will be a date on each record returned, but the value will be the same for each customer number. Hope it helps Kevin ************************************************************** Rock is Dead (Long Live Paper and...