Very interesting question, thanks!

Apparently you have some encryption going on in your package. Open it up and take a look at the package protection level.

Either turn it off or set it to a...

DTS isn't a command. It's a switch telling dtexec that the package is stored in the SSIS package store. You need to put dtexec at the start of your command...

Any error messages?

edit: when I look for examples of SSIS packages being executed by xp_cmdshell, I see that they are escaping the " in their code. Maybe you need to...

Try the following:

select * from tableA a with(nolock)

join tableB b with(nolock)

on a.id = b.id

where a.date > getdate()

Yes.

CREATE LOGIN (Transact-SQL)

Haters gonna hate 😀

But Steve, only some days?

sqlfriends (7/16/2013)

---

Most of time I will use update query to do that.

But sometimes for some data entry issues, I found this is a quick way to edit the data quickly.

I...

Never really payed attention to it, but you're right. I just ran a package with every possible log event enabled, but the columns are still the same.

So you can basically...

That's how I roll 😀

Whoah, I have read all of this text for nothing? 😉 😛 😀

I had the same issue once during a SSIS training. It took me a few minutes before I...

So far I have no reason to believe the quirky update is gone. And I don't think it will dissapear soon.

SQL 2014 has not yet been released. (we're not yet in 2014 remember)

There is a public CTP available, but these things can still be riddled with bugs. Furthermore, you cannot...

Anything special in the data flow? Lookups, conditional splits?

You can modify data that way, but it is rather quick and dirty.

And you need to be sure your view is updateable.

I'd still prefer to write a decent update query.