thanks brother it works.

But can you please let me know how can i do the same with out using CTE feature of sql server , like may be using...

u can just put an activex script after ur FTP task to move or delete processed file.

here is the code for activex script

'**********************************************************************

' Visual Basic ActiveX Script

'************************************************************************

Function Main()

Dim fso,...

tnx for the reply..i was able to find the solution for my question..it was the 'Fail on first Error' checked on Logging tab in package properties 🙂

thanks much for the workaround..let me try that way:)

thanks for the reply Brian....here i dont want users present in the source instance(production) while i need to create new user id on the UAT instance only.

can u give the query i can use for retrieving the files stored in sql table..so that i can download it to local system and then i can format it.

Thanks...even i found the - DBCC SQLPERF (LOGSPACE) which gives complete list

Hi Jeff,

can u please let me know similar query to retrive doc, image,pdf files stored in sql server tables.

Thanks in advance

Hi jeff,

That was informative...is ther a way using sql query to retrive the doc,image,pdf from the sql server tables to local computer with out using any ADO or front end...

type the folowing in commond promt will list u all the ssis packges

1. cd2. dir/s *.dtproj

but it ask for creating OLEDb connection, can u plz let me know how to create OLEDb connection to XML file or is ther any other easy way to import...

I want to import XML file not an excel file.

Thanks a lot for that script.:)

Thank you for the reply. Could you please suggest me the best way among these, so that it wont slow down performance the production database.

:w00t: ok Jeff....just in some cases i need to do that way....am using sql server 2005....

thanks much for ur reply