sql server - SSIS Execute SQL Error: " " -


i getting error when trying execute sql file execute sql task in ssis (2012).

execute sql task: executing query "" failed following error: "".

i trying automate process import file testrail drops , recreates tables , fills them data.

i can open file in sql server management studio. inconsistent line endings warning when open file works when click yes or no normalizing them). worked first time created process file smaller didn't have data @ time.

any ideas why query might fail in ssis run in ssms? i'm thinking might funky syntax ssms figures out ssis can't.

here's whole error message:

ssis package "\valinor.k-net.com\users\bs\documents\visual studio 2012\tfs\data analysts\ssis packages\ssis packages\testrailrefresh.dtsx" starting. error: 0xc002f210 @ execute sql task, execute sql task: executing query "" failed following error: "". possible failure reasons: problems query, "resultset" property not set correctly, parameters not set correctly, or connection not established correctly. task failed: execute sql task warning: 0x80019002 @ testrailrefresh: ssis warning code dts_w_maximumerrorcountreached. execution method succeeded, number of errors raised (1) reached maximum allowed (1); resulting in failure. occurs when number of errors reaches number specified in maximumerrorcount. change maximumerrorcount or fix errors. ssis package "\valinor.k-net.com\users\bs\documents\visual studio 2012\tfs\data analysts\ssis packages\ssis packages\testrailrefresh.dtsx" finished: failure. program '[146976] dtsdebughost.exe: dts' has exited code 0 (0x0).

users have reported maximum size of submitted task 32k. suspect string submitting longer that. perhaps inserts can broken multiple execute tasks.


Comments

Post a Comment

Popular posts from this blog

java - Spring Data JPA: Why findOne(id) executing delete query internally? -

i have 1 application using @manytomany annotation link 2 different entities 1 parent entity. not sure if have implemented properly. when execute .findone() on parent entity's repository find it, @ first fetch data along executing delete queries internally delete record mapping table (a table jpa creates after adding @manytomany annotation.). following generated sql queries , code snippet: java class @entity @table(name = "inventory") public class inventory { @id long id; // many other properties @manytomany(fetch=fetchtype.lazy) private list<stream> streams; @manytomany(fetch=fetchtype.lazy) private list<subject> subjects; } there no other annotation i've put in stream , subject entity class link inventory class. when run app, create following tables: inventory stream subject inventory_stream inventory_subject (inventory_stream , inventory_subject, 2 tables created automatically, don't k...
Read more

python - Mongodb How to add addtional information when aggregating? -

i beginner , wrote line pipeline works, wanna add other information output, screen name , or number of tweets.i tried add under $group gave me syntax error everytime here pipeline: def make_pipeline(): # complete aggregation pipeline pipeline = [ { '$match': { "user.statuses_count": {"$gt":99 }, "user.time_zone": "brasilia" } }, { "$group": { "_id": "$user.id", "followers": { "$max": "$user.followers_count" } } }, { "$sort": { "followers": -1 } }, { "$limit" : 1 } ]; i using on example : { "_id" : objectid("5304e2e3cc9e684aa98bef97"), "text" : "first week of school on :p", "in_reply_to_status_id" : null, "retweet_count" : null, ...
Read more

java - Incorrect order of records in M-M relationship in hibernate -

Image
i have 4 records in bridge table in mysql database. using @manytomany in hibernate, accurate order of employees incorrect incorrect of projects. following required material figure out doing mistake. this source. @entity @table(name="project") public class projectbean { @id @generatedvalue @column(name="project_id") private int projectid; @column(name="title") private string projecttitle; @manytomany(mappedby="projects") private collection<employeebean> employees; public projectbean() { employees = new arraylist<employeebean>(); } //getters & setters } @entity @table(name="employee") public class employeebean { @id @generatedvalue @column(name="employee_id") private int employee_id; @column(name="first_name") private string ...
Read more