mANY THNAKS FOR REPLY...

How to convert the datatype.Can you please let me know......

can you please let me know whether i have TO change the distination OLE DB cloumns DATA TYPE...

Thanks,

I am unable to change the datatype TO DT_STR

dataflow--advance options--EXTERNAL columns----try to change the datatype --click ok

but it is not chaNGING...

pLEASE ADVISE.

My appoliges,

Now I have checked in destination OLDB on package and the datatype is DT_WSTR for those 3 columns

the datatype which said before i.e varchar(), i have seen from Sql...

Thanks so much for replying,

i have given mapping and got the below error,

Error at dtstask_dtsdatapumpTask_1[ole db destination[34]]:columns "col4" and "u_nme"

cannot convert between unicode and non-unicode string data types

Error...

I have run the package in BIDS.it fails with below warning.

"

Warning1Validation warning. {8E1B1707-E8C6-4642-8069-D730ED0F410D} OLE DB Destination [34]: The external columns for component "OLE DB Destination" (34) are out of...

THanks,

In Flat file we are having 6 colums and in table we have 7 columns and there is difference in columns between Flat file and Table.

when we try to open...

THanks you so much for help,

Wea are this Package to Load the data to Table from a Flat file.

I have changed the Authentication to windows mode and am...

i have changed the

the Protection Level of Packages from "EncryptSensitiveWithPassword" to " Dont save sensitive"

and run the package.Bit still got the below errors.

SSIS Error Code DTS_E_OLEDBERROR. An...

do i need to increase the log file size or do i need to put file to unrestricted size.

Yes we are going from table to flat file.

the column is nvarchar(30) --table.This table does not contain any extended-character-set data,

In flatfile (On SSISdoule click Textfile Destination ---Flat Filedestination...

Any guidenc PLZ

I could see the source table in database for that cloumn is 30( vachar) and on the flat file in siss it is showing as 255.

ssis-package-dataflow-flatfile (doubleclick) there it is...

Thanks for help,

I was able to connect the package.

Can you please tell me where have to change or modify the column size.

can you plz guide me the steps

Many THANKS.

THanks for reply,

how to see where the source and distination files are located

DTS package was not created on the same system

issue seems to be 32 bit /64bit machine issue.

can you please tell me how to convert the pacakage to...