You just need to write your own script using the code provided in the link and put this script in an SQL Server Job and schedule it on a daily...

Basically, you need 1 ForEachLoop File Enumerator, 2 Variables (one to hold fully qualified name and the other one to hold file extension) and 2 DataFlow Tasks with conditional workflows/precendences.

Then...

hidayath (3/30/2009)

---

thanks

I did all and check the port and ip also

Not able to add in Enterprise manager from other servers.

When adding in ASP pages giving as Sa Login failed...

Can you please cross check the following?

1. Ping the server and check for connection

2. Try connecting using Server IP Address

3. Verify the Server Name used

4. Check if the fireball is...

This will give you the balance quantity left for a supplier for a product...

SELECTp1.productID, p1.productname, p1.suppliername, p1.quantity - p2.quantity AS quantity

FROMproducts p1

LEFT JOIN

(

SELECT productID, suppliername, SUM( quantity )...

Or you can use the SQL 2005 new ranking functions...

; WITH Responses

AS

(

SELECTmemberID, COUNT( * ) AS Responses

FROMdbo.memberResponses

WHEREresponseID IN( 1,3,4,6,8,15 )

GROUP BY memberID

)

SELECTROW_NUMBER() OVER( ORDER BY Responses DESC ) AS RowNumber,

RANK()...

I wish you used SQL 2005, as this can be easily done using ROW_NUMBER function. However, you can still achieve the same in SQL 2000 using three different ways...

Here is an article that has samples about files & folders expresssions

Since you have multiple records in @assign table for each product in a branch, joining it to the @sold table yields duplicate records for the same product and branch and...

You have set the sorting columns in the "Sorting" section of the "Grouping and Sorting Properties" properties of the group.

Optionally, you can use Expressions to conditionally sort the...

Here is a link on how to archive old data using T-SQL

Is this what you're looking for?

;WITH Logons

AS

(

SELECTROW_NUMBER() OVER( PARTITION BY EmployeeNumber ORDER BY LogonTime ) AS RowNumber,

LogonTime, EmployeeNumber

FROMLogon

),

Logoffs

AS

(

SELECTROW_NUMBER() OVER( PARTITION BY EmployeeNumber ORDER BY LogoffTime ) AS RowNumber,

LogoffTime, EmployeeNumber

FROMLogoff

)

SELECTI.EmployeeNumber, O.LogoffTime,...

Assuming that you have two DataFlow tasks and you just wanted to direct the execution conditionally to these two tasks, you just have set the "Precedence Constraint" of "Workflow" to...

I had few problems with the Execute SQL Task in SSIS when executing procedures with parameters. Then, what I've done is, instead of setting parameters in Execute SQL Task,...

What exactly are you trying to do with that code? Only then, we can help you re-write that code correctly.