I get this error at the oledb cmd task where I have a update query which updates the EMp table with new and modified rows by cheking for the existing...

I figured out that the problem is occuering when inserting datetime field into destination table. In my source table i have datetime field as null. How can i handle this...

IS this easy to do with SSIS pkg having a conditional spilt. I am trying to do it as a recurring job.

Sorry I confused you with table names.

Actually I am trying to insert,update into Emp table from the Old Emp.

I want this done with single tsql query.

OldEmp(

EmpId=14556,14557,

Empno=467,345,

Empname=john,James,

Jobno=23,45,

Jobdesc=abcd,xyz,

JobTitle=TeamLead,ProjectLeader)

Emp(

EmpId=14556,14557,14567

Empno=467,345,435

Empname=john,James,Mike

Jobno=23,45,43

Jobdesc=abcd,xyz,dfgh

JobTitle=TeamLead,ProjectManager,Developer)

From the above data u can observe that 1 new record(Mike) was added and an existing record(James was changed from ProjectLeader to Project Manager) was updated.

what component i need to use to look up in destination table.

I am trying to do this in my OLE DN COmmand of SSIS package.

How can i?

Actually I need A query where i get

No of hours of each employee by the day and by the type of hours.

I think this shud work

Update authors

Setcity = replace(city, 'Salt', 'Olympic')

If its a password issue then how cud i resolve it for all the logins in the server, but still i wonder when the same logins are working well in...

I ran that script and came up with this

Msg 15291, Level 16, State 1, Procedure sp_change_users_login, Line 131

Terminating this procedure. The Login name 'AMEMpusr' is absent or invalid.

Msg 15291, Level...

I tried working with this script

http://support.microsoft.com/kb/246133/

looks like everything got trasnfered but when I try to login with some id, its not getting in, is there a chance that it broke...

I tried using tha scripts on MS supprt site(http://support.microsoft.com/default.aspx?scid=kb;en-us;246133#XSLTH3137121122120121120120)

but I gives an error though i have sysadmin previlage.

Msg 3704, Level 16, State 1, Line 2

User does not have permission to...

yes, when i click apply i get

WMI Provider Error

Access Denied(0x80041003)

yes i can do a telnet