Viewing 15 posts - 5,416 through 5,430 (of 7,164 total)
Please post the query you're trying. Obfuscate names as needed.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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,...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 19, 2011 at 5:42 pm
Please post back when you find out...I am always interested in these neat little oddities 😀
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 19, 2011 at 5:18 pm
cfradenburg (7/19/2011)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 19, 2011 at 4:12 pm
LutzM (7/16/2011)
You could also replace UNION with UNION ALL since due to the different values for s.objecttype in each UNION statement there isn't any need to check for duplicates.
+1000
Switching...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 19, 2011 at 2:31 pm
What is migration_db? Is this a one-time migration? You have a design or a data issue or both if your regularly matching a nullable column to another and always treating...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 19, 2011 at 2:25 pm
Viewing 15 posts - 5,416 through 5,430 (of 7,164 total)