Unless using Integration Services (which is a metadata control freak), normally things won't break that easily.

SQL Server will just use implicit conversions everywhere, which may impact execution plans and the...

HanShi (10/7/2014)

---

You can install multiple versions on the same computer. Best practice is to first install the older version (you say you have already SQL Compact) and then continue with...

Great question, I didn't know about this feature.

There is no backwards or forwards compatibility in SSIS.

If you need packages for SSIS 2008, you need to develop them in Visual Studio 2008 (aka BIDS).

That's an option yes.

You'll have to use .NET to do this. SSIS cannot do this out of the box.

You can execute a package stored in the SSIS catalog using stored procedures:

Deploy and Execute SSIS Packages using Stored Procedures

You can execute the package synchronously using a parameter:

Execute a SSIS...

Which version of SSIS are you using?

In SQL Server 2012 and above, you can start packages using stored procedures.

Maybe you can implement some restart machinism there.

ChrisM@Work (10/6/2014)

---

+1

Our little team's working with DB2. If you...

Good catch.

And that's why we use the SQL formatting people 😀

ronan.healy (10/6/2014)

---

ya there is a green arrow and a red arrow.

is there any way i can put a flat file destination as package run through.

what they want it to be...

HanShi (10/6/2014)

---

Last weekend attended the preconference and SQL Saturday in Vianen/Utrecht (The Netherlands). Unfortunate Learte JR couldn't make it so I missed the Powershell pre-con. So I went to Denny...

Not sure what your question is.

A derived column has only two outputs: a normal one (the green errow) and the error output (the red arrow).

So you can hook up a...

Interesting trick, thanks for sharing.

You cannot use sum on a text column. Is it possible to give some sample data and desired output?