Great answer!

FAIL

The .dtsx files are absolutely abysmal for source control. Impossible to merge or get any idea of what was changed from version to version, so the only thing you...

It likely DTExec that's actually getting blocked.

Hi, I bought this one... it come with a nice jquery integration to load states and cities. http://www.jaxiter.com/scripts/signup

Thanks for the stab at it.

Right now, our admins have about 2000 rules defined (spanning all our clients) so one query to do it all doesn't seem optimal.

So far...

CTEs are generally poor performing. We have had to rewrite several for performance reasons. Your example breaks down when you have a table with a lot of rows and takes...

i had the same problem. Try to check what database have you selected. In my case i was using ´master´ LOL.

hmmmm...

try extracting the standalone installer with WinRAR or 7-Zip

and then run the file Setup.exe

😀

hi,

according to beezells answer:

if i use a sql task to create a new table in a ssis package, how can i save the name of this table to a global...

OK. I'm trying to create a SQL Agent job that runs this and it is failing. I think I'm missing something pretty basic.. Right now, the job only has one...

Hey Chad.. Great script! Thanks!! I ran into a slight problem. The Powershell script works great if all the SQL Servers are in the same or trusted domains. However,...

Hi All,

Thank you so much ... that worked by passing a null value as well to the parameter when the check box was not selected...

Thanks for your help.

Regards,

Blah baby

Yes, Carl Federl's post did the trick!

Thanks alot.

/Anonymous

It hasn't been a problem, thought I've never really been a fan of doing this. Performance was the main drive behind this. Obviously we're not going to be doing it...

Yep I realy would, anyone have any thoughts?

Thanks