September 16, 2010 at 1:41 pm
jcrawf02 (9/16/2010)
Just to make it interesting 😛 my DBAs have deigned not to grant BULK INSERT, so swell though your solution seems to be Wayne, it no workey.In light of that roadblock, I'm still working on it in SSIS.
You can still do it with SSIS although I believe your DBA's have become GUI-centric and a bit fearful ;-). The key is to get the file. It's just not as easy in SSIS as it is in T-SQL.
As a side bar, I understand some of the FUD about Bulk Insert privs. It seems that too many DBA's have taken the easy way out. My previous System DBA was great. She used to say, "Jeff, you figure out how to make it work well and I'll figure out how to make it work securely." The world needs more DBA's like her. You know... the ones that can actually do their job? 😛
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing post 16 (of 15 total)
You must be logged in to reply to this topic. Login to reply