Did you manage to automate the FTP part? How did you do it?

awaisahmad435 (6/1/2011)

I WANT TO ELIMINATE IN CLASS.... IS THAT POSSIBLE

update TBL_DEGREE_COURE_MASTER

set flag = 'FREE', flagtime = 'Application Crashed'

where SYSTEMID IN

(select b.systemid

from sys.dm_exec_connections...

For those who have trouble with SQL in plain text, here it is again with formatting:

CREATE PROCEDURE Refresh_Lock

AS

DECLARE @AccountID VARCHAR(100)

DECLARE @getAccountID CURSOR

SET @getAccountID = CURSOR FOR

SELECT TABLENAME

FROM DBO.TMP

OPEN @getAccountID

FETCH...

I would try putting package 1 in a sequence container and then adding the constraint from that to package 2.

..and if you access 2005 packages using 2008, you will have to upgrade them before they can be amended. Once they've been upgraded, they will no longer open in 2005.

How does this solution address the ftp requirement?

if you don't include a question in your post, how can you expect an answer?

Sounds like a simple SSIS package just waiting to be written ...

I would advise you to consider a modification to your update methodology. With large datasets, this RBAR method performs badly.

A faster alternative is to send the records to be updated...

Great. My pleasure.

Ah yes, I see.

You could try this sort of thing:

SET @finalQuery = 'SELECT acc.[ACCOUNT], acc.[NOIND], tr.[S''mentdate]'

I'm not 100% sure what that code is doing, but I'm guessing that somehow the derived SELECT query is being used to create a table on SQL Server?

If so, just...

What is your question?

Sorry dude: it does work, I can assure you.

Expanding on Koen's reply a little, SSIS packages are discrete dtsx files....