February 21, 2012 at 2:35 pm
Hi Iam trying to run my SSIS package in 32 bit.
Please help me with the script to execute the packages.
Thanks for your help
Sajin
February 22, 2012 at 10:23 am
Why are you trying to use PowerShell to execute SSIS packages? Why not use SQL Server Agent?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 22, 2012 at 1:37 pm
SQL Agent is not enabled
February 22, 2012 at 10:04 pm
If all you need to do is execute a package then a single-line PowerShell script that calls dtexec.exe is all you need. e.g.
dtexec.exe /f "C:\UpsertData.dtsx"
See section "dtexec (SSIS Tool): Examples" for more examples: http://msdn.microsoft.com/en-us/library/ms162810.aspx
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy