No.

Features Supported by the Editions of SQL Server 2012

Use a dataflow. Put an OLE DB source and use your stored procedure there.

Link it to a flat file destination. In the flat file connection manager, configure the file name...

SSIS 2005 packages need to be upgraded before you can run them with a 2008 instance. However, SSIS doesn't work with Express versions, so your 2008 express version is useless...

Nice question, thanks.

Nice question, interesting discussion.

Thanks for the question.

Interesting question. Will never use it in production, but interesting nonetheless 🙂

Interesting question, thanks Hugo.

Congratulations to you both, and well deserved!

Nice question, thanks.

What you can...

rustman (4/11/2013)

---

How abou the Deployment Utility that you can generate when building the package? I do not have 2012 to test but 2008 has this built in.

Right click on the...

You use dtutil.

It's a command line utility to deploy packages.

In a batch job you can...

reuben.anderson (4/10/2013)

---

p.s. all of which has meant I struggle to understand why an Integration Server is needed at all. An engine to execute packages may as well be included in...

tim.gray 23818 (4/10/2013)

---

I don't think the "Pragmatic" way is actually very pragmatic. In lots of places, developers aren't supposed to be touching production servers and development tools should not be...