Restoring structured storage file to dts package - Integration Services (SSIS) and DTS

Member of the LearnItFirst.com Video Training Network	\| LearnSqlServer.com \| SQL SSIS Training \| SQL Programming Tutorials \|

Welcome Guest

Search | New Posts | Members | Log In | Register

LearnSqlServer.com's SQL Server Forums » SQL Server Database Administration » Integration Services (SSIS) and DTS » Restoring structured storage file to dts package

Restoring structured storage file to dts package

Options

Previous Topic · Next Topic

moumona

Posted: Friday, May 30, 2008 9:38:23 PM

Rank: Newbie

Joined: 5/16/2007
Posts: 3
Points: 9
Location: virginia,usa

Hi All,

I have taken the backup of dts packages as structured storage files.
How do i restore them back to dts packages?

Thanks

Scott Whigham

Posted: Saturday, May 31, 2008 8:58:43 AM

Rank: Super Mod

Joined: 3/20/2006
Posts: 329
Points: 700
Location: Dallas, TX

Hi there -

They are DTS packages if I understand you. You just saved them as a .dts file, right? Then you need to go to the enterprise Manager, right click on Data transformation Services and say Open Package.

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.