Viewing 15 posts - 5,416 through 5,430 (of 7,168 total)
I'll assume you were talking to me with the SSCrazy response since I am the only one on this thread with that designation. My nick is opc.three BTW, SSCrazy is...
July 20, 2011 at 9:19 am
Stamey, to be sure you're going to have to write all the code by hand. Define the list of objects you need to inspect (what I started to do), figure...
July 20, 2011 at 9:06 am
Please post the query you're trying. Obfuscate names as needed.
July 20, 2011 at 8:58 am
WebTechie38 (7/19/2011)
I tried putting breakpoints, but they didn't work.I read somewhere that those don't work in the script editor.
They work...but there are restrictions.
Is there supposed to be a flat file...
July 19, 2011 at 8:58 pm
WebTechie38 (7/19/2011)
Well I did look for a SSIS forum for SQL Server 2008.I may have missed it.
There isn't one. There's one for 2005 and a generic one for Integration Services...
July 19, 2011 at 8:53 pm
WebTechie38 (7/19/2011)
Hello,Thanks for the example. Unfortunately, corporate policy won't allow me to do any powershell coding.
That is why I was trying to do this in SSIS.
Thanks,
Tony
Booo... 😛 Do they...
July 19, 2011 at 8:40 pm
Jannie-186227 (7/19/2011)
while we on this 🙂
I hope I did not start anything here 🙂 My post was meant to help fellow Googlers in case they were on the hunt for...
July 19, 2011 at 8:29 pm
Gotcha, the script editor, not the expression editor.
The DTS variables collection has to be accessed using a string literal indexer, so not, there is no IntelliSense there. And yes,...
July 19, 2011 at 8:00 pm
In the epxression editor you can drag-and-drop them from the Variables pane into the expression writing area. Same deal with the Functions pane. I do not know of an IntelliSense...
July 19, 2011 at 5:58 pm
That sure is a lot of code to delete files older than n-days. Here is a one-line PowerShell command that does the work for you. You can execute the command...
July 19, 2011 at 5:54 pm
GSquared (7/19/2011)
I use SSIS for that kind of thing.
+1 on SSIS
If you must use bcp do yourself a favor and move the call into a SQL Agent CmdExec or PowerShell...
July 19, 2011 at 5:48 pm
In SSMS look in master under Programmability>Functions>System Functions>Scalar-valued Functions
Interesting one:
SELECT sys.fn_numberOf1InVarBinary(0xEF0207)
July 19, 2011 at 5:42 pm
Please post back when you find out...I am always interested in these neat little oddities 😀
July 19, 2011 at 5:34 pm
I was thinking of built-in functions...what you just described now has me thinking it was a user-defined function.
July 19, 2011 at 5:18 pm
cfradenburg (7/19/2011)
July 19, 2011 at 4:12 pm
Viewing 15 posts - 5,416 through 5,430 (of 7,168 total)