Viewing 15 posts - 5,536 through 5,550 (of 11,678 total)
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...
July 16, 2013 at 3:08 pm
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...
July 16, 2013 at 2:47 pm
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...
July 16, 2013 at 2:31 pm
July 16, 2013 at 1:33 pm
The Dixie Flatline (7/16/2013)
Steve Jones - SSC Editor (7/16/2013)
Arrgggg, some days I hate software.Don't be hatin' , Steve.
Haters gonna hate 😀
But Steve, only some days?
July 16, 2013 at 1:31 pm
sqlfriends (7/16/2013)
But sometimes for some data entry issues, I found this is a quick way to edit the data quickly.
I...
July 16, 2013 at 1:12 pm
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...
July 16, 2013 at 5:39 am
Brandie Tarvin (7/16/2013)
You gave me the solution before you even read the post. @=)
That's how I roll 😀
July 16, 2013 at 5:00 am
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...
July 16, 2013 at 4:50 am
So far I have no reason to believe the quirky update is gone. And I don't think it will dissapear soon.
July 16, 2013 at 3:45 am
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...
July 16, 2013 at 3:44 am
Anything special in the data flow? Lookups, conditional splits?
July 16, 2013 at 2:35 am
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.
July 16, 2013 at 1:58 am
Viewing 15 posts - 5,536 through 5,550 (of 11,678 total)