DTS

How do we configure DTS package to transfer more than 1 table data transfer from a Source to Destination Server?
I have about 100 odd tables in Source & need to do data transfer for all within 1 go. Is this possible?If you are on SQL Server 2000 and the source and destination
are both SQL Server(7 or above), you can use the Copy SQL
Server Objects task.
-Sue
On Wed, 5 Nov 2003 13:11:07 -0800, "Prasanna"
<anonymous@.discussions.microsoft.com> wrote:
>How do we configure DTS package to transfer more than 1 table data transfer from a Source to Destination Server?
>I have about 100 odd tables in Source & need to do data transfer for all within 1 go. Is this possible?|||The simplest way is USe the DTS wizard.
or
In , SQLEM,go to "Tools" and then CLick "DTS" and then Use
the Export/Import. (This will also get you the DTS Wizard)
Very simple and user friendly wizard.You can easily do it.
SQLVarad(MCDBA-1999,MCSE-1999)
>--Original Message--
>If you are on SQL Server 2000 and the source and
destination
>are both SQL Server(7 or above), you can use the Copy SQL
>Server Objects task.
>-Sue
>On Wed, 5 Nov 2003 13:11:07 -0800, "Prasanna"
><anonymous@.discussions.microsoft.com> wrote:
>>How do we configure DTS package to transfer more than 1
table data transfer from a Source to Destination Server?
>>I have about 100 odd tables in Source & need to do data
transfer for all within 1 go. Is this possible?
>.
>

DTA (Database Tuning Advisor) Malfunction, no error message

Hello, I am having an extremely odd problem with the Database Engine Tuning Advisor, on SQL Server 2005 Enterprise x64. It was working fine, and I was tuning the queries for a bunch of database views we have created. About 2/3 of the way through the list DTA began getting stuck on "Submitting Configuration Information" every time it was run.

I get no error messages, it just sits and spins on Submitting Configuration Information for days and days at a time. When other users view my session, its status says ready as though it had never started, but I am unable to start nor stop it until I close out of it and simply delete it out of the Session Monitor on the left. Other users are able to run sessions without issue, and nothing has changed on the server. I get the same behavior whether I am tuning a query or a workload file. **Edit** A workload file eventually died on the first step with the nebulous "Tuning process exited unexpectedly." There are no entries in dbo.DTA_tuninglog. In dbo.DTA_progress, only TuningStage 0 is present for that SessionID.

I have tried using a different SQL user, rebooting, uninstalling all SQL Server components from my PC then re-installing them, and deleting out all previous DTA session data with no luck. We have also recently installed SP2 for SQL Server 2005 on the server, and I updated my local installation with Microsoft Update. The problem persists. I would appreciate any input you could provide!

Thanks,
Konrad Willmert
Indiana Wesleyan University

I am having the Same Problem, I have no Idea what to do to fix it.

I get this error even after a complete Uninstall (Per the Book) and ReInstallation (Per the Book).

I have tried 3 times.

|||I am having a similar problem. I can get it to start consuming the workload, but it errors out every time. My SQL version is 9.0.3042 so I don't think KB 917131 applies. Was there ever a resolution?|||Shelly,

I have neither found nor received any resolution to this problem--other than asking my co-workers to tune things for me.
|||I gave up as well. I am just using other systems to do the testing.

DTA (Database Tuning Advisor) Malfunction, no error message

Hello, I am having an extremely odd problem with the Database Engine Tuning Advisor, on SQL Server 2005 Enterprise x64. It was working fine, and I was tuning the queries for a bunch of database views we have created. About 2/3 of the way through the list DTA began getting stuck on "Submitting Configuration Information" every time it was run.

I get no error messages, it just sits and spins on Submitting Configuration Information for days and days at a time. When other users view my session, its status says ready as though it had never started, but I am unable to start nor stop it until I close out of it and simply delete it out of the Session Monitor on the left. Other users are able to run sessions without issue, and nothing has changed on the server. I get the same behavior whether I am tuning a query or a workload file. **Edit** A workload file eventually died on the first step with the nebulous "Tuning process exited unexpectedly." There are no entries in dbo.DTA_tuninglog. In dbo.DTA_progress, only TuningStage 0 is present for that SessionID.

I have tried using a different SQL user, rebooting, uninstalling all SQL Server components from my PC then re-installing them, and deleting out all previous DTA session data with no luck. We have also recently installed SP2 for SQL Server 2005 on the server, and I updated my local installation with Microsoft Update. The problem persists. I would appreciate any input you could provide!

Thanks,
Konrad Willmert
Indiana Wesleyan University

I am having the Same Problem, I have no Idea what to do to fix it.

I get this error even after a complete Uninstall (Per the Book) and ReInstallation (Per the Book).

I have tried 3 times.

|||I am having a similar problem. I can get it to start consuming the workload, but it errors out every time. My SQL version is 9.0.3042 so I don't think KB 917131 applies. Was there ever a resolution?|||Shelly,

I have neither found nor received any resolution to this problem--other than asking my co-workers to tune things for me.
|||I gave up as well. I am just using other systems to do the testing.

DTA (Database Tuning Advisor) Malfunction, no error message

Hello, I am having an extremely odd problem with the Database Engine Tuning Advisor, on SQL Server 2005 Enterprise x64. It was working fine, and I was tuning the queries for a bunch of database views we have created. About 2/3 of the way through the list DTA began getting stuck on "Submitting Configuration Information" every time it was run.

I get no error messages, it just sits and spins on Submitting Configuration Information for days and days at a time. When other users view my session, its status says ready as though it had never started, but I am unable to start nor stop it until I close out of it and simply delete it out of the Session Monitor on the left. Other users are able to run sessions without issue, and nothing has changed on the server. I get the same behavior whether I am tuning a query or a workload file. **Edit** A workload file eventually died on the first step with the nebulous "Tuning process exited unexpectedly." There are no entries in dbo.DTA_tuninglog. In dbo.DTA_progress, only TuningStage 0 is present for that SessionID.

I have tried using a different SQL user, rebooting, uninstalling all SQL Server components from my PC then re-installing them, and deleting out all previous DTA session data with no luck. We have also recently installed SP2 for SQL Server 2005 on the server, and I updated my local installation with Microsoft Update. The problem persists. I would appreciate any input you could provide!

Thanks,
Konrad Willmert
Indiana Wesleyan University

I am having the Same Problem, I have no Idea what to do to fix it.

I get this error even after a complete Uninstall (Per the Book) and ReInstallation (Per the Book).

I have tried 3 times.

|||I am having a similar problem. I can get it to start consuming the workload, but it errors out every time. My SQL version is 9.0.3042 so I don't think KB 917131 applies. Was there ever a resolution?|||Shelly,

I have neither found nor received any resolution to this problem--other than asking my co-workers to tune things for me.
|||I gave up as well. I am just using other systems to do the testing.

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?