dts from command line

if a user runs a dts package from a command line say something like this
C:\>dtsrun /s ServerName /u username /p P1l0t /n DTS_Package
using that /p password switch is the passwork example above P1l0t saved off
somewhere in a log file?
same question for if the command fails.
thanksNo...it won't report or log the password that was used.
-Sue
On Tue, 11 Oct 2005 15:05:05 -0700, "jason"
<jason@.discussions.microsoft.com> wrote:

>if a user runs a dts package from a command line say something like this
>C:\>dtsrun /s ServerName /u username /p P1l0t /n DTS_Package
>using that /p password switch is the passwork example above P1l0t saved off
>somewhere in a log file?
>same question for if the command fails.
>thanks|||thanks sue
"Sue Hoegemeier" wrote:

> No...it won't report or log the password that was used.
> -Sue
> On Tue, 11 Oct 2005 15:05:05 -0700, "jason"
> <jason@.discussions.microsoft.com> wrote:
>
>

DTS error when Copying Objects

I am getting the following error when executing a Copy SQL Server Objects Task. If it helps these objects are User Defined functions and also this had worked in the past it is only after changing the destination server to one that is offsite, has a different OS then the source and also runs as a DC. We are running SQL 2000 Server Standard with Spk 3a on both boxes.

Step 'DTSStep_DTSTransferObjectsTask_6' failed

Step Error Source: Microsoft SQL-DMO (ODBC SQLState: 42S02)
Step Error Description:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.GetRightsAbbreviations'.
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.GetRights'.
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.GetTerritoryAbbreviations'.
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.GetTerritories'.
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.GetShow'.
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.GetTvEpisodes'.
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.GetTvSegments'.
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.GetTvSegmentsString'.
Step Error code: 800400D0
Step Error Help File:SQLDMO80.hlp
Step Error Help Context ID:1131Check object owner. This is the most common reason which is clearly seen from the error message you provided.sql

DTS error

i've a problems on this ...

Please help ..

Executed as user: MBADOMAIN\Administrator. ...
DTSRun OnStart: DTSStep_DTSActiveScriptTask_1
DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1
DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1
DTSRun OnStart: DTSStep_DTSActiveScriptTask_2
DTSRun OnError: DTSStep_DTSActiveScriptTask_2,
Error = -2147220482 (800403FE)
Error string: ActiveX Scripting encountered a Run Time Error during the execution of the script.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 4500
DTSRun: Package execution .
The step failed.Hi!

Did you try to execute "DTSStep_DTSActiveScriptTask_2" alone in the Enterprise Manager? It should be an error in this script.

Carsten|||Originally posted by CarstenK
Hi!

Did you try to execute "DTSStep_DTSActiveScriptTask_2" alone in the Enterprise Manager? It should be an error in this script.

Carsten

hi,

yes, i did it ! my situation is the DTS package is runs error-free from the Enterprise Manager, but the DTS package fails when it is scheduled to run as a job.

wersa

DTS Error

I am trying to run a scheduled package in the DTS and keep getting a the error message in the job history:
'Executed as user: UTSQL01\SYSTEM. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: Copy Data from ProForm1099 to "SCOTT"."PROFORM1099" Step DTSRun OnError: Copy Data from ProForm1099 to "SCOTT"."PROFORM1099" Step, Error = -2147467259 (80004005) Error string: [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 0 (0) Error string: [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 DTSRun OnFinish: Copy Data from ProForm1099 to "SCOTT"."PROFORM1099" Step DTSRun: Package execution complete. Process Exit Code 1. The step failed.'
Is there someone that knows what this means and how I can correct it?
Thanks.I'm assuming that when you run it manually it works...

It sounds like a security issue...the sql agent account needs permission

Yes?|||It is a security issue. I can't seem to get around it though. I log on as administrator and I get a whole new set of errors. I am now trying to export to Excel and get the error that the path to the Excel sheet is wrong. How do I give permissions?
Thanks.|||This should answer your question:

link (http://support.microsoft.com/?id=269074)

Let me know if you still have the problem.|||I can't change the owner info in the Owner drop-down combo box which is what it tells me to do.
Thanks for your help. The link you sent was the right one.|||Are you stuck ... ?|||Very. How can I change the owner?|||What happens when you change the owner and select apply ? Do you have administrator rights ?|||The owner combobox is grayed and I can't even access it.|||Do you have sys admin access ? Can you login as the owner ?|||You can also try the stored procedure to change the ownership:
sp_update_job|||I can't run it for some reason. I don't know much about this stuff.|||Try msdb.dbo.sp_update_job ... What is your access level in sql server ? Have you tried logging in as sa ?|||I can run the procedure in Query Analyzer but I get the message:
Server: Msg 14294, Level 16, State 1, Procedure sp_verify_job_identifiers, Line 24
Supply either @.job_id or @.job_name to identify the job.
Stored Procedure: msdb.dbo.sp_update_job
Return Code = 1

Where do I put the job_id or job_name?

Thanks again for your help.|||The job now says it succeeded but when I open the destination file, there is no data there. I'm lost.
And I ran the procedure msdb.dbo.sp_update_job and got a:
Stored Procedure: msdb.dbo.sp_update_job
Return Code = 0
message.|||Did you get the sp to execute ? What is the destination file ? What happens when you execute the dts manually - does the destination file contain something ?|||Manually it works fine. And I did run the SP.|||Can you break down what the dts is doing (step-by-step) and what is supposed to be in the file ?|||When I export to Excel on my desktop I get:

Executed as user: UTSQL01\SYSTEM. ...art: Drop table PROFORM1099 Step DTSRun OnFinish: Drop table PROFORM1099 Step DTSRun OnStart: Create Table PROFORM1099 Step DTSRun OnFinish: Create Table PROFORM1099 Step DTSRun OnStart: Copy Data from ProForm1099 to PROFORM1099 Step DTSRun OnProgress: Copy Data from ProForm1099 to PROFORM1099 Step; 1000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 1000 DTSRun OnProgress: Copy Data from ProForm1099 to PROFORM1099 Step; 2000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 2000 DTSRun OnProgress: Copy Data from ProForm1099 to PROFORM1099 Step; 3000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 3000 DTSRun OnProgress: Copy Data from ProForm1099 to PROFORM1099 Step; 4000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 4000 DTSRun OnProgress: Copy Data from ProForm1099 to PROFORM1099 Step... Process Exit Code 0. The step succeeded.

Everything worked, but there is no data in the destination file.

If I try to export to an Excel sheet on my C:\ drive I get an error that the path is incorrect and to check it again.

There is nothing major in the source table. Just 4 columns with 15000 rows of num,and char strings.|||Was that last one scheduled?

If it was, it's on the server...

What happens when you use the export wizard?

What's the data destination in the transformation?

Betcha it's on the server...can you map to it?|||I don't understand what you mean if the last one was scheduled. I always use the export wizard. The destination is an Excel sheet on my desktop. I can map to it.|||When you execute dts using enterprise manager from your desktop, the file will appear on your local drive (if that is where the destination is located - for example c:\). When you execute the dts as a job, it will execute on the server - so the file should be on the server (not your desktop).

Let me know if this is what happened.|||It looks like the file was saved on the server. How can I get it to save on my local machine?
Thanks again.|||You can do the following:

\\computername\c$\file.txt - assuming permissions are ok.

Rather than the server pushing to your machine - I would recommend pulling the file from the server.

DTS designer

64b SQL2005 EE and all clent tools installed on the same server. Logged as
local admin user Im trying to create a new connection in DTS Designer but
after succesful test of the connection it errors out with
The new connection manager couldnt be created. Additional info : Exeption
from HRESULT 0xC0010014
Do you know if the client tools are installed by default in x86 Program
files folder and is it possible uninstalling and reinstalling in Program
files will fix the issue?
Any idea whats the problem and how to fix it ?
In our case the problem was SP1 unfinished /unsuccesful instalation. After
sql2005 setup REBOOT and when is up stop all sql services from Control panel
and then install SP1. Ensure you dont get open files errors if so close the
guilty apps and then continue and if so reapply the SP1 once again.
"Ellie" wrote:

> 64b SQL2005 EE and all clent tools installed on the same server. Logged as
> local admin user Im trying to create a new connection in DTS Designer but
> after succesful test of the connection it errors out with
> The new connection manager couldnt be created. Additional info : Exeption
> from HRESULT 0xC0010014
> Do you know if the client tools are installed by default in x86 Program
> files folder and is it possible uninstalling and reinstalling in Program
> files will fix the issue?
> Any idea whats the problem and how to fix it ?
>

DTS Copy SQL Server

hello all
i have problem with dts copy sql server
error : [Microsoft][ODBC SQL Server Driver][SQL Server]Windows NT user or group 'TCW\Administrator' not found. Check the name again.
thx b 4I think you need to be a wee bit more specific...

But here goes...

sounds like you're trying to copy data to another server from your server, and the other server is set up as windows only security...AND your system account is not on the domain...

sound close?

DTS And VBScript

I have an application written in C#, which allows the user to load their destination schema (in xml format) and writer their transformation expressions either in VBScript or in T-SQL. It uses DTS to do the ETL job.

Everything works great except with one problem. If there is a hypen ("-") in any of the destination attributes, the transformation fails with syntax error. It happens only with VBScript.

Here is my transformation:

"Function Main()

DTSDestination(\"Field-1\") = #01/01/2004#

End Function"

If I replace the hypen with underscore, it works without any problem.

Does anyone have any idea about this problem?Did you try to put the field name between brackets?
[field-1]|||Tried with \"[Field-1]\" and it did not do the magic|||Perhaps a hyphen is an invalid character for a field name. Use underscores and your problem is solved. You shouldn't be using '-'s in field names, anyway.|||In general hypen ('-'s) are not allowed in a field. But if you enclose in [], it is a valid chr (atleast in SQLServer!).

As my application is a B2B application and schema is maintained by an organization, I don't have any control. Hence I can not modify the field name.

BTW, I tried the same this with Enterprise Manager, it works.

DTS and SQL Server

Is it possible to run Data Transformation Services (DTS) on demand by having a user click on a button in an application with SQl Server?
I am creating a project in vb.net where I want the user to be able to hit an "update" button and data will be updated to my SQL Server table by DTS.

Also is it possible to check for duplicate entries before running DTS? E.g I want to append to my table but exclude duplicate entries UNLESS the data has changed for that entry.>>Is it possible to run Data Transformation Services (DTS) on demand

Yes. http://msdn.microsoft.com/msdnmag/issues/04/01/WebQA/

>>Also is it possible to check for duplicate entries before running DTS

Make this a step in your dts package

DTS and Oracle

I want to import a table called emp(user name scott/tiger) from oracle database to MSSQL database

Step 1
login to scott/tiger in oracle

Step 2
Create a table called emp

create table emp (empno int, empname varchar(20))

Step 3
insert into emp (empno, empname)
values(1,'aaa')

insert into emp (empno, empname)
values(2,'bbb')

insert into emp (empno, empname)
values(3,'ccc')

Step 4
Now I want to import this table to mssql using DTS.

I have used Data Transmission task in DTS for source query. I have given "select * from scott.emp"

I am able to get the exact result set. I am able to get the same values in MSSQL.

Step 5
Now I am creating another user called "test" and give access to "emp" table of "scott" user.

Step 6
Now i want to pass on "test" instead of "scott" in the Data Transmission Task.(i.e).
"SELECT * FROM test.emp" instead of "scott.test". I want to pass "test" dynamically.

how to do this.use a linked server to oracle.

create a stored proc with dynamic sql.

pass the table owner as a paramter to the stored procedure.|||Hi
I have given you only a sample. I dont have permissions to create tables or create stored procedures. I have only permissions for select statement.

Thanks

I want to import a table called emp(user name scott/tiger) from oracle database to MSSQL database

Step 1
login to scott/tiger in oracle

Step 2
Create a table called emp

create table emp (empno int, empname varchar(20))

Step 3
insert into emp (empno, empname)
values(1,'aaa')

insert into emp (empno, empname)
values(2,'bbb')

insert into emp (empno, empname)
values(3,'ccc')

Step 4
Now I want to import this table to mssql using DTS.

I have used Data Transmission task in DTS for source query. I have given "select * from scott.emp"

I am able to get the exact result set. I am able to get the same values in MSSQL.

Step 5
Now I am creating another user called "test" and give access to "emp" table of "scott" user.

Step 6
Now i want to pass on "test" instead of "scott" in the Data Transmission Task.(i.e).
"SELECT * FROM test.emp" instead of "scott.test". I want to pass "test" dynamically.

how to do this.|||how are you going to step 2 without create table permissions?|||Hi
I have given you only a sample. I dont have permissions to create tables or create stored procedures. I have only permissions for select statement.

Thanks

I think Thras meant to create the stored procedures on the SQL Server side.

Regards,

hmscott

Dts

Hi everybody

I have created tables in oracle 9i under a user using DTS in SQL Server. (i have exported from sql server to oracle 9i using DTS) . When i query select * from tab , it list al the tables created . But when i desc the structure of table or select * from table_name ,it shows object or view does not exist. what will be the problem ?
pls reply
ThanksWell this is more of an Oracle question...but I think the answer lies in the fact of the "user" (which in sql server is like the owner) who created the table.

Plus I wouldn't do it that way...

I would create all of my objects using DDL, bcp the data out to a pipe delimited file, copy the data to the Oracle box, and then use sqlLoader to populate the table.

DTS

What is the easiest way to give a user the abilitiy to run a DTS package
without having the Enterprise Manager on their workstation?I'm no expert my any stretch...I think there's an option to save your DTS
package as a Visual Basic executable file. If I remember correctly, this
option is provided while you go through the import/export wizard.
"Johnny" wrote:

> What is the easiest way to give a user the abilitiy to run a DTS package
> without having the Enterprise Manager on their workstation?|||Hi
Does the user have QA on his/her workstation?
"Johnny" <Johnny@.discussions.microsoft.com> wrote in message
news:5EAD6100-98E2-4378-B38D-D3BB8F059CE0@.microsoft.com...
> What is the easiest way to give a user the abilitiy to run a DTS package
> without having the Enterprise Manager on their workstation?|||> What is the easiest way to give a user the abilitiy to run a DTS package
> without having the Enterprise Manager on their workstation?
They need to have the dts runtime on their computer, then you can call
dtsrun.exe from the command line, for more info look in BOL.
If you wish to call a dts package from a sql script you can use
xp_cmdshell..

dtproperties system table changed to user table in sysobjects?

Hi Gurus,
I occasionally use some T-SQL to add a column or trigger to all usertables t
ables within a database.
It has always worked before but on one database I am having a problem becaus
e the "dtproperties" system table appears to have been changed to a user tab
le in the "sysobjects" table and is being returned in along with all the use
rtables by:
select [name] from dbo.sysobjects where OBJECTPROPERTY(id, N'IsUserTable') = 1
I can skip that table easily enough, but can anyone tell me why this may ha
ve changed and if I should change it back to a system table, if so how would
I go about that?
Regards,
Pauldtproperties is created when you create a database diagram. It is marked as
a user table by default so I suggest you exclude it by name in your script.
David Portas
SQL Server MVP
--
"Paul B" <paul.bunting@.archsoftnet.com> wrote in message
news:%234h2UcmxFHA.2728@.TK2MSFTNGP14.phx.gbl...
Hi Gurus,
I occasionally use some T-SQL to add a column or trigger to all usertables
tables within a database.
It has always worked before but on one database I am having a problem
because the "dtproperties" system table appears to have been changed to a
user table in the "sysobjects" table and is being returned in along with all
the usertables by:
select [name] from dbo.sysobjects where OBJECTPROPERTY(id,
N'IsUserTable') = 1
I can skip that table easily enough, but can anyone tell me why this may
have changed and if I should change it back to a system table, if so how
would I go about that?
Regards,
Paul|||... or also use IsMsShipped:
select [name]
from dbo.sysobjects
where OBJECTPROPERTY(id, N'IsUserTable') = 1
AND OBJECTPROPERTY(id, N'IsMSShipped') = 0
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:2f2dnarVIKxH5aPenZ2dnUVZ8t2dnZ2d@.gi
ganews.com...
> dtproperties is created when you create a database diagram. It is marked a
s a user table by
> default so I suggest you exclude it by name in your script.
> --
> David Portas
> SQL Server MVP
> --
> "Paul B" <paul.bunting@.archsoftnet.com> wrote in message
> news:%234h2UcmxFHA.2728@.TK2MSFTNGP14.phx.gbl...
> Hi Gurus,
> I occasionally use some T-SQL to add a column or trigger to all usertables
tables within a
> database.
> It has always worked before but on one database I am having a problem beca
use the "dtproperties"
> system table appears to have been changed to a user table in the "sysobjec
ts" table and is being
> returned in along with all the usertables by:
> select [name] from dbo.sysobjects where OBJECTPROPERTY(id, N'IsUserTable'
) = 1
> I can skip that table easily enough, but can anyone tell me why this may
have changed and if I
> should change it back to a system table, if so how would I go about that?
> Regards,
> Paul
>|||Thanks,
Was a bit puzzled as to the fact that it was shown as a system table by
Enterprise Manager and returned as a user table by "where
OBJECTPROPERTY(id, N'IsUserTable') = 1".
David mentioned it is added when you create a database diagram, is this
always the case?... the database I had the error did not have any diagrams
and never has (it was only created a couple of days ago), and a duplicate
database created at the same time returned "dtproperties" as a system table!
I had included an if statment to exclude that table, will probably switch it
to "OBJECTPROPERTY(id, N'IsMSShipped')" as suggested by Tibor... is there
any other tables that could be both system and user at the same time that
this problem may occur with?
Regards,
Paul
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eW7LtgpxFHA.2540@.TK2MSFTNGP09.phx.gbl...
> ... or also use IsMsShipped:
> select [name]
> from dbo.sysobjects
> where OBJECTPROPERTY(id, N'IsUserTable') = 1
> AND OBJECTPROPERTY(id, N'IsMSShipped') = 0
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
> news:2f2dnarVIKxH5aPenZ2dnUVZ8t2dnZ2d@.gi
ganews.com...
>|||EM is hard-wired to show dtproperties as a system table... The table might b
e created by other EM
GUI elements, like the design table dialog etc.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul B" <paul.no-email-please.bunting@.archsoftnet.com> wrote in message
news:Oduh6AsxFHA.2848@.TK2MSFTNGP15.phx.gbl...
> Thanks,
> Was a bit puzzled as to the fact that it was shown as a system table by En
terprise Manager and
> returned as a user table by "where OBJECTPROPERTY(id, N'IsUserTable') = 1
".
> David mentioned it is added when you create a database diagram, is this al
ways the case?... the
> database I had the error did not have any diagrams and never has (it was o
nly created a couple of
> days ago), and a duplicate database created at the same time returned "dtp
roperties" as a system
> table!
> I had included an if statment to exclude that table, will probably switch
it to
> "OBJECTPROPERTY(id, N'IsMSShipped')" as suggested by Tibor... is there any
other tables that could
> be both system and user at the same time that this problem may occur with?
> Regards,
> Paul
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n message
> news:eW7LtgpxFHA.2540@.TK2MSFTNGP09.phx.gbl...
>

DTEXEC /SET

Hello,

I have a command line as following, with DTEXEC to launch the execution of a package and to set a value (13335) of an user variable called CIB (string type):

dtexec /f c:\temp\PackageInsert.dtsx
/set \Package\DataFlowTask.Variables[Utilisateur::CIB].Properties[Value];13335

But I have got an error message saying that the object is not known in the package. My variable does exist in the variable window of the dataflow part.
Thank you for telling me what to set so that the variable can be set by the command line.

Regards,
Marie-Thrèse

I suspect the problem is the path in the set statement, check that the variable is scoped to the data flow task and notthe package for example. To help find the correct path, use the configurations wizard to set the variable value property, and just copy the path you get in there.

|||

Thank you so much for your advice. How should I do to use the configurations wizard, in order to get the correct path ?

|||

Marie-Thrèse wrote:

Thank you so much for your advice. How should I do to use the configurations wizard, in order to get the correct path ?

Every time you set up a configuration you have to tell it which object property you are talking about. On the last screen of the wizard the property paths are displayed.

-Jamie

|||

Thanks a lot Jamie for your advice

dt_ procs and the public role

In a SQL 2k instance (latest SP) some of my user databases show the public role with execute on a variety of stored procs named dt_* (i.e. dt_addtosourcecontrol). However, not all the user databases do this, some do not grant the public role execute on these procs .

So, can someone explain what generates these permissions and is it acceptable to remove them? If I have a database that does not grant public access, should I be concerned? I don't see any reference to these procs in BOL.

TIA,

Moblex

This seems to be a Visual Studio generated procedure, so you should ask this question on a Visual Studio forum. Here's a related thread

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=562892&SiteID=17

that I found with the following search query:

http://search.live.com/results.aspx?q=dt_addtosourcecontrol&mkt=en-us&FORM=LVSP&go.x=10&go.y=13

Thanks
Laurentiu

DSN-less connection

I am looking to try and connect to SQL Server via a DSN-less
connection in a VB application.
Setting up ODBC data sources is a headache for each user workstation.
There has to be an easier way.
Is there a straight forward way to do that or do you know a good
reference source that would have information on this topic?

Thank you.RLN (rlntemp-newsgroup@.yahoo.com) writes:

Quote:

Originally Posted by

I am looking to try and connect to SQL Server via a DSN-less
connection in a VB application.
Setting up ODBC data sources is a headache for each user workstation.
There has to be an easier way.
Is there a straight forward way to do that or do you know a good
reference source that would have information on this topic?

What is the problem?

What means of authentication do you use? SQL Server authentication or
Windows authentication? Is the server always the one and the same? What is
the database?

Our application addresses all these problems by prompting the user. Isn't
that feasible for you?

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx