I initially executed the package locally from my own machine. But, after developing the package and exporting to SQL Server. I ran it directly from Management Studio on the server. I am going to go back and see which version of PDFSharp I used. Since I developed locally on my 32 bit machine I...
Created and SSIS package in VS 2008. The package contains a script task with a reference to an assembly for PDFSharp. I ran a build on the script containing this assembly. After saving the package changes I ran a build on the project containing the package to create the manifest file for the...
These blogs were extremely helpful Markos. I appreciate you giving the links. I would much rather learn the methods opposed to having it given to me. Not that it matters but I ended up going with the Windows Function - One Stage query. Now that I have a solution and can get my report out I will...
I am using SQL Server 2005. I have two joined tables one for Accounts the other for Work Orders. For each Account there can be many Work Orders. A simple example of this data structure would be the following:
Accounts Work Orders
-------- -------------------
100 100, 1/1/2009...
I am using MS SSRS 2005. I created a report with two date parameters for From and To to filter for all records on a specific day (normally yesterday). The parameter Non-queried default values are currently set to
DateFrom: =format(dateadd("d",-1,Now()),"M/d/yyyy")
DateTo...
Maranello, take a look at Thread 181-121256. Databaseguy addresses this issue in detail with some helpful links to Microsoft Knowledge Base.
This will probably answer the questions you have about automating Excel.
Good Luck!!!
I have a form with text boxes that a person can enter information in that is then used to search a table. When a "Load" command button is pushed a SQL statement is built using the info in the textboxes. This SQL statement is then used as the rowsource of a listbox.
I have another...
If anyone can help me out with this I would be eternally greatful.
While I was off last friday someone doing data entry into our database control-alt-deleted to exit as the database hung. When she tried to re-enter she received the following message "MSACCESS.EXE has generated errors and...
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.