LearnItFirst User Forum

Welcome Guest

Search | New Posts | Members | Log In | Register

SQL Server Forum - LearnItFirst.com » 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: 4
Points: 12
Where do you live?: 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: 476
Points: 1,053
Where do you live?: 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.