Does not permit the use of DTS

Apologies if this appears as a double post but my original news server does
not seem to be populating all groups.
I am trying to move some data from a sol 7 server to a sol 2000 server using
the export data wizard. The problem I am having is that after I enter both
the servers and step to the next step I get the message
"The licence for the installation of SQL server on your source and
destination connections does not permit the use of DTS to transform data.
See your licence agreement for more information"
The problem would seem to be on the 2000 server as the 7 will send data to
another server.
Paul Holmes
I think the personal editions didn't allow DTS... Try using BCP directly.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Colin" <NoSpam@.gmail.com> wrote in message
news:10msb7a360c84f5@.corp.supernews.com...
> Apologies if this appears as a double post but my original news server
does
> not seem to be populating all groups.
> I am trying to move some data from a sol 7 server to a sol 2000 server
using
> the export data wizard. The problem I am having is that after I enter both
> the servers and step to the next step I get the message
> "The licence for the installation of SQL server on your source and
> destination connections does not permit the use of DTS to transform data.
> See your licence agreement for more information"
> The problem would seem to be on the 2000 server as the 7 will send data to
> another server.
>
>
> Paul Holmes
>
>
sql

Does not permit the use of DTS

Apologies if this appears as a double post but my original news server does
not seem to be populating all groups.
I am trying to move some data from a sol 7 server to a sol 2000 server using
the export data wizard. The problem I am having is that after I enter both
the servers and step to the next step I get the message
"The licence for the installation of SQL server on your source and
destination connections does not permit the use of DTS to transform data.
See your licence agreement for more information"
The problem would seem to be on the 2000 server as the 7 will send data to
another server.
Paul HolmesI think the personal editions didn't allow DTS... Try using BCP directly.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Colin" <NoSpam@.gmail.com> wrote in message
news:10msb7a360c84f5@.corp.supernews.com...
> Apologies if this appears as a double post but my original news server
does
> not seem to be populating all groups.
> I am trying to move some data from a sol 7 server to a sol 2000 server
using
> the export data wizard. The problem I am having is that after I enter both
> the servers and step to the next step I get the message
> "The licence for the installation of SQL server on your source and
> destination connections does not permit the use of DTS to transform data.
> See your licence agreement for more information"
> The problem would seem to be on the 2000 server as the 7 will send data to
> another server.
>
>
> Paul Holmes
>
>

Does not permit the use of DTS

Apologies if this appears as a double post but my original news server does
not seem to be populating all groups.
I am trying to move some data from a sol 7 server to a sol 2000 server using
the export data wizard. The problem I am having is that after I enter both
the servers and step to the next step I get the message
"The licence for the installation of SQL server on your source and
destination connections does not permit the use of DTS to transform data.
See your licence agreement for more information"
The problem would seem to be on the 2000 server as the 7 will send data to
another server.
Paul HolmesI think the personal editions didn't allow DTS... Try using BCP directly.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Colin" <NoSpam@.gmail.com> wrote in message
news:10msb7a360c84f5@.corp.supernews.com...
> Apologies if this appears as a double post but my original news server
does
> not seem to be populating all groups.
> I am trying to move some data from a sol 7 server to a sol 2000 server
using
> the export data wizard. The problem I am having is that after I enter both
> the servers and step to the next step I get the message
> "The licence for the installation of SQL server on your source and
> destination connections does not permit the use of DTS to transform data.
> See your licence agreement for more information"
> The problem would seem to be on the 2000 server as the 7 will send data to
> another server.
>
>
> Paul Holmes
>
>

Does LoadFromSqlServer2 method work?

Hi. There's little documentation on the Microsoft.SqlServer.Dts.Runtime.Application "LoadFromSqlServer2" method, and even less via any search engine.

http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.application.loadfromsqlserver2.aspx

I cannot seem to ever get the method to work; it returns "InvalidCastException: No such interface supported."

Is this code-speak for "does not work at this time" ?

Sample code (add a reference to c:\Program Files\Microsoft SQL Server\90\SDK\Assemblies\Microsoft.SQLServer.ManagedDTS.dll)

Dim app As New Microsoft.SqlServer.Dts.Runtime.Application

Dim pkg As Microsoft.SqlServer.Dts.Runtime.Package

Dim cnDatasource As New System.Data.SqlClient.SqlConnection

cnDatasource.ConnectionString = _

"Data Source=SQLOLEDB;SERVER=" & m_Datasource & ";Initial Catalog=msdb;Integrated Security=SSPI"

cnDatasource.Open()

pkg = app.LoadFromSqlServer2(m_PackageFolderPath & m_PackageName, cnDatasource, Nothing)

I am aware of the "LoadFromSqlServer" and "LoadFromDtsServer" methods; I like the idea of the Win-NT authentication (theoretically) available in the "LoadFromSqlServer2" method.

Did you read the first line of that link you sent?

"This method supports the SQL Server 2005 infrastructure and is not intended to be used directly from your code. "

|||

I guess I didn't. I've not met documentation that I wasn't supposed to use.

Thanks for the fact... it would have really been useful.

Does it require sa to create dts package?

what privilege does the user has to have to create a dts package?By default, anyone with a login can create a Package as the
public role has execute permissions on sp_add_dtspackage
stored procedure in msdb and the guest account is enabled in
msdb by default so it depends on whether you have changed
this or not.
But they don't need to be a sysadmin to create packages.
It's generally controlled through sp_add_dtspackage.
-Sue
On Thu, 24 Feb 2005 09:35:07 -0800, "sabby"
<sabby@.discussions.microsoft.com> wrote:

>what privilege does the user has to have to create a dts package?|||Thank you so much.
"sabby" wrote:

> what privilege does the user has to have to create a dts package?

Does anyone use SSIS for database schema maintenance?

We currently use SSIS to build DTS packages in which we store changes
to our database schema, as well as scripts that need to be run upon
each release. This works well for small sets of changes that never
need to be updated or for architectures with only one database.

We store each of the changes included in the package in separate
files, which are tracked using version control. It is growing time
consuming to maintain parity between those files and what is in the
SSIS.

Furthermore, we have been unable to discover an easy way to load a
file's contents into a package SQL Task without opening the file and
copy-pasting the contents into a new SQL task.

ANY information at all would be extremely appreciated!On Feb 28, 2:54 pm, "Ben" <vanev...@.gmail.comwrote:

Quote:

Originally Posted by

We currently use SSIS to build DTS packages in which we store changes
to our database schema, as well as scripts that need to be run upon
each release. This works well for small sets of changes that never
need to be updated or for architectures with only one database.
>
We store each of the changes included in the package in separate
files, which are tracked using version control. It is growing time
consuming to maintain parity between those files and what is in the
SSIS.
>
Furthermore, we have been unable to discover an easy way to load a
file's contents into a package SQL Task without opening the file and
copy-pasting the contents into a new SQL task.
>
ANY information at all would be extremely appreciated!

Hi Ben,

There is a rock solid change management process for SQL Server
2000/2005 and it is provided by the DB Ghost toolset from
Innovartis.

The essence of the process is that you script out all the database
objects and lookup (static) data into individual CREATE / INSERT
scripts and put them under source control. The whole dev team then
checks these files out, makes the required changes to the CREATE
statements and checks them back in again (this can scale to thousand
of developers). Once you're ready to release the schema to the test
environment you use the DB Ghost Change Manager tool to make the
target database match the set of source scripts. If, for example, a
developer added a column to a table CREATE script then the Change
Manager would detect this and add the column to the target database
seamlessly.

Basically, DB Ghost enables you to develop in the same way as you do
for a greenfield (release 1) database for every subsequent release of
your schema without losing any data in the target database.

Our customers rave about DB Ghost and can't believe the cost savings
it brings - have a look for yourself :)

www.dbghost.com
Kind regards,

Malcolm

Does anyone knows what is needed in each PC for that?

Hi everyone,

I’m pursuing a fast deployment for SSIS. I mean, we’ve got ten ASP/VB6 developers which often doing some DTS stuff by mean, of course, Enterprise Manager.

Now, they’d have to handle the same but with SSIS. I don’t have very clear whether only is necessary install them SSIS component or it’d requires something else. Framework 2.0 too?

If they are building packages then they will need BIDS installed. If they want to run them on their client machines from outside BIDS then they will need SSIS installed (which is a different install option on the CD).

Framework 2.0 is required but that will be installed off the SQL Server CD automatically if it is needed (I think).

Does that answer the question?

-Jamie

|||

Hi Enric,

Please browse through "Installing SQL Server Integration Services by Using Setup " @. http://msdn2.microsoft.com/en-us/library/ms143510.aspx were they have detailed on the different components of SQL Server Install and their applications. and http://msdn2.microsoft.com/en-us/library/ms143731.aspx (has got information on "Installing Integration Services Side-By-Side with SQL Server 20000 Data Transformation Services)

.NET Framework 2.0 is a must requirement.

Thanks,
Loonysan

|||

Jamie,

Yeah, that asnwer partially my question because I don't know if is needed a license per place or not.

Loonysan,

Thanks for that link.

|||

Do you have an MSDN subscription? I think that covers you to have Developer Edition on each machine.

-Jamie

|||

yes, we have. Thanks.

something else. When people talks about 'Client Tools' for Sql Server 2005 are they talking about BIDS environment and SSIS component generally speaking?

|||

Well i guess it depends who you're asking. When I talk about client tools I mean SSMS and BIDS (which includes the SSIS Designer). I do not mean SSIS. There is a distinction here.

-Jamie

|||OK

Does a Job execute MUCH faster??

Hi,

Previosuly I was executing 2 DTS packages one afte the other manually and together they took a CONSIDERABLE time. The 1st one was pulling data from the OLPT, doing transformations and populating the tables in my Datamart and the 2nd one was doing a FULL process of all the dimensions and cubes.

However I tried scheduling the DTSs as jobs and havethen merged the 2 resulting jobs as a SINGLe job having 2 sequential steps. To my surprise the resulting job takes less than half the time (actually even lesser) as compared with my original approach i.e. running the DTSs.

Am i getting over excited here or is this natural? I assume that if this is correct then jobs much be some sort of "compiled" version as compared to DTS and maybe that's why I have this terrific improvement in terms of execution times.

I'll appreciate comments. ThanksIt's actually a little simpler than that. The same exact set of processes are involved in running your package(-s) interactively or as a scheduled job. The difference lies in the fact that, while being scheduled, the package runs on the server, and any and all output streams are within the "server reach" (in other words nothing leaves the box), running the same package interactively causes every output flag (such as the number of rows processed so far) to be sent to the client.|||Thanks for the reply :)

Document Job Steps

How can I script out the job steps along with the DTS, Sp or T-SQL code within the step. This info must be stored somewhere. How can I access it?

Hi,

You can script out jobs, including their job steps, by using SQL Server Management Studio. In SQL Server Books Online, see the topic "How to: Script Jobs Using Transact-SQL (SQL Server Management Studio)"

The URL within the Books Online browser is

ms-help://sql90/udb9/html/fd9e6497-87ca-4da8-b194-55c9d5b03cec.htm

Copy and paste this URL into the Books Online browser to locate this topic. As an alternative, you can also search on the topic name.

Let me know if you have any further questions.

Best regards,

Laurel Hale

Document Job Steps

How can I script out the job steps along with the DTS, Sp or T-SQL code within the step. This info must be stored somewhere. How can I access it?

Hi,

You can script out jobs, including their job steps, by using SQL Server Management Studio. In SQL Server Books Online, see the topic "How to: Script Jobs Using Transact-SQL (SQL Server Management Studio)"

The URL within the Books Online browser is

ms-help://sql90/udb9/html/fd9e6497-87ca-4da8-b194-55c9d5b03cec.htm

Copy and paste this URL into the Books Online browser to locate this topic. As an alternative, you can also search on the topic name.

Let me know if you have any further questions.

Best regards,

Laurel Hale