March 28, 2011 at 2:08 am
Hi,
I need to write a Batch file which can Deploy multiple SSIS packages kept at a location. The Batch file should iterate to check all the SSIS packages and Deploy them one by one.
Server to deploy should be passed as parameter.
March 28, 2011 at 3:46 am
Maybe this blog post can get you in the right direction:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 28, 2011 at 12:31 pm
Why not just include all your SSIS packages in one project in BIDS, and deploy it using the Manifest?
July 30, 2013 at 8:17 pm
I think BIDS feature is available in SQL Server 2012 not in 2008. For SQL Server 2008 you can use dtutil or Package Installer.
July 31, 2013 at 2:40 am
mayank_sanghvi (7/30/2013)
I think BIDS feature is available in SQL Server 2012 not in 2008. For SQL Server 2008 you can use dtutil or Package Installer.
You do realize this thread is 2 years old? By the way, BIDS is available in SQL Server 2012, it's just renamed to SSDT.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply