Showing posts with label dts. Show all posts
Showing posts with label dts. Show all posts

Monday, March 19, 2012

Cannot work with Scrip task

Hey guys,
It's sort of madness I guess. :))
I use Script Task.
It has no code inside, but "Dts.TaskResult = Dts.Results.Success"
I execute package. I'm getting error

Error: 0x5 at Script Task: The script files failed to load.

Task failed: Script Task
What is it? How I can fix it? What's wrong?
Thanks.

Check out this thread ...

http://forums.microsoft.com/msdn/showpost.aspx?postid=68546&siteid=1

Donald

|||Thanks. It works.

Cannot view the DTS

Hi ,

I have DTS created in my Development server using the save as option i tried to save it in my production server . All these works fine . But when i logged in to the production server i could not see the DTS . But when we tried loging to the prodcution server using the data base administrator passed we were able to see the DTS and the owner of the DTS is seems to be not a admin person rather it is me.

Why is that i am not able to view the DTS when i logged in with my user id ?

Can any on help us in resolution this issue .

Thanks

K.Karthik Doss

refer this... it may help u ... http://www.sqldts.com/212.aspx

Madhu

|||

Hi Madhu

Thnaks for the efforts . I think i have not made it clear for you .the problem what we have the DTS in the production server but the Owner is not able to view the DTS . but we were able to see the DTS in DB admin access . so what should be done to view the dts in the owners login .

Thanks

K.Karthik Doss

|||

have u checked the owner of this DTS in Production server... Is it still the same ?

Madhu

|||If your login is not a part of SYSADMIN group on the production server, then what you are getting is by default. If that package is owned by SA then only SYSADMIN privileged uses can view or edit.|||

Yes i was able to view the DTS thru the DB Admin userID and Password and the owner is me. But i could not view it when i logged in thru my UserID and Password .

|||

say if the package is owned by SA then how do i change that to a comman , Like if any one logs in to the system can view that package .

|||

AFAIK... there is not direct method in SQL Server 2000 ... yes u have Specific role available in SQL Server 2005(db_dtsadmin,db_dtsltduser etc)... in SQL 2000, if all the users want to view the package owned by others ... then u need to add all of them in SysAdmin Role, which is not recommened atall ..

Madhu

Tuesday, February 14, 2012

cannot save storedproc after SP3

hi
we found a bug in EM. we are unable to save/export/transfer a DTS package to
another remote box. is there any workaround or hotfix available?
AlexAlex
See if this helps
http://www.sqldts.com/default.aspx?6,105,204,0,1
Regards
John|||How are you trying ?
File | Save As | SQL Server ?
File | Save As | Structured Storage File ?
Transferring DTS Packages
http://www.sqldts.com/default.aspx?6,105,204,0,1
--
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"alex" <ntnewsNO@.SPAM.hrz3.hrz.tu-darmstadt.de> wrote in message
news:OgI#tPoUDHA.1280@.tk2msftngp13.phx.gbl...
> hi
> we found a bug in EM. we are unable to save/export/transfer a DTS package
to
> another remote box. is there any workaround or hotfix available?
>
> Alex
>|||hi
> How are you trying ?
> File | Save As | SQL Server ?
> File | Save As | Structured Storage File ?
this are 3 "save as" options in SP3 and 4 "save as" options in SP2 and
prior.
the third in SP3 is "Visual Basic File". in SP2 there is another Option
"Save as DTS package file" (sorry - the options is gone - i don't know the
exact name). we need this DTS package option for transfer...
Alex

Sunday, February 12, 2012

cannot run DTS Package from SQL Query Analyzer

I attemped to run dts package to transform data from AS400/DB2 by using Client Access ODBC ( Ms Windows 2000 Server, Ms SQL 2K, Client Access Driver 4.5)

but the result of testing has messed me up

because when i used this command via SQL Query Analyzer

exec master..xp_cmdshell 'DTSRun /S "MySVR" /U "sa" /N "dtsTEST" /G "{482209FD-0891-11D8-868C-00E0299B4BCF}" /A "G1":"8"="200310" /W "0"'

but it doesn't work

I wonder why.. because it can be executed in MS-Dos prompt successfully.
if I type

DTSRun /S "MySVR" /U "sa" /N "dtsTEST" /G "{482209FD-0891-11D8-868C-00E0299B4BCF}" /A "G1":"8"="200310" /W "0"

in the command line.

If somebody know please give me some advice (urgently!!).What is the error?

When run from dos it will be run on your client m/c. When from query analyser on the server using the sql server service account (probably)

Try logging on to the server as the sql server service account and running it in the designer and see what happens.|||I didn't run dos-command on Client M/C, I tested on Server M/C itself
and it success.

But when I tried to run by query analyzer, it takes much time (> 20 min and nothing happens) for executing and there was no error show on the screen. so I had to kill the process because it seemed not work .
And this process I tested on Server M/C also, by using Sql Admin (sa).

How could I solve this problem?|||It can be run properly in DTS Designer, but cannot run in Query analyzer.|||Does it have any user interaction - have you left in a debug msgbox?

I meant the account that the sql server service uses to logon - see services.
Maybe it needs access to something that this account doesn't have permission on.|||I checked already that the log on user-id has full permission, and the sign on user name and password for AS400 has been specify in DSN that use via client access express driver by setting the sign on information as 'use windows user name and password, no promping'.

If this problem is related to the security of sql server, why it can be run in DTS Designer(which has no pop up message box for user interface) with no popup error message and the result of transformation is correct.|||Because dts is a client application.
When you run it from query analyser the client is the server which gives it a different environment.

If you have already run it from the sql server service account then that limits the things that can be wrong.
Try turning on logging to see if any steps are run and what the error is.|||why i can run DTS Package in query analyzer if i change the source of DTS to be MsAccess file, on the server m/c not client. run in command line, no problem also.

why i cannot run in query analyzer if i specified source DSN as AS400/DB2, but run properly in command line by using same script.