On Darren's page...
http://www.sqldts.com/default.aspx?288

At the bottom of the page, the DTS icons are shown with an Execute SQL Task
"Create MDB" connected (via. success arrow) to a Microsoft OLE DB provider
for SQL Server connection "SQL Server".

When I attempt to place the success workflow arrow, I get a DTS Designer
Error: "Defining precedences between the selected items is not valid."

I am still quite new to DTS so i'm sure that I have made some basic error in
the set up. Can anyone point me to what this error might be?

I am running SQL Server 2000 on a Win2000 machine.

Bonus question!
In the example on the page that creates an access DB then creates a table.
How would I dynamically build and load (at run time) the CREATE TABLE
statements from the source SQL Server table?

--
Regards,
John

That is not a precedence constraint it is a Transform data task. You define
precedences between Steps not connections. The distinction in DTS is
blurred, SSIS makes this difference more apparent.



--


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com


"John Keith" <JohnKeith (AT) discussions (DOT) microsoft.com> wrote

Hi Allan, and thanks for the quick reply.

When I select [Create Table] and [SQL Server] then try to add the Transform
data task... I get DTS Designer Error: "Transforming data between the
selected items is not valid. Select unique connection items to transform
data."

I am able to assign the data pump between SQL Server and Microsoft Access.
the phrasing of the error message seems to indicate that a Transform Data
Task connects two connections.

On the web page the colorization of the arrow shows it is a "success" arrow
and not a transform data task. But with my set-up neither seems to work.
Perhaps that middle arrow not needed at all?

I need to upgrade to SSIS, before I learn bad DTS habits!

--
Regards,
John


"Allan Mitchell" wrote:

It sounds as though you are trying to pump data between the same connection
object. I think what you may have done is this

You have dropped into designer a SQL Server connection and set her up
You have dropped on another SQL Server Connection and checked the radio
button that says to base it off an existing connection and in that box you
have specified the original connection.

You are now trying to pump between the two.

You can't.

Define the destination connection as a connection in its own right or at
least a copy of a connection that is not the source
--


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com


"John Keith" <JohnKeith (AT) discussions (DOT) microsoft.com> wrote

Thats sort of what happened,

I had not completed the SQL statements nor had I set up the full data pump
from SQL Server to Access. Once that was done... AND in the Execute SQL
task... tell it to expect microsoft Access style of SQL... that char(96)
delimiter.. it all worked

Then I WAS able to add the sucess arrow pointing from the SQL task to the
SQL server connection.

Thanks for the help!

--
Regards,
John


"Allan Mitchell" wrote: