A batch file can start a process, just like an Execute Process Task.

You have to call the batch file out of SSIS though.

How is the SSIS package currently started?

How do you change the destination database?

Did you use fast load in the OLE DB destination? Did you map the columns correctly?

spaghettidba (5/5/2014)

---

All the built-in collector types use SSIS packages to collect and upload data, but you don't have to install SSIS to make them work.

Looking in the installation folder...

I would assume that if you want to run an SSIS package, SSIS needs to be installed.

What exactly do you mean with this?

other built-in collector types work flawlessly even...

sqlservercentral.com 32358 (5/4/2014)

---

I'm currently re-writing an inherited C#/SQL CSV import process due to speed issues with the previous process (reading each line with a C# StreamReader).

The CSV has 6300 rows,...

Which version of SSIS are...

Thanks for the question by the way!

Hany Helmy (5/3/2014)

---

Thomas Abraham (5/2/2014)

---

paul.knibbs (5/2/2014)

---

Is it? I can't recall a situation where I've actually used this facility, although I knew...

SSIS will be difficult to use for this, since the data fow cannot handle changing metadata.

I would simple import the queries from the flat file into the database, loop over...

The MCSE exams are not dependent of a certain SQL Server version. In March they added questions to the exams that are about SQL Server 2014.

After a while, the certification...

How did you configure the OLE DB destination?

Not sure what you are trying to do.

The value of indicator is defined by values from a data set.

Answered incorrectly because I found some blogs online which said something different than the official answer.

Mystery mystery...

If they run in paralllel, they are independent of each other.

However, this is not 100% true. Say you have 7 tasks which can run in parallel.

But only 4 of time...