ssis packages - SQL Server Forums

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

General SQL Server Forums

New to SQL Server Programming

ssis packages

Author

Topic

sravanim
Yak Posting Veteran

58 Posts

Posted - 2012-06-15 : 11:26:38

I am logged into the sqlserver management studio in production server using my authentication not service account.Ssis package code corresponding to scheduled job code is in E-drive in prodction server.I didn't find the ssis package code(E-drive) corresponding to the scheduled job .Can you please suggest how can i see the code?

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2012-06-15 : 12:05:24

You mean you have a remote connection to the server and have loaded management studio there?
Have you looked at the location using explorer.

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-06-15 : 15:49:42

What do you mean by this?

Ssis package code corresponding to scheduled job code is in E-drive in prodction server

do you mean actual package file called by scheduled job? Are you storing packages in file system or sql server?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

sravanim
Yak Posting Veteran

58 Posts

Posted - 2012-06-18 : 03:16:01

@visakh16
I mean package file called by scheduled job.Package files are stored in file system i.e in E-Drive.

sravanim
Yak Posting Veteran

58 Posts

Posted - 2012-06-18 : 03:26:04

@nigelrivett
I have remote connection to the production and devlopment servers.when i tried to find the location using explorer it shows please insert E-Drive.

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2012-06-18 : 06:12:45

Is the package in the E drive on the server. Does the sql server agent have access to it?
If you load management studio on your workstation it will look in the E drive on your workstation not on the server.
Similarly if you try to add the job step from your workstation.

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.

sravanim
Yak Posting Veteran

58 Posts

Posted - 2012-06-18 : 06:30:25

Yes E-Drive is on the server.Sql server agent with proxy account has full access to it.I am connected to the database in my workstation through sqlserver management studio it is looking for my workstation E-Drive.

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2012-06-18 : 06:40:52

Remote on to the server and add the job frrom there or script the job pointing to your local drive, change the script and run it against the server.

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.

sravanim
Yak Posting Veteran

58 Posts

Posted - 2012-06-18 : 07:00:46

When i am trying to do as you told error message came as only a member of the sysadmin server role can add a job for a different owner with @owner_login_name.when i connected to the server through staging server path E drive is there but when i am login into the server through remote desktop it is not there..please suggest me

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2012-06-18 : 07:06:45

Sounds like the user yoou are logging in as doesn't have permission to do this.

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.

sravanim
Yak Posting Veteran

58 Posts

Posted - 2012-06-18 : 07:16:31

I have access to the server.how can i know whether i have admin access or not?

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2012-06-18 : 07:24:12

The error message yoou got says that yoou haven't

Try
sp_helpsrvrolemember
select IS_SRVROLEMEMBER('serveradmin')

Also enable xp_cmdshell (if it isn't already) and try
master..xp_cmdshell 'dir e:\'

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-06-18 : 12:01:52

quote:
Originally posted by sravanim

I have access to the server.how can i know whether i have admin access or not?

why not use UNC path if you're configuring it from your machine. you should still be needing proxy crendential though

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources