Viewing 15 posts - 1,666 through 1,680 (of 2,486 total)
You can also use SQL's sp_makewebtask in conjunction with a template file to generate a HTML page.
I do this for most of my little maintenance reports that are emailed using...
October 21, 2004 at 1:18 am
Just make copies of your current connections and then create another datapump task between the new connections.
Once you have the two Datapumps defined, create an "On Success" workflow betwen them.
You...
October 13, 2004 at 1:52 am
Fetch Buffer Size sets the number of rows of data being fetched from the source.
If you're contiunally loading 100,000's rows everytime you run the package, you can adjust this up...
October 13, 2004 at 1:49 am
Use xp_smtp_sendmail from http://www.sqldev.net
October 13, 2004 at 1:46 am
What version of Progress are you accessing? We have Progress 9.1d here and use DTS to extract data on a nightly basis.
We've found that using the supplied MERANT 3.60...
October 13, 2004 at 1:42 am
I've had it installed for a week now. Collecting information without any problems.
The biggest improvement that has been made is the addition of a command line parameter so you can...
October 12, 2004 at 6:28 pm
Usually the best resource for these error codes is a Google Groups search.
October 5, 2004 at 5:26 pm
You cannot change Report Manager.
The only way you can do this is by developing your own interface.
October 5, 2004 at 5:25 pm
What are your packages doing?
We have 30 odd packages that run on a nightly basis that extract data from a Unix based Progress database using ODBC.
The timings for our extracts...
October 1, 2004 at 1:02 am
Change the query to this and you should see the records that are causing the problem.
If zero values are valid for the "Installed" and "Applicable" fields, then wrap your division...
September 24, 2004 at 4:36 am
Use an ActiveScript task to re-write the SQL statement.
September 24, 2004 at 4:29 am
Use an ActiveScript task to re-write the SQL statement.
September 24, 2004 at 4:29 am
I don't that's problem. I'm thinking it's something to do with the the fact that it's a workflow script, not just a regular ActiveScript task.
I changed it to this and...
September 24, 2004 at 4:17 am
You need to create a reference to the task object first.
Eg: Set objTask = DTSGlobalVariables.Parent.Tasks("Exec Package Name")
objTask.Filename = "filename"
Or you can use a Dynamic Properties task.
September 23, 2004 at 4:17 am
You'll need to setup a couple of global variables in a the package along with a Dynamic Properties task. Use the dynamic properties task to set the appropriate properties on...
September 22, 2004 at 6:53 pm
Viewing 15 posts - 1,666 through 1,680 (of 2,486 total)