Viewing 15 posts - 46 through 60 (of 66 total)
This sub works for me and we don't have Office installed on the server. Maybe it's rights as PhilM99 suggests.
Sub CreateFile(strFileName))
Dim myObject, myWorkBook
Set myObject = CreateObject("Excel.Application")
myObject.visible =...
February 14, 2006 at 7:18 am
Wow!
I only have a few minutes left, but dataset 1 is all SUM()s of dataset 2, named the same and such...
Use the Union statement
Example:
SELECT SUM(myitem) AS myitem FROM...
February 7, 2006 at 2:40 pm
This is a DNS issue. You need to check with your network guys and have them resolve it for you.
February 7, 2006 at 1:42 pm
Go to the Microsoft Update webpage and download the GDI+ Detection Tool.
February 7, 2006 at 1:40 pm
You might want to check out the Web Services part of Reporting Services....
February 7, 2006 at 1:28 pm
A custom front end to the Reporting Service Web Service:
February 7, 2006 at 1:18 pm
Can you share the SQL statement with the join? You can generalize it.
February 7, 2006 at 1:07 pm
Try this:
On the original server, save the DTS package to a Visual Basic File.
Open it up in Notepad, do a find and replace for the old server name to the...
February 7, 2006 at 12:23 pm
BTW,
Be sure to comment the msgbox out before you schedule the package.
February 7, 2006 at 12:09 pm
I assume you are running it in the designer screen:
In the ActiveX Script, trap the error and make the script display the key data should an error be found. ...
February 7, 2006 at 12:07 pm
Maria,
So this stored procedure returns a result rowset or a cursor of a result rowset?
Maybe the "cursor" is the result rowset, but I have always related a cursor to...
February 7, 2006 at 11:50 am
If that does happen, then you can use ActiveX to rejoin the fields:
DTSDestination("FullName") = DTSSource("LASTNAME") & ", " & DTSSource("FIRSTNAME")
February 7, 2006 at 8:58 am
"In Oracle exist a StoredProcedure that return a cursor ref, because we process data before to return a set of result.
The target of that cursor ref that is returned by...
February 7, 2006 at 8:19 am
Nothing comes to mind except an ActiveX task that uses ADO.
February 3, 2006 at 2:29 pm
Viewing 15 posts - 46 through 60 (of 66 total)