DTS vs SQL Agent Job | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTS vs SQL Agent Job

Hey all-<br /><br /><br />I have a dts package in which I am trying to do a straight copy from a DB2 database. I get the following error: <img src=’/community/emoticons/emotion-2.gif’ alt=’:D‘ />ata for source column(ColumnName) is too large for the specified buffer size."<br /><br />I can do a straight copy from a linked server within query analyzer and also via an sql agent job without issue. <br /><br /><br />I THINK it may have to do with unicode characters as I was troubleshooting I changed<br />a double quote from ” (Pasted from MS WOrd) to " (Regular text) and the DTS ran OK.<br />It is impractical for me to sdcan any text column for non standard characters I would think.<br /><br />I have several tables I need to do this on and would like them all in onne place, hence my reasoning to accomplish via DTS.<br /><br />I am not sure how to handle this, any ideas? Thanks!
This maybe of help: http://support.microsoft.com/kb/281517/EN-US/ I think it is a provider problem rather than the source data. SQL can handle unicode characters. If you want to keep them just use the datatypes nvarchar, nchar or ntext. Simon