execution of .dtsx package in stored procedure

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

execution of .dtsx package in stored procedure

Author

Topic

nicky_river
Yak Posting Veteran

55 Posts

Posted - 2010-08-12 : 07:08:15

Hi,

Could anyone tell me how we can execute a .dtsx package through a stored procedure ?

Please provide me a code if possible.

kashyap_sql
Posting Yak Master

174 Posts

Posted - 2010-08-12 : 07:41:18

http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/4cd6b488-c10c-47f2-8235-7ddaca5243a2
try the link if it will help you

With Regards
Kashyap M

slimt_slimt
Aged Yak Warrior

746 Posts

Posted - 2010-08-12 : 15:55:09

please explain what is your problem, with the name of dstx package, and your sql table. i'll try to guide you through.

Kokkula
Starting Member

41 Posts

Posted - 2010-08-13 : 01:19:10

Hello,

In SQL Server 2000 it is executed from a stored procedure as below:

EXEC master..xp_CmdShell 'DTSRUN /S' + @@SERVERNAME + ' /E /N' + Package_Name + char(32) + Parameters + char(32) + '/Ags_server_name=' + @@SERVERNAME

PackageName: Name of the package on the server.
Parameters: Parameters if any to the package.

Hope its clear & helpful....

Pavan
Infosys Technologies Limited

nicky_river
Yak Posting Veteran

55 Posts

Posted - 2010-08-13 : 01:40:58

Hi Pavan,

what if there are no paramaters to the procedure ? then what do i replace it with ?

nicky_river
Yak Posting Veteran

55 Posts

Posted - 2010-08-13 : 02:21:53

Hi Pavan,

Is this the right syntax ? it is giving an error "Incorrect syntax near '+'."

EXEC SQL_Training..xp_CmdShell 'DTSRUN /S' + @@SERVERNAME + ' /E /N' + Package.dtsx + char(32) + '/Ags_server_name=' + @@SERVERNAME

If possible please provide me with the right syntax.

Lara11
Starting Member

1 Post

Posted - 2010-08-13 : 03:05:15

hi
The first page your reader will see is the front cover. Get it wrong and you will likely lose the sale. Start with the benefits of your product, or use thought-provoking statements that motivate the reader to pick up the brochure and open it. Tell the reader there's something inside just for them -- an exclusive invitation, a free report, a special discount, or advance notice of sales. Don't put just your company logo or product name on the front. That will not work.

______________________________________________________________
Want to get-on Google's first page and loads of traffic to your website? Hire a SEO Specialist from Ocean Groups [url=http://oceangroups.org/] seo pecialist [/url]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources