Can you perform a simple select from the table? I populate a warehouse from an AS400 each night but I simply drop the SQL tables first and read all records from the tables on the 400. There is something about the select that your 400 doesn't like. I am using the IBM Client Access for the...
What about setting up another server running 7.0 without upgrading your current production server. Then use the new server only for the DTS product.
Jim
There is also a public domain utility to backup and restore packages. It is called DTSBackup. It has a typical point and click interface and is a little easier that opening each package one at a time and saving as. If you are only moving a few then stick with the open, file save as method.
Jim
Alex,
A few things to check: Make sure that both the client computer and the server are running the same SP version. This is important due to the changes made in SP2. You should always use the UNC name for source and destination files in every package so that it will be "runnable"...
Yes, It was a GUI screen containing properties of the server. Memory, lock, thresholds, logins and a bunch of other setting that I can't remember. You could set the value in the gui and then restart the server and the change was made. You could also change the setting with system stored...
Is there a utility or other method to genereate script for a DTS package? I have several DTS packages that I would like to be able to generate and print script for. Many of my DTS packages contain multiple indiviual transformations using activex / vbscript. I want to be able to verify my...
Are you sure it won't do it anyway, if you ignore the warning? I know this was a settable option in 6.5 but I'm not sure where in 7.0 to change this. I have used the Access upsize wizard to do what you are attempting and actually recall seeing the same type of message. From what I remember...
When a DTS Package uses activex / vbscript is it possible to add additional source and destination columns to the transform? The transform lists the source and destination fields once you have selected them, but I don't see a way to add another field later. Frequently, I would like to add...
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.