SEO

#1 (**permalink**) 02-29-2008, 01:54 PM

Hi all,
I'm fairly new to this...

I't trying to design a DTS package on SQL Server 2000`, which will
connect to the server, export some table date into a .txt file (based
on a select statement) and then delete the data from the table (based
on a delete statement) upon successful completion of the export.
So far so good..

Now, upon the successful deleteion, I want to export some more data and
then (upon the successful export) to delete the data. I want to repeat
this process approx. 10 times.
Though, when I try to link the deletion to the new export on success, I
get the message: "Defining the precedences between the selected items
is not valid."

Any idea on how I can accomplish what I want to do?

thanks a lot

#2 (**permalink**) 02-29-2008, 01:54 PM

Try adding the text file target and transformation and then putting the 'on
success'. Or, in another words, define the next task and then do try the
precedence. If this doesnt help, please provide more info.

MC

"nai" <nioannides@laiki.com> wrote in message
news:1132052395.069551.53780@z14g2000cwz.googlegro ups.com...
> Hi all,
> I'm fairly new to this...
>
> I't trying to design a DTS package on SQL Server 2000`, which will
> connect to the server, export some table date into a .txt file (based
> on a select statement) and then delete the data from the table (based
> on a delete statement) upon successful completion of the export.
> So far so good..
>
> Now, upon the successful deleteion, I want to export some more data and
> then (upon the successful export) to delete the data. I want to repeat
> this process approx. 10 times.
> Though, when I try to link the deletion to the new export on success, I
> get the message: "Defining the precedences between the selected items
> is not valid."
>
> Any idea on how I can accomplish what I want to do?
>
>
> thanks a lot
>

#3 (**permalink**) 02-29-2008, 01:55 PM

Thanks for the prompt reply.
I had already tried this..

Connection to server:
Microsoft OLE Provider for SQL

Transform data task properties
SELECT * FROM UAF_REQUESTS
WHERE UAF_REQUESTS.CREATED < GETDATE()- 90
AND UAF_REQUESTS.RESPONSECODE = 'OK'

Export
to Text File, location F:\Backups\U_REQ.txt

ON SUCCESS

DELETE FROM UAF_REQUESTS
WHERE UAF_REQUESTS.CREATED < GETDATE()- 90
AND UAF_REQUESTS.RESPONSECODE = 'OK'

--- Then I created another export to txt file

Selected the export object and the delete one, and tried to connect
them on success. The error message is the one mentioned in my first
email.

Please let me know if any other details would be helpful.

thanks

#4 (**permalink**) 02-29-2008, 01:55 PM

I've sent you an email since i can do a package you described. Perhaps I
misunderstood or theres a difference in sequence or something. LMK.

MC
"nai" <nioannides@laiki.com> wrote in message
news:1132057983.407974.60410@f14g2000cwb.googlegro ups.com...
> Thanks for the prompt reply.
> I had already tried this..
>
> Connection to server:
> Microsoft OLE Provider for SQL
>
> Transform data task properties
> SELECT * FROM UAF_REQUESTS
> WHERE UAF_REQUESTS.CREATED < GETDATE()- 90
> AND UAF_REQUESTS.RESPONSECODE = 'OK'
>
> Export
> to Text File, location F:\Backups\U_REQ.txt
>
> ON SUCCESS
>
> DELETE FROM UAF_REQUESTS
> WHERE UAF_REQUESTS.CREATED < GETDATE()- 90
> AND UAF_REQUESTS.RESPONSECODE = 'OK'
>
> --- Then I created another export to txt file
>
> Selected the export object and the delete one, and tried to connect
> them on success. The error message is the one mentioned in my first
> email.
>
> Please let me know if any other details would be helpful.
>
>
> thanks
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

DTS package design - Not allaowed link