Have you solved your Query issue..? i guess the guys in the forum are still willing to help.

Just let us know..:-)

Hi, instead of creating separated tables to hold the data and creating dynamic SQL queries, i recommend you keeping the original table (the one with the over 2M records) and...

You can use 2 methods.

Using openrowset whitin a sql query or using a dynamic properties task and assign the value returned by your query "select EMPID from tblEmployee where LastModifiedDate...

The sintax should be vbscript while you working with ActiveX. Not Sql. Try this, will work.

Function Main()

if datediff("d", pk12_date, current_timestamp) = 0 Then Main = DTSTaskExecResult_Success

End Function

'Cdrack.

For uploading the file to a table.

instead of using a .exe and xp_cmdshell you can use "bulk insert" with the raw option.

Will be faster and will not need to leave...