Errors occur when changing an initial SQL select in OLE DB source

-

hi all, i'm extracting data oracle db create flat file loading new db. i'm using sql statement in ole db source, applying lookup's, etc massage data format require.

i've defined select statement select table_b where, etc... need change select function(x) table_b where.... changes length of first column 2000 chars, initial column length 5 characters. following scripts , lookups have column defined 5 chars, , therefore fail. 

how change following items in flow cater larger length? ssis seems hang onto original column length , wont let me change it.  

i've had issue before. unfortunately cannot tell formal answer is, i've done delete ole db source , add new 1 new query. when connect new source existing transformations, see old column deleted. when reapir following transformations, should adjust new size.

 

hth

craig bryden - please mark correct answers


SQL Server  >  SQL Server Integration Services



Comments

Post a Comment

Popular posts from this blog

Motherboard replacement

-
running windows 10 technical preview, need replace motherboard can run the  sysprep  command restoring pc ? or there easier  or more preferred way ? thanks if replace motherboard within same family of chipsets (i.e. intel > intel or amd > amd), should okay restarting pc twice. carey frisch Windows 10 Insider Preview  >  Windows 10 Insider Preview General
Read more

Remote Desktop App - Error 0x207 or 0x607

-
hi all, i manage windows 2012 r2 network, including connection broker, session hosts , remote apps virtual servers.  i've used remote desktop app on own android phone, no issues @ - connects published gateway url , can login , access network. we looking move business onto nokia handsets ms operating system (currently on blackberry), not able connect via remote desktop app on nokia lumia handset. setup, per android config , brings remote apps , remote desktop screen, know can connect.  when select remote desktop, shows following process: initiating remote connection securing remote connection certificate can't verified - choose connect it digitally signed cert (digicert sha2), pc name different physical connection broker name (inherited domain name old gov project - can't publish publicly) initiating establishing securing connection error have been 0x207 getting 0x607 a bit baffled, work on android (and ipad @ home using app). assume ms use d...
Read more

AD Replication Failure Between Server 2008 R2 and Server 2003 - LDAP bind failed with error 8341

-
Image
hello, i adopted rather messy network previous engineer.  have 2008 r2 domain controller cannot replicate 2003 domain controller.  2003 pdce,  holding fsmo roles. both servers dns servers. as can see below, replication has not occurred in 3 months.  has become large issue workstations on network, exchange server. please note believe have done job of making sure there not duplicate dns entries either dc2003 or dc2008r2 on either server. thank can give. issues encountered while running commands from dc2008r2 : - when browse \\dc2003 dc2008r2 receive error: logon failure: account name incorrect. - when run dcdiag /test:dns i receive following initial error: performing initial setup:    trying find home server...    home server = dc2008r2    * identified ad forest.    [dc2003] ldap bind failed error 8341,    directory service error has occurred..    got error while checking...
Read more