Search results for query: *

------------ I'm trying to read several table/views from a third party database and combine them into one table in our sql database. I think I got the ssis package built the way I think it should be. but I'm getting error when I debug it. I think I got the variable setup correctly for what I'm...

we have a third party DB that creates a table for every new group added. ex group1 will have a table clmsgroup1 group2 will have a table clmsgroup2 etc all these tables in this database have the same column layout. how do I create a ssis package use a list of table names as a var...

I have 3 SQL servers, Server O - os 2003 – sql ver Microsoft SQL Server 2008 (SP3) - 10.0.5500. (Build 3790: Service Pack 2) Server T - os 2003 -- Microsoft SQL Server 2000 - 8.00. (Build 3790: Service Pack 2) Server P - os 2003 -- Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (Build...

Im getting the following error There is already an open DataReader associated with this Command which must be closed first. with this code at the second ExecuteReader() (is it the way I coded it or is it the sql 2000 engine?) Sub PrintBillCarriers(ByVal docType As String) Dim jeff...

what windows 7 pro media do I need to upgrade from xp home. ( looking at the PRO version, mainly for the xp mode option) as I understand it, a clean install is required. which as i understand it. the retail media version of windows 7 is only version that you can use for this(running about...

How do I tell what computer sent a PSshutdown command to my computer? last night at 6:30 my machine shutdown. the log shows the administrator account was used but no workstation id was listed. is there a way to log where the psshutdown is coming from??? TIA Tim

our DBmail app was working up until two weeks ago. not sure what caused it. -- the unsent queue is load with the 10 emails that did not get sent. SELECT * FROM msdb.dbo.sysmail_unsentitems go --- db mail is started USE msdb; go EXEC sysmail_help_status_sp; go --- broker is active (1) SELECT...

I need help in coding VB 2008 so that it can combine several word document into one to be used for a mail merge template. I need to: 1) combine the word doc (does not work see note 1) 2) use this new doc a for the mail merge (works, only for the rewrite doc) 3) create a pdf. (works, only for...

Error msg: "[MSDASQL].CLMCSP" from OLE DB provider "MSDASQL" for linked server "claimfs3". Conversion failed because the data value overflowed the data type used by the provider. [SQLSTATE 42000] (Error 7341) OLE DB provider "MSDASQL" for linked server "claimfs3" returned message "Multiple-step...

when certain jobs are running I can not open the Store procedure object list in the 2008 sql database. I'll get "lock request time out period exceeded, MS sql error 1222" why would a job that is running lock the database, so that I can't work on it? and what can I look at to correct this...

I'm told that this might be a configuration problem. (was suggested I post it here) I have a html page that is generating the following error: "The specified CGI application misbehaved by not returning a complete set of HTTP headers. The headers it did return are." the page is a html page (no...

I have a html page that is generating the following error: "The specified CGI application misbehaved by not returning a complete set of HTTP headers. The headers it did return are." the page is a html page (no asp, vb code) with a link to a .exe patch download. when I try to download the patch...

I need help with a loop to save change on page 2 that where selected on page 1 Page 1 - lists all games owned by a users, a check box shows which games the user has. page 2 - is called when the user clicks the save button. the following code works, it addes the user to the user table, and...

here is a test code that I'm tring to use to see if I can insert into my database. (I can select from the database.) I'm new to asp and not sure what I'm complete doing. I was able to create several retrieval screen now I need to work on insert and update. currently using access 2000 ( sql...

I've found a patch that will allow me to use USB devices on a NT 4.0 server. works great. Does any know where I can get a set of generic USB mouse drivers? Or how to fix the following Problem: I'm using a Razer Lachesis gaming mouse that the NT 4.0 server does not recognize, the NT 4.0 box...

we have three sql servers. one running win 2000 and sql 2000 (box P) one running win 2003 and sql 2000 (box T) the other win 2003 and sql 2008 (box O) all servers talk(ed) to the database on an AIX box. (box P) (jobs scheduled after 1 am) running for 2 yrs no problem talking to database on...

sorry if I posted this in the wrong place, none of the forums macthed this problem I'm having. problem: running sql server 2008 on windows server 2003. the jobs are trying to read data from a database on an AIX box. all jobs run without issues, most of the time. so far three times this...

I'm have a script that will list the XML's and did not produce a PDf. getting the list of Pdf's works, but now I need to get policy number from the xml file. InStr is returning the pos number but I would like the text. here is the code. Set FileList = objWMIService.ExecQuery _...

we have a windows 2000/2003 server that we use to Authenticate logins. we also have a aix 5.0 system that we map a drive thru windows. when I login the the morning I try to connect to the aix drive. (using a share id) I'm unable to reconnect to the drive for about 30 minutes. then i'm able to...