DTS Creation issue

Hi all,

Here is the problem : I can not create a DTS package in SQLServer.
=> Error description : access denied
Environment :
- Windows NT4 sp6 Server, french, logon on as "Administrator".
- SQLServer 7.0 sp4, french, logon as "sa" on the NT Server with Enterprise Manager.
- SQLServer Agent runs under an Administrator account

Why can't i create single DTS package ? Strange, isn't it ?
Many thanks for your ideas

BertrandLook for the latest Service Pack (I don't know the exact one but I think it's 3)

Good luck.|||Actually it is the french sp4 for SQLServer 7.0 french.

I can design a DTS package but i can not save it : "Access denied".
Thanks for your help

Originally posted by Crespo-n00b
Look for the latest Service Pack (I don't know the exact one but I think it's 3)

Good luck.|||On SQL ver7 SP4 is the last and latest despite of language.

Can you try creating DTS package using DTS wizard.

DSV Refresh

Hi,

I have an odd problem with the creation of objects in the data source view using AMO.

I added some tables and relations with AMO and everything seems to work well.

Then, using Analysis Services I selected the data source view and refreshed it.

The form that notifies the changes in the data source view showed a lot of changes that I didn’t understand, costraints created and removed, fields changed and other operations that I didn’t made...

I try to do the refresh with AMO using all the update and refresh options I found but with no results.

Every insight on the question will be of great help.

Thanks

This is an extract of the data source view refresh report:

Object

Change

_DIM_DimColl1

Changed

Constraint1

Deleted

_DIM_Dimensione

attrfinto

Changed

_DIM_eta2

aaa

Changed

_DIM_Mesi

Changed

_DIM_MesiColl

Changed

Constraint1

Deleted

_FK_eta2_aaa

Changed

Constraint1

Deleted

_FK_MesiColl_Livello03

Changed

Constraint1

I don't have a clue what's causing that, but let me suggest that you keep a copy of the .dsv (XML) file from before you refresh the DSV. Then you refresh it, save it, and do a diff versus the previous file. Then you can see exactly what properties changed. There's a pretty close mapping between AMO properties and the XML elements in the file.|||The refresh in AMO is different from the refresh in DSV diagram. DSV Diagram refresh will connect to the relational database and refresh the metadata. AMO refresh will not connect to relational database and just refresh the objects within AMO.|||

Do you know how can I refresh the DSV through AMO?

DSV Refresh

Hi,

I have an odd problem with the creation of objects in the data source view using AMO.

I added some tables and relations with AMO and everything seems to work well.

Then, using Analysis Services I selected the data source view and refreshed it.

The form that notifies the changes in the data source view showed a lot of changes that I didn’t understand, costraints created and removed, fields changed and other operations that I didn’t made...

I try to do the refresh with AMO using all the update and refresh options I found but with no results.

Every insight on the question will be of great help.

Thanks

This is an extract of the data source view refresh report:

Object

Change

_DIM_DimColl1

Changed

Constraint1

Deleted

_DIM_Dimensione

attrfinto

Changed

_DIM_eta2

aaa

Changed

_DIM_Mesi

Changed

_DIM_MesiColl

Changed

Constraint1

Deleted

_FK_eta2_aaa

Changed

Constraint1

Deleted

_FK_MesiColl_Livello03

Changed

Constraint1

I don't have a clue what's causing that, but let me suggest that you keep a copy of the .dsv (XML) file from before you refresh the DSV. Then you refresh it, save it, and do a diff versus the previous file. Then you can see exactly what properties changed. There's a pretty close mapping between AMO properties and the XML elements in the file.|||The refresh in AMO is different from the refresh in DSV diagram. DSV Diagram refresh will connect to the relational database and refresh the metadata. AMO refresh will not connect to relational database and just refresh the objects within AMO.|||

Do you know how can I refresh the DSV through AMO?