Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
malawneh
Starting Member
24 Posts |
 Posted - 2008-10-16 : 12:41:03
|
| I Have a SSIS Package that is producing monthly billing statements. The monthly statements are Crystal Reports XI reports. The SSIS Package I have created runs through all providers in the database and creates a crystal report that is stored on the SQL Server in a designated directory. Once in the Directory they are printed by a printing department.The package makeup is as so. Step one gather all providers that need a statement for the given time range. Step 2 is loop through all those provider statements found. Step 1 is a SQL task,Step 2 is a For Loop Container. Within the For Loop I call an ActiveX Script that actually makes the call to the Crystal Report Runtime and passes the parameter of the provider to it and outputs the report in PDF to the report directory on the SQLServer. The Package runs with out any hicups. I go to create a SQL Server Job and that executes the same package and everthing works returns no errors. It just completely skips the ActiveX Script. I have run Profiler against it and it shows the commands hitting the loop and looping but competely ignores the ActiveX Script. Why does the SQL Server Agent not recognize the ActiveX portion of the package?I have tried using a proxy account with a domain admin as the credential and still no luck. Just a note: the crystal report is on a web server within the same domain and a domain admin account through the SQL Server Job still will not work. Any help just getting a job to recognize an ActiveX script would be greately appreciated.Thank you all.Michael Alawneh, DBA |
|
|
|
|
|
SQL2005 Job vs ActiveX