November 14, 2011 at 5:45 am
Hi Friends,
Can any one tell me what are all the different ways that we can execute a package?
How can we permanently change the 64-bit option on our local system..? Because when ever i create a package,every time i make the Run64bit Version option false in visual studio..?
Is it possible to execute a package on another computer which is not having visual studio..?
And do we need config file to execute on another computer or .dtsx file is enough?
Sorry friends..for asking many questions...i don't think these are all different topics to post separately, that's why i ask here...
sorry if am wrong...
Thanks,
Charmer
November 16, 2011 at 3:35 am
The Run64BitRunTime option only applies when running the package in BIDS. This is usually used when you are developping packages that read Excel files, as the JET provider only supports 32-bit. So this is a design-time only option.
Running packages on the server:
* starting manually by logging in into the SSIS server, right click on a package and choose Execute. http://msdn.microsoft.com/en-us/library/ms141707(v=sql.90).aspx
* starting manually by launching dtexecui.exe http://www.mssqltips.com/sqlservertutorial/219/windows-application-to-execute-ssis-packages/
* launching dtexec.exe through a command window or a .bat file or the Windows scheduler http://msdn.microsoft.com/en-us/library/ms162810.aspx
* scheduling the packages using a SQL Server Agent job (the easiest method in my opinion) http://decipherinfosys.wordpress.com/2008/09/17/scheduling-ssis-packages-with-sql-server-agent/
Actually, every method uses dtexec.exe behind the scenes.
A nice overview:
http://www.mssqltips.com/sqlservertip/1775/different-ways-to-execute-a-sql-server-ssis-package/
(I found all these links using Google...)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 16, 2011 at 4:47 am
Hi,
it was very useful...it really had more information than i expected...Thank you so much...
i am always running the package on the client side....
so my confusion is do the client need visual studio to run the package..?
i came to know that they don't need it after i read the article...
but do we need config file to put over there?
Thanks,
Charmer
November 16, 2011 at 5:28 am
End users shouldn't run SSIS packages themselves.
Visual Studio (or BIDS) is normally used only for development.
After development, the packages are moved to the server where they are automatically executed using the methods described above. You can use config files to make your packages easier to migrate between different environments (DEV - UAT - PROD - ...).
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply