sql server - SSIS truncation error only in control flow -


i have package giving me confusing "text truncated or 1 or more characters had no match in target code page" error when run full package in control flow, not when run task itself.

the first task takes csv files , combines them 1 file. next task reads output of previous file , begins process records. odd truncation error thrown in flat file source in 2nd step. exact same flat file source destination in previous step.

if there truncation error wouldn't thrown previous step tried create file? since 1st step created file without truncation, why can't read same file in next task?

note - thing makes package different others have worked on dealing special characters , using code page 65001 utf-8 capture fields have special characters. other packages referencing flat file connection managers code page 1252.

control flow showing both steps

data flow showing error flat file source

the problem caused foreach loop , using columnnamesinfirstdatarow expression have formula "@[user::count_raw_input_rows] < 0". have variable initialized -1 , assign columnnamesinfirstdatarow flat file. when in loop update variable row counter on each read of csv file. puts header in first time (-1) avoids repeating on other csv files. when exit loop , try read input file treats header data , blows up. avoided on last package because didn't tighten column definitions flat file did package. help.


-

Comments

Post a Comment

Popular posts from this blog

Java 8 + Maven Javadoc plugin: Error fetching URL -

i attempting generate javadoc links javadoc dependencies. have tried various means generate javadoc not produce qualified class names references classes dependencies. wanted links java doc simplified class names. however, java api classnames, no links , have qualified class names. working java 8. have following configuration: <plugin> <groupid>org.apache.maven.plugins</groupid> <artifactid>maven-javadoc-plugin</artifactid> <version>2.10.2</version> <configuration> <reportoutputdirectory>${project.basedir}/target</reportoutputdirectory> <destdir>javadoc</destdir> <windowtitle>epiphany</windowtitle> <doctitle>epiphany</doctitle> <show>private</show> <detectlinks>false</detectlinks> <detectoffline...
Read more

c++ - Msgpack packing bools bug -

for c++ project use c++ msgpack library available in ubuntu (14.04) standard repository under name libmsgpack-dev. all works fine except when try pack bools. there things go absolutely bananas. first wrote simple test study pack method. turned out, can not trusted packing bools. here simple test showing problem: #include <msgpack.hpp> test_case("bool packing", "[msgpack1]") { msgpack::sbuffer buf; msgpack::packer<msgpack::sbuffer> p(&buf); std::string key = "boolvalue"; bool value = true; p.pack_map(1); { p.pack(key); p.pack(value); } msgpack::unpacked msg; msgpack::unpack(&msg, buf.data(), buf.size()); std::map<std::string, msgpack::object> m; msg.get().convert(&m); bool loaded_value; m.at(key).convert(&loaded_value); info("we packed: " << value); info("we loaded: " << loaded_value); r...
Read more

hex - Lua: Hexadecimal Word to Binary Conversion -

i'm attempting create lua program monitor periodic status pings of slave device. slave device sends status in 16-bit hexadecimal words, need convert binary string since each bit pertains property of device. can receive input string, , have table containing 16 keys each parameter. having difficult time understanding how convert hexadecimal word string of 16-bits can monitor it. here basic function of i'm starting work on. function slave_status(ip,port,name) status = path:read(ip,port) stable = {} if status stable.ready=bit32.rshift(status:byte(1), 0) stable.paused=bit32.rshift(status:byte(1), 1) stable.emergency=bit32.rshift(status:byte(1), 2) stable.started=bit32.rshift(status:byte(1), 3) stable.busy=bit32.rshift(status:byte(1), 4) stable.reserved1=bit32.rshift(status:byte(1), 5) stable.reserved2=bit32.rshift(status:byte(1), 6) stable.reserved3=bit32.rshift(status:byte(1), 7) stable.r...
Read more