Sign in | Join | Help

Piotr Rodak

if datepart(dw, getdate()) in (6, 7)
use pubs;

This Blog

  • Home
  • Contact

Syndication

  • RSS
  • Atom
  • Comments RSS

Search

  • Go

Tags

    • bcp
    • BLOB
    • bug
    • bulk insert
    • c#
    • collation
    • concurrency
    • configuration
    • data access
    • data import
    • database maintenance
    • deadlocks
    • distributed transaction
    • download
    • error
    • errors
    • ETL
    • events
    • format files
    • linked server
    • locking hits
    • MARS
    • Numbers table
    • OLE DB
    • OPENQUERY
    • performance
    • photography
    • practices
    • Profiler
    • programming
    • Reporting Services
    • revelations
    • scientific notation
    • script
    • security
    • source code
    • SSIS
    • SSRS
    • Sybase
    • Tally table
    • textsize
    • tips and tricks
    • trace flags
    • trigger
    • troubleshooting
    • truncate
    • t-sql
    • util

Navigation

  • Home
  • Blogs
  • Forums
  • Photos
  • Downloads

Archives

  • March 2010 (1)
  • February 2010 (2)
  • January 2010 (4)
  • December 2009 (2)
  • November 2009 (1)
  • October 2009 (2)
  • September 2009 (1)
  • July 2009 (1)
  • June 2009 (1)
  • May 2009 (1)
  • April 2009 (1)
  • March 2009 (1)
  • November 2008 (1)
  • April 2008 (1)
  • December 2007 (1)
  • November 2007 (3)
  • October 2007 (2)

Browse by Tags

All Tags » truncate (RSS)
  • BLOB
  • OLE DB
  • SSIS
  • Sybase
  • textsize
  • tips and tricks
19 April 2008 12:17

SSIS truncating BLOB fields from Sybase

Last week I struggled with issue that had been causing many problems in our work. We have implemented SSIS packages that synchronize Sybase and SQL Server databases. Some of tables contain text (on Sybase) columns that have to be passed to varchar(max...
Posted by Piotr Rodak | with no comments
Filed under: tips and tricks, truncate, textsize, Sybase, BLOB, OLE DB, SSIS
 
Powered by Community Server (Commercial Edition), by Telligent Systems