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.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Activex Script

Author  Topic 

nitin1353
Constraint Violating Yak Guru

381 Posts
Posted - 2007-02-26 : 20:56:24
Gurus
I have a DTS running in Sql Server 2000 and it is a Activex script.Now i want to migrate this DTS in 2005?Can you please explain the steps..
My problem is when i execute this package in 2005 in busines intelligence studio it turns red..
What does that mean?Itz a simple script which calls some URL

Please help
Regards
Nitin

tkizer
Almighty SQL Goddess

38200 Posts
Posted - 2007-02-26 : 21:04:32
I'm not sure how you expect us to help with the very little information that you have provided.

Tara Kizer
Go to Top of Page

nitin1353
Constraint Violating Yak Guru

381 Posts
Posted - 2007-02-26 : 21:18:37
Hi Tara
Sorry for the little information..This is the DTS
//**********************************************************************
// Java ActiveX Script
//************************************************************************

function Main()
{
objXMLHTTP = new ActiveXObject('Microsoft.XMLHTTP');
objXMLHTTP.open('GET', "http://ipaddress:2093/BondMarketupdateFile.aspx", false);
objXMLHTTP.send();
return(DTSTaskExecResult_Success);
}
Now i am creating this DTS in 2005.
I am going to SQL Server business intelligent strudio and then i go to file and new project and then i select integration services project==>>create a new folder where dts would reside==>>and then i go to toolbox and drag activex script to the main page==>>right click ==>>edit and then i select the script option and then i copy the script==>>and in entry method i wrote main()..and when i right click and execute then i get the error..
Please help
Let me know if i ma missing somethin

Regards
Nitin
Go to Top of Page

nitin1353
Constraint Violating Yak Guru

381 Posts
Posted - 2007-02-26 : 21:24:24
And when i execute it the package turns yellow and then red..

Regards
Nitin
Go to Top of Page

nitin1353
Constraint Violating Yak Guru

381 Posts
Posted - 2007-02-27 : 14:15:15
tara
I have got some success,i have transfered these packages from sql server 2000 by using the task..when i manually run that p[ackage itz running fine..but when i create a job..it sayd sucess but the file which this package is creating is nt being created..

Can anyone plz help
Regards
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts
Posted - 2007-02-27 : 14:17:30
To test out jobs that run packages, you need to log into the SQL Server using the SQL Server service account. So you need to either get to the console of the server where SQL Server is running or use some remote tool such as Remote Desktops, Terminal Services, etc...

Then manually run the package (not through the job but rather execute the package from the GUI).



Tara Kizer
Go to Top of Page

nitin1353
Constraint Violating Yak Guru

381 Posts
Posted - 2007-02-27 : 14:26:45
Tara
I am using RDC to connect to the server.I am on the server itself.Plz guide me how do i go?
Regards
Nitin
Go to Top of Page

nitin1353
Constraint Violating Yak Guru

381 Posts
Posted - 2007-02-27 : 14:28:40
And how do i run the package manually from GUI?
from business intelligence stidio??

Regards
Nitin
Go to Top of Page

nitin1353
Constraint Violating Yak Guru

381 Posts
Posted - 2007-02-27 : 14:40:56
And Tara i should use "Enable server proxy account"??Because currently this option is not running

Regards
Nitin
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts
Posted - 2007-02-27 : 14:41:27
I've never used packages in SQL Server 2005, so wherever the designer is.

Tara Kizer
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts
Posted - 2007-02-27 : 14:43:19
quote:
Originally posted by nitin1353

And Tara i should use "Enable server proxy account"??Because currently this option is not running

Regards
Nitin


You certainly shouldn't enable options that you don't know anything about. I don't know anything about that option or where you are seeing it, so you will need to research it.

Tara Kizer
Go to Top of Page

nitin1353
Constraint Violating Yak Guru

381 Posts
Posted - 2007-02-27 : 14:48:44
Tara
To test out jobs that run packages, you need to log into the SQL Server using the SQL Server service account==>>you meant when in sql server properties we go to security tab==>there we have two options ==>>system account and this account....

Regards
Nitin
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts
Posted - 2007-02-27 : 14:59:49
No that's not what I mean. Do you know what account is running the SQL Server service? If so, go to the console on the server where SQL Server is running. Log into it using the SQL Server service. Then run your package from that server.

Tara Kizer
Go to Top of Page

nitin1353
Constraint Violating Yak Guru

381 Posts
Posted - 2007-02-27 : 15:17:20
Tara
M getting confused..should i check for this in services..if yes itz showing me local system...

Regards
Nitin
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts
Posted - 2007-02-27 : 15:22:15
Yes. And if it is local system, then that makes it very hard to troubleshoot why the job is failing. I don't have any suggestions when the service is using local system.

It is recommended that the SQL Server service as well as the SQL Server Agent service use a domain account that has local admin privileges on the database server.

Tara Kizer
Go to Top of Page

nitin1353
Constraint Violating Yak Guru

381 Posts
Posted - 2007-02-27 : 15:26:11
Tara
I will tell you the exact scenario
I have sme packages in sql server 2000 and i have migrated these packages in sqlserver 2005..now when i migrate these packages and run the package manually there ,it gives me corrct result,,
and now with the same package when i run it with a job and try to schedule it and after scheduling it when i start the job it says success but the files are not made..Also what should i select in "on sucess action" and "on failure action "

Regards
Nitin
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts
Posted - 2007-02-27 : 15:32:09
quote:
Originally posted by tkizer


I don't have any suggestions when the service is using local system.


quote:
Originally posted by nitin1353


Also what should i select in "on sucess action" and "on failure action "


It depends on what you want to do when success or failure occurs. If you don't want to do anything, then select the option to quit the job on Success/Failure.

Tara Kizer
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site