sql server dts: Save as Meta Data Services impossible -- sql server dts

Save as Meta Data Services impossible

Eric
9/27/2005 2:52:16 PM

sql server dts: I try to save a simple data transform task from a table to a file to
Meta Data services but this option is not available . I can only save
to :SQL Server, Visual Basic File or Stuctured Storage File.

Why is this option not available?

Thank you in advance for any help on the subject

Eric

Re: Save as Meta Data Services impossible

Sue Hoegemeier
9/27/2005 5:55:23 PM

Saving to the repository became disabled by default on one
of the service packs.
Right click on the Data Transformation Services node in
Enterprise Manager. Select Properties. Check the option to
Enable Save To Meta Data Services

-Sue

On 27 Sep 2005 14:52:16 -0700, "Eric" <eric57e@hotmail.com>
[quoted text, click to view]

Re: Save as Meta Data Services impossible

Eric
9/27/2005 10:02:23 PM

Hi Sue,

Thanks a lot for your help. The Service pack concerned was SP3.
Simply to share this information with the community.

thanks a lot for your help

Eric

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.