SSIS can run procs in parallel, no problem.

BWFC (8/4/2016)

---

Really sorry for a techie question on here but I'm not sure that this is worth a thread of its own.

When calling multiple stored procs from another, they executed...

joanna.seldon (8/4/2016)

---

I just need at the end of the view remove the records where if StudentTransportOrder has two instances of the same VehicleID, keep record of the VehicleType = Car...so...

Where are the truncation errors happening?

Are they at the flat file source, or the SQL Server destination?

Does running the package as a SQL Agent job work?

Please do not cross-post in future, it fragments responses and wastes people's time.

Responses here please.

J Livingston SQL (8/3/2016)

---

well I disagree.....on the assumption that you wish to plot the course of...

lduvall (8/3/2016)

---

Would you share your code? I'd love any help. What I have now will already return me the entire line that failed but I have not parsed it into...

Eirikur Eiriksson (8/3/2016)

---

Phil Parkin (8/3/2016)

---

Eirikur Eiriksson (8/3/2016)

---

A while back I did an import system that used a staging table with x number of varchar(xxx) column and a error flow to...

Eirikur Eiriksson (8/3/2016)

---

A while back I did an import system that used a staging table with x number of varchar(xxx) column and a error flow to insert to a table...

lduvall (8/3/2016)

---

I'm using SSIS to load tab-delimited text files into a SQL staging db. Naturally, I'm having to deal with truncation issues. I'm using the newly-introduced GetIdentificationStringByID method to get...

Nusc (8/3/2016)

---

--snip

I want to try what you did. The xlsx file is supposed to be saved as a csv but the forum wont' allow me to upload csv files. I...

You'll need to register that external assembly with SQL Server first.

I'm no expert in this, but perhaps this link will help you.

I cannot see a question here. What is the 'issue', exactly?

Can you provide some test data and expected results? That is, a working test harness, rather than just code fragments.

yujinagata72 (8/2/2016)

---

Hi,

When I run an SQL query, sometimes I got the error,

and sometimes is okay....