sarah.cook (8/23/2013)

---

Thanks very much for your reply. Very helpful.

Looks like there's no real elegant way to do this (besides going through teh trouble to write a custom script) although...

Are you able to provide DDL, sample data and desired output, as per the link in my signature?

Can I also suggest that you read up on column aliases - it...

If you are using SSIS 2012, you should also be aware of the new project deployment model. Some fairly detailed info here[/url].

If you use it, you don't get any choice...

--Edit: reply removed as did not answer question!

Sorry...

SQLArnold (8/20/2013)

---

Thank you for your reply it is greatly appreciated.

I thought I would have a problem deleting the file after I moved it. Our DBAs allow business analysts to have...

whereisSQL? (8/20/2013)

---

I am stuck at a similar dilemma with Excel source and Jet provider.

Cannot edit registry key.

I was thinking about this.. but I am not sure if it is possible.....

Sure. And I also reckon that

refers to the SSIS Catalog maintenance task 🙂

Reported as spam.

Especially when there is only one answer to select from .. truncate table or ... nothing 🙂

polkadot (8/15/2013)

---

Strange, I've got both installed (SSMS 2008 & SSMS 2012) and I'm definitely connecting to the one listed in my START menu as 2012, and even the Help->About dialogue...

jbowers (8/15/2013)

---

You state that the wizard method of project deployment "is of course not suited to deploy projects to the production server". As someone who is just upgrading from SSIS...

mtassin (8/15/2013)

---

Hey Koen,

Nice article. I hope you'll at some point discuss the headaches of managing the execution logs of projects deployed to SSISDB. 🙂

Especially with the headaches that...

Have a look here[/url].

I can't easily reproduce this error, so couldn't test this.

If you put the select in a try/catch block, is control passed to the catch block when the table is not...