Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kumaresan82
Starting Member
1 Post |
 Posted - 2010-08-06 : 04:13:07
|
| Hi, I wand to retrieve the data from a Oracle DB as source and inset into a SQl sever table by using SSIS. The problem is the source oracle DB query size limit is around 6000 character. But the mictosoft supported size for DT_STR datatype is only 4000 characters. How can i use this full 6000 character query in my package? Somebody help me out on this code and providing which task need to be used for the above schenario? If not what workaround is avaialble? Really appriciate for any inputs.... |
|
|
|
|
|
SSIS-Oracle source to SQL Dest-Query size > 4000