DTS Unspecified error

I have a DTS to transfer logins from one server to a another server. I have put the syslogins.dat file in the share directory. But this DTS is giving 'Unspecified Error'. Any help would be appreciated.
ThanksI would not try copying a dat file. Use tranfer SQL Objects.|||I guess, the dat file has nothing to do with this DTS. Because, the transfer logins task takes just the source and destination servers. I'm not sure how it transfers the logins and why it should give 'Unspecified error'.|||Are you saying you are not copying the dat? And the DTS is trying to transfer the logins?

What about permissions on both servers?|||I'm not copying the dat file.
What permissions should I check. I ran this DTS from Enterprise Manager. The logins are same in source and destination server.

I just tried to run it through a job and it failed with error 2147467259 (80004005).|||I just tried SQL Server Authentication instead of Windows Authentication and it still gives the same problem. I don't know what the heck this 'Unspecified error' means and this is driving me crazy|||If you have not tried this...
Change the task to something that should have no trouble completeing.
In other words does any work with that DTS?|||Yes. All the other DTS packages execute properly. I just tried 'create table','delete table', 'connection to excel'..etc. and everything just completed fine.

DTS Transform

I get this error:

column 6 ('CheckDate', dbType_dbtimestamp), status 6: dat over flow
invalid character value for cast specification

Here is the sql generated :

CREATE TABLE [DMS].[dbo].[Master] (
[Date_Entered] smalldatetime NULL,
[Initials] nvarchar (10) NULL,
[VendorName] nvarchar (50) NULL,
[CheckNum] nvarchar (20) NULL,
[ExpenseType] nvarchar (10) NULL,
[CheckDate] smalldatetime NULL,
[CheckAmount] money NULL
)

IM guessing i need to change date_enteed type or do a cast

any help pls

!~<Mis there anybody who has any idea about this?|||Is this the table DTS is inserting into, or is it actually trying to create the table? If it's trying to insert, change the CheckDate to datetime instead of smalldatetime and see if that fixes it.|||smalldatetime to datetime will not make a difference if value in the source is not a date. I'd suggest to change CheckDate and possibly Dtae_Entered to varchar(25), but add 2 calculated fields that would convert a valid date to date or NULL if it's not. Put them at the end of the table and do not insert anything into them (it'll fail if you try).

CREATE TABLE [DMS].[dbo].[Master] (
[Date_Entered] varchar(25) NULL,
[Initials] nvarchar (10) NULL,
[VendorName] nvarchar (50) NULL,
[CheckNum] nvarchar (20) NULL,
[ExpenseType] nvarchar (10) NULL,
[CheckDate] varchar(25) NULL,
[CheckAmount] money NULL,
[Date_Entered_Calc] as case when isdate([Date_Entered])=1 then cast([Date_Entered] as datetime) else cast(null as datetime) end,
[CheckDate_Calc] as case when isdate([CheckDate])=1 then cast([CheckDate] as datetime) else cast(null as datetime) end
)