Viewing 15 posts - 1 through 15 (of 35 total)
As a follow on to this task which is working fine, I need to find and copy documents meeting certain crtiteria from my Windows folders. I have 30 windows...
July 14, 2015 at 10:06 am
Yes, this works - update config tables in one step then run package in next step and repeat with "go to the next step" as On Success Action until last...
July 14, 2015 at 9:47 am
Thanks all for replying.
I used Colin's code to give me what I needed and it ran on average 3 mins duration per folder of 500k files. This was before...
June 4, 2015 at 3:47 pm
Thanks Jeff
I had a feeling that you may have a non-cursor based solution! I've set it running and will feedback.
Many thanks for your help.
May 21, 2015 at 5:55 am
Awesome!
This looks really promising. I'll have a good test and feedback.
Many thanks!
May 20, 2015 at 12:07 pm
Awesome!
I would never have thought of using the XML features within SQL
I'm really grateful for this.
:-):-)
July 2, 2014 at 7:26 am
Superb - this BCP works. I will incorporate with the cursor later and report back.
Many thanks
June 26, 2014 at 11:14 am
Yes however if you have no hammer and no nails what do you do then?
Maybe I've asked the wrong questions in the correct forum or the correct questions...
June 26, 2014 at 3:56 am
OK, I see your point and I'm happy to use the cursor method to get individual outputs. My problem is that I've tried BCP within the cursor after searching this...
June 25, 2014 at 4:38 pm
Ah, many thanks however I've read that cursors aren't the most efficient way of looping through large data sets. As mentioned my routine will need to loop through over...
June 25, 2014 at 9:43 am
This is exactly what I wanted however I never expected to see the use of FOR XML in the code!
This is much appreciated. I prefer this method as I...
May 28, 2014 at 2:34 am
Remarkable! It's now working,
There were just too many selects and brackets to grasp.
I am truly grateful for your help with these queries.
😀
May 21, 2014 at 2:41 pm
Thanks mister.maggoo for advising on select 'I' as [@type],'1000000002' as [data()] for xml path('uniquereference'),type)
Apologies for changing to another set of fields however I'm now working on my live project....
May 21, 2014 at 6:04 am
Hi again
The XML version in the header isn't important for me at this time and so I'll leave it until later.
One thing I can't figure out is how to have...
May 20, 2014 at 7:23 am
Hi guys, thanks for helping me to get to this position.
I understand the stuff about the need to cast as nvarchar in order to concatenate but I don't know...
May 18, 2014 at 2:12 pm
Viewing 15 posts - 1 through 15 (of 35 total)