Groups | Blog | Home
all groups > sql server dts > november 2005 >

sql server dts : SSIS Package Save Fails. Need Help!



rjax
11/4/2005 6:16:02 PM
I used the Import Wizard to Import part of a table from AdventureWorksDW
sample database into my Tst Database. I define a sql query to give me the
first 200 records. I parse and preview the data ok (no error there).
I ask it to save the pakage and I get a prompt with encrypting sensitive
data as default. I pick the default.
When I finish the wizard, everything works ok until it tries to save the
package.
It gives me this error:

Save to SQL Server failed. No description found

Could you please assist me with this problem?

Thank you

Rich -
v-ricaug@microsoft.com

bdavidh
11/7/2005 2:11:04 PM
I'm having the same issue, I first came across it trying to save maintenance
plans in SQL Server 2005. I encountered it again while trying to save a SSIS
package to the server.

We have the 2005 Enterprise Ed release. The original SSIS package was
created under the Sept. CTP with no problems.

Which install of SQL and/or Studio do you have?

[quoted text, click to view]
rjax
11/7/2005 3:10:04 PM
I have release:
Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.086.1830.00
(srv03_sp1_rtm.050324-1447)
Microsoft MSXML 2.6 3.0 5.0 6.0
Microsoft Internet Explorer 6.0.3790.1830
Microsoft .NET Framework 2.0.50727.42
Operating System 5.2.3790

[quoted text, click to view]
bdavidh
11/8/2005 12:47:04 PM
I didn't have the problem on the Server itself or other machines, just mine.

It's not really helpful but, I had to flatten my machine and have it
re-imaged so I can get back to work.

My versions before and after are the same, but now I can save a package.

Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00
(xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

[quoted text, click to view]
AddThis Social Bookmark Button