Thanks for your help. I guest I am doing things right then. I was hoping there might be an easier way.
We have currently 2 copies of a database on the same server. We want to copy the jobs so that they run for both. The reason for this is that we are...
It is stating that the file CMSOHIO.S10FA72E.XJLUTZ.STKBAT1006 does not exitst. It does however exist.
None.
We have files on the AS400 that are named as atl0107, atl1206 and etc. We need to be able to retrieve the appropriate file to be ran in a stored...
We do not know when or how it happened but we can not see the subscription information for our reports. We need to change these. Also, it does not...
The DTS package runs a stored procedure and creates a file that we then format and send to another server as an Excel file.
The problem is that the file is the from file. Example abc1106 - 1106 being the month year. Each month the file name is changed to the month year...
I have a Visual Basic ActiveX Script that keeps timing out. This is in a DTS package that only contains the ActiveX.<br /><br />We are using MS SQL...
We have a file on our AS400 - DB2 that is named accordingly: skmb1006 - the name is made up of skmb + mm + yy I have created a link to the folder...
Have you checked out Embarcadero? Their site is www.embarcadero.com. It is one of the leaders out there. I personally use it and love all the...
Each month a file is created that contains the date at the end of the file. I would like to create a stored procedure that would obtain the correct...
I would like to thank all of you for your help. I have now successfully got the file copied over to where it is needed and able to have a job ready...
I have a file created as tab delimited that I need to copy to another non SQL server. Any suggestions on how to do this. Both servers have Windows...
This does not tell what is wrong. The errors come out on jobs that start thru the job scheduler. Sometimes we can go for weeks without an error....
We are running MSSQL 2000 and every so often we get the following when running jobs: Executed as user: MANSFIELDPVSQL. OLE DB provider 'MSDASQL'...
I fixed it the long way. I created a series of updates with the check for the period being a 1,2,3..... according to the update.
The table I get info from looks like this: Note it is only 2 years worth I am showing. 2006112006-01-01 00:00:00.000 2006112006-01-02 00:00:00.000...
Currently it is on Sundays only. However, next year they are thinking of going to a calendar based. This however may change at any time. Currently...
Separate names with a comma.
