saving DTS package to sql server

hi,

I have a "Transfer sql server object task" in SSIS that transfers few tables from one database to another.

The task works fine and the project is saved on my c: drive.

I was trying to save the project on the SQL server and don't know if i am doing somehting wrong

I have the following selections made:

Package Location: SQL server

Server: ServerName

Authentication Type: Windows

Package path: /TransferTables

Protection Level: Encrypt sensitive data with user key

Now when i hit ok i get the "No description found" error with the following details:

No description found (Microsoft Visual Studio)

------------------------------
Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServerAs(Package package, IDTSEvents events, String packagePath, String serverName, String serverUserName, String serverPassword)
at Microsoft.DataTransformationServices.Controls.PackageLocationControl.SavePackage(Package package)
at Microsoft.DataTransformationServices.Design.Controls.PackageSaveCopyForm.PackageSaveCopyForm_FormClosing(Object sender, FormClosingEventArgs e)

Does anyone have a solution to this

Thanks for any help.

Answer this question

saving DTS package to sql server

Dennis Xue
Use the dtutil. See reply above from Matt David
wujek_bak
doesn't SSIS get installed as part of the client tools
mjcarrabine

Usually this is because you don't have SSIS installed on the PC in question. You need SSIS installed not just the management tools.

Matt
subsider34
Hi RookieDBA,

how did you import the files finally, by using Management Studio or with the util I'm asking because I'm having the same problem and therefore it is very interesting for me to have a solution how to solve this.

Regards,

Jan
Myrkky
True the dtsutil is a work around. However, the actual probably I found to be corrected by uninstalling the sqltools hotfix(kb918222) and the reinstalling it. Perhaps the hotfix was applied in the wrong order on this machine. http://support.microsoft.com/ id=91822
John Fly
I'm having this same problem. Did you ever get a solution

===================================

Invalid access to memory location. (Exception from HRESULT: 0x800703E6) (Microsoft.SqlServer.ManagedDTS)

------------------------------
Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application.SaveToDtsServer(Package pPackage, IDTSEvents pEvents, String sPackagePath, String sServerName)
at Microsoft.SqlServer.Dts.ObjectExplorerUI.ImportPackageAsAction.ImportPackage(ImportPackageAsForm dlg)
Tacho
No, you need to install SSIS from the SSIS option in setup.
grasshole
Hi David,

Thanks for the reply.

I finally got the package imported into the sql server.

The problem now is that when i run it remotely from the server machine it works fine but when i run it from my desktop i get the following error:

"The task cannot run on this edition of integration services. it requires a higher level edition"

any ideas

Thanks
Globalist
I got past the above error and now i am getting this

Invalid access to memory location. (Exception from HRESULT: 0x800703E6) (Microsoft.SqlServer.ManagedDTS)

------------------------------
Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application.SaveToDtsServer(Package pPackage, IDTSEvents pEvents, String sPackagePath, String sServerName)
at Microsoft.SqlServer.Dts.ObjectExplorerUI.ImportPackageAsAction.ImportPackage(ImportPackageAsForm dlg)

Any help is appreciated
M.Ali.Raza
Installing the hotfix had no effect for me. Still got the error, and yes I installed the packages individually to avoid having the install fail.

The problem seems to be with the package itself, as I don't have the same issue with other packages. I tried to recreate the package from scratch, but the second one failed as well. The package is very simple. Two data sources - one ODBC and one SQL, two corresponding connection managers, an execute SQL task and a data flow task with two sub-steps (data reader source and OLE destination).

Actually found a solution to this in another thread: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=406974&SiteID=1

The short answer is run: regsvr32 msxml3.dll and regsvr32 msxml6.dll
JoJe

As a workaround you can use DTUtil to copy/move a package from the file system to SQL Server.

DTUtil /file fully_qualified_filename /copy sql;pkgname

So: DTUtil /file c:\Packages\MyPkg.dtsx /copy sql;MyPkg

HTH,

Matt
Sumit Chawla
I do have the Business Intelligence Management Studio installed.
James Minns
I think you have to install Business Inteligence Management Studio in order to access SSIS packages.
Marni
I used util. I was not able to import using management studio.
saving DTS package to sql server

Answer this question