Executing a task in ssis package

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

SQL Server Administration (2005)

Executing a task in ssis package

Author

Topic

prodigy2006
Yak Posting Veteran

66 Posts

Posted - 2009-10-01 : 07:45:30

A developer raised a ticket to run a specific task in a ssis package. He attached the package to the ticket.
I saved the package to my local and thought of running through BIDS but later figured out that I need to have Solution to run the package.
Is there a way to run a task in a package without having the solution?

Thanks,
Sunny

prodigy2006
Yak Posting Veteran

66 Posts

Posted - 2009-10-01 : 13:28:05

Could someone please reply to this topic?

Thanks,
SUnny

vijayisonly
Master Smack Fu Yak Hacker

1836 Posts

Posted - 2009-10-01 : 13:29:11

check out the "dtexec" statement

dtexec /f "FullUNCpathofyourpackage.dtsx" /CONFIGFILE "FullUNCpathofyourconfigfile.dtsConfig"

prodigy2006
Yak Posting Veteran

66 Posts

Posted - 2009-10-01 : 16:46:13

Could you please explain a bit in detail?

quote:
Originally posted by vijayisonly

check out the "dtexec" statement

dtexec /f "FullUNCpathofyourpackage.dtsx" /CONFIGFILE "FullUNCpathofyourconfigfile.dtsConfig"

vijayisonly
Master Smack Fu Yak Hacker

1836 Posts

Posted - 2009-10-02 : 09:13:40

dtexec is the command to execute your package outside BIDS.

Look at this link for details and all options associated with the dtexec command.

http://msdn.microsoft.com/en-us/library/ms162810.aspx

quote:
Originally posted by prodigy2006

Could you please explain a bit in detail?

quote:
Originally posted by vijayisonly

check out the "dtexec" statement

dtexec /f "FullUNCpathofyourpackage.dtsx" /CONFIGFILE "FullUNCpathofyourconfigfile.dtsConfig"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources