nazaninahmady_sh (12/3/2008)

---

thank you for your reply

i want to get data with (ntext) type from one Database and input them in a another Database with (navarchar) type and for is purpose...

add

SET NOCOUNT ON

to the top of your t-sql code.

You are putting CLIENT with a datatype of varchar(255) into nvarchar(30) and nvarchar(100) there is possibilty that the data is too long so you will need to filter...

What I would do is;

Add a look-up transformation to look-up against the destination to see if the data exists, If you have a primary key you can join on...

there is a way;

CAST(YourTextCol AS NVARCHAR(MAX))

You may need to provide a bit more information for a complete answer.

such as;

how much data is being saved and how are you saving the data, are you...

I have found the problem with using an error redirect on a destination is that it usually throws an error before it has a chance to re-direct the row.

What I...

I tend to default to using NVARCHAR, unless i can absolutely be certain that there will not be any UniCode data in there. I find the increase in...

You can call a stored proc from another proc by using the standard EXEC funciton.

EXEC YourProc

Be aware though that you will have to be able to handle errors from...

what does your table structure look like?

Whay are you connecting diretly to the server, rather than using SSMS from your client machine?

In SSIS simply add a new Excel data...

The only way to can be really sure that the results are the same through-out the dev process , is to create a test-harness and use a product like NUnit...

Sounds like a strange error, I have not encountered this before, perhaps it is a problem with the server or disks. It may be worthwile to get the IT...

You cannot convert it to an int if there are CHARS in the cloumn as well.

FYI, the code for converting to an int is

CAST(YourField as Int)