April 23, 2010 at 5:22 am
Hi i create an SSIS package and create the deployment folder. When i go to double click on the ssispackage.SSISDeploymentManifest file it won't launch the wizard. all i get is to select a program. to open the file with.
Is there some setting i need to get this to work ?
April 23, 2010 at 6:00 am
Yes, you need BIDS Helper 😀
Much much easier to deploy packages and it's free too!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 23, 2010 at 9:42 am
I'm not a big fan of either..
So I build scripts to do it for me..
I use a script similar to this:
deploy-ssis.cmd
@ECHO OFF
SET /P ServerName=What server without instance name:
SET /P ServerNameWithInstance=What server with instance name (if applicable)
sqlcmd /S %ServerNameWithInstance% /E /i".\BuildFolders.sql"
dtutil /Q /DestS %ServerName% /Fi Package1.dtsx /C SQL;/MyDir/MyDir1/Package1
dtutil /Q /DestS %ServerName% /Fi Package2.dtsx /C SQL;/MyDir/MyDir2/Package2
dtutil /Q /DestS %ServerName% /Fi Package3.dtsx /C SQL;/MyDir/MyDir2/Package3
dtutil /Q /DestS %ServerName% /Fi Package4.dtsx /C SQL;/MyDir/MyDir2/Package4
dtutil /Q /DestS %ServerName% /Fi Package5.dtsx /C SQL;/MyDir/MyDir2/Package5
This is the contents of BuildFolders.sql:
USE msdb
GO
CREATE TABLE #FolderList ( folderid uniqueidentifier, parentfolderid uniqueidentifier, foldername varchar(128) )
GO
INSERT #FolderList
( folderid, parentfolderid, foldername )
EXEC msdb.dbo.sp_ssis_listfolders '00000000-0000-0000-0000-000000000000'
GO
IF NOT EXISTS ( SELECT 'X' FROM #FolderList WHERE foldername = 'MyDir' )
BEGIN
EXEC msdb.dbo.sp_ssis_addfolder '00000000-0000-0000-0000-000000000000',N'MyDir'
END
GO
TRUNCATE TABLE #FolderList
GO
INSERT #FolderList
( folderid, parentfolderid, foldername )
EXEC msdb.dbo.sp_ssis_listfolders '00000000-0000-0000-0000-000000000000'
GO
DECLARE @folderid uniqueidentifier
SELECT @folderid = folderid
FROM #FolderList
WHERE foldername = 'MyDir'
IF NOT EXISTS ( SELECT 'X' FROM #FolderList WHERE foldername = 'MyDir1' )
BEGIN
EXEC msdb.dbo.sp_ssis_addfolder @folderid,N'Master'
END
IF NOT EXISTS ( SELECT 'X' FROM #FolderList WHERE foldername = 'MyDir2' )
BEGIN
EXEC msdb.dbo.sp_ssis_addfolder @folderid,N'Collection'
END
GO
DROP TABLE #FolderList
GO
It creates the "directories" and installs the packages..
CEWII
April 24, 2010 at 4:41 am
Ah, for deployment from my computer (locally developing packages) to the test server, I use BIDS Helper. Very easy with the GUI.
From deployment to production however, I use scripts similar to those of Elliot W. When it's important, I like to be in control of what happens 🙂
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