File..Save Copy of <package file> As... not available

According to the help for SSIS, one method of deploying an SSIS package to a SQL Server, http://msdn2.microsoft.com/en-us/library/ms137565.aspx, is to use the File...Save a Copy of <package file> as... menu option.

I don't have that menu option at all. And yes, the package is in focus. My save menu options are simply; Save Selected, Save <package file> As... and Save All.

I am using Version 9.00.1399.00 of the SSIS Designer.

At one time I did have the Management Studio's CTP installed. However it was uninstalled before installing the tools from the Standard Edition. (it would seem like not completely however)

Your help would be greatly appreciated. Thanx much.

p.s. Almost forgot to mention... I am already aware of using the DTSInstall utility as a workaround. It should be noted, however, that despite enabling the "CreateDeploymentUtility" property, the DTSInstall.exe is not copied to the bin\Deployment directory.

Answer this question

File..Save Copy of <package file> As... not available

Casey Chamberlain
Hi Michael,

I have a problem related to your response above that you may be able to help me with. When I copy the contents of the deployment folder to the destination computer, double-clicking on the manifest file does not automatically load the Package Installation Wizard!

My intention is to move data from a Foxpro to a SQL Server Express backend.

I have created the required package complete with the deployment files. I have also written a program in C# that is supposed to load this package and execute it in the client's computer. I created a setup program to install the C# program on the client's machine and put SQL Server 2005 Express as one of the prerequisites. This runs ok and actually does install the SQL Server Express (amongst other prerequisites) on the client machine. Now when it comes to deploying the package, I run into the problem that it doesn't automatically load and run the Package Installation Wizard!

I suspect that I need to install other things on the client machine. What are these Or what have I (not) done to encounter this problem This is urgent please.

Edwin
fehays

Try Tools-->Customize...Cpmmands Tab

I had a problem yesterday where there was no option available to show the Immediate window. So I just found it in Tools-->Customize...Commands Tab and dragged it to the place where I wanted it.

-Jamie
chialee

I can't suggest anything regarding the missing menu command - never seen this problem.

However, the second part (regarding DtsInstall) is by design (and not a problem at all) - the DtsInstall.exe is no longer copied to bin\Deployment folder as it used to be in beta. Instead of EXE, you get deployment manifest file, that you double click on remote machine to invoke DtsInstall.exe (which is part of SSIS installation, and does not need to be transferred).

We made this change, as it is more reliable and secure: no EXE needs to copied between the computers, deployment manifest is smaller, there is only one version of DtsInstall binary so it can be easily updated with hotfixes or service packs.
Vinod72

You are right, you need an additional install - SQL Server itself.

SQL Server Integration Services is not available in SQL Server 2005 Express Edition, and you only get the wizard with SQL Server 2005 Workgroup. Start with SQL Server 2005 Standard if you want to use SSIS.
foolish frost
SQL Integration Services is not part of SQL Express product. To run SSIS packages, you need Standard or higher editions of SQL Server.
Chakry
Thanx for your reply Michael. The DTSInstall not being copied wasn't a problem per see, hence the postscript, but merely an observed behavior different than the documentation. I did notice the file-type association, and I do appreciate the smaller deployment footprint. Thanx for the info.

However, my posit is really about the missing menu command and the purpose of my writing here. It does seem to be a rare occurence, as I have no problems finding the command on my colleagues machines. However, I am also the only one in the dept. to have installed the Management Studio CTP prior to the standard edition tools.

I wanted to post that question before I went thru the time and hassle of a reinstall, which I imagine should solve the problem. I'll repost with those results.

But, if anybody knew of what controlled the behavior of that menu command's visibility, it maybe helpful.
lexp

An excellent workaround Jamie! That worked perfectly. Thanx much!
mfeigin
This is VERY disappointing to say the least! We provide software services to the Micro Finance industry. Most of our clients are small organizations that cannot afford to buy SQL Server - the reason why we are shipping the Express Edition. Microsoft should consider providing a distributable SSIS runtime to allow migration of data to the Express Edition from other data sources to cater for such clients.
File..Save Copy of <package file> As... not available

Answer this question