sql-access.blogspot.com
SQL,access denied: ActiveX Script Task being ran twice?
http://sql-access.blogspot.com/2012/03/activex-script-task-being-ran-twice.html
Sunday, March 25, 2012. ActiveX Script Task being ran twice? I currently have a DTS package that contains an ActiveX Script Task. This script creates a report and saves the report in the database (for scalability reasons.) When I execute the step in Enterprise Manager it generates two entries in the database, it should only create one. If I take the script out of the DTS package and run it using CScript.exe it only creates one entry in the database. Has anyone run into this problem before? Activex script...
sql-access.blogspot.com
SQL,access denied: ActiveX VBScript problem
http://sql-access.blogspot.com/2012/03/activex-vbscript-problem.html
Tuesday, March 27, 2012. Below is a code snippet that is throwing the following error:. Error Source: Microsoft DTS Package. Error Description: Error Code: 0. Error Source= Microsoft VBScript runtime error. Error Description: Object required: 'Server'. Error on line 13. In my code line 13 is the following:. Set Cnxn = Server.CreateObject("ADODB.connection"). I did set up a Microsoft OLE DB connection in my DTS package for this. ActiveX Task. I'm new to VBScript and ActiveX. Any help would be. In my code ...
sql-access.blogspot.com
SQL,access denied: ActiveX Scritping was not able to initialize the script execution
http://sql-access.blogspot.com/2012/03/activex-scritping-was-not-able-to.html
Sunday, March 25, 2012. ActiveX Scritping was not able to initialize the script execution. I get this error ActiveX Scritping was not able to initialize the script. Whenever a VBScripts is exe agaist SQL Server. The oddity is all works under. My NT account fine. Use anybody elses account or our service account it will. Not work and you recieve the message above. A google search on the error came back with many hits. See if this helps. Http:/ www.sqldts.com/default.aspx? Subscribe to: Post Comments (Atom).
sql-access.blogspot.com
SQL,access denied: ActiveX Script Task] Error:
http://sql-access.blogspot.com/2012/03/activex-script-task-error_25.html
Sunday, March 25, 2012. ActiveX Script Task] Error:. I'm trying to reset the below Global varialbe in SSIS - Activex script. Main = DTSTaskExecResult Success. Getting the below Error when executing the package. ActiveX Script Task] Error: Retrieving the file name for a component failed with error code 0x060339E4. Please provide me solution for this. You can read and write global variables from ActiveX Script, but I have to ask why bother when you have the much more powerfull VB.net in the Script Task.
sql-access.blogspot.com
SQL,access denied: ActiveX VBScript DTS IsDate
http://sql-access.blogspot.com/2012/03/activex-vbscript-dts-isdate.html
Tuesday, March 27, 2012. ActiveX VBScript DTS IsDate. Can someone explian why I get a return of not a valid date when using. ActiveX vbscript for DTS:. Msbox "I cant figure this out". Msbox "I cant figure this out" pops rather than msgbox "OK"Your Select Case statement is malformed. Try:. MsgBox "I cant figure this out". Lebeau777@.hotmail.com wrote in message. News:1143836184.567616.6570@.z34g2000cwc.googlegroups.com. Can someone explian why I get a return of not a valid date when using. ActiveX Script ...
sql-access.blogspot.com
SQL,access denied: ActiveX to warm up Report Server ?
http://sql-access.blogspot.com/2012/03/activex-to-warm-up-report-server.html
Sunday, March 25, 2012. ActiveX to warm up Report Server? Because the IIS threads are recycled at night, the first user that calls up Report Manager in the morning has to wait 30 seconds before the page loads, as IIS is creating a thread. I'd like to set up a job in SQL Agent that will navigate to http:/ localhost/reports/ every morning before users come in to work, so they won't have to wait. Anyone knows how to navigate to a page in VBScript? I meant SQL Agent job, of course, not SAL. I have set it in ...
sql-access.blogspot.com
SQL,access denied: ActiveX Script Task - Help!
http://sql-access.blogspot.com/2012/03/activex-script-task-help.html
Sunday, March 25, 2012. ActiveX Script Task - Help! I have a script that is run in Excel or Access that automatically runs the c. Ode I have cut/pasted below. I attempted to cut/paste into an activeX task,. But doesn't work. Would anyone be able to convert this to vbscript? Thank you in advance for your help,. Attribute VB Name = "CD-1291". On Error GoTo CD1291 Err. Dim Y As String, M1 As String, M2 As String, D1 As String, D2 As String, d A. S String, L1, L2, sd As Date. Y = Year(Now() - 1). Print #1, "...
sqlaccessing.blogspot.com
Accessing more than: adding a query as parameter using 'contains' logic
http://sqlaccessing.blogspot.com/2012/03/adding-query-as-parameter-using.html
Thursday, March 29, 2012. Adding a query as parameter using 'contains' logic. Setting parameter ranges for a query is very useful. How can I specify : begins with . and make that a parameter (in this. Case first 5 digits of a project name)? Liek %[parameter3]% does not work. What should it be? Help much appreciated,. An over-his-head Texas Tonie. If you want a range of values, look at the BETWEEN operator. For character. Strings, however, the whole issue of collation and sort order needs to be. Adding a ...
sqltoolformsde.blogspot.com
SQL tool for MSDE: alignement data
http://sqltoolformsde.blogspot.com/2012/03/alignement-data_29.html
Thursday, March 29, 2012. My application has production server and backup sever for data reporting . There is some tools in SQL 2K (or third part tool) for alignement data at. Run time between two servers? Are you talking about transforming data? Have you explored DTS? Server Books Online for more information. Vyas, MVP (SQL Server). Http:/ vyaskn.tripod.com/. Stefano perab" stefano.perabo@.speedautomazione.it wrote in message. News:%23wzR3DxbEHA.556@.tk2msftngp13.phx.gbl. Run time between two servers?
sqltoolformsde.blogspot.com
SQL tool for MSDE: aliasing two columns in SQL
http://sqltoolformsde.blogspot.com/2012/03/aliasing-two-columns-in-sql.html
Tuesday, March 27, 2012. Aliasing two columns in SQL. Here is my original query:. Select rosterid, lastname, firstname from table. I would like to use column aliasing to display. Lastname, firstname in a column entitled name. I tried the following syntax, but it's not working:. Select rosterid, lastname ', ' firstname as name. This results in a 2 column table with the headings "ROSTERID" and. NAME" However, NAME contains th last name only, rather than "lastname,. Any help greatly appreciated. Google Jenn...
