Ok... here's what our DBA's do (I don't like it and can think of at least one way to automate)... they do a "WinGrep" on the SQL Server log looking for...

When the hell did DTS come into the picture?  And why are you using that pig, Lucky?

Serqiy, I'm sorry you're sitting within shooting range of an ID-Ten-T

Sameer,

You all set with the brute force method I gave you or do you need something more sophisticated?  If the latter, I need some more details to help...

That's why I was going on about the ISO standards... they were supposed to be a key in developing the ISO standards for SQL and Data.  Guess they forgot everything...

Sorry... dropped the ball on this one... I'll try to remember this one when I get to work.

Just for fun, lemme share what I recently heard in the hallway from...

Lucky,

In the example you gave (yeah, I know... just an example but this is really important), you dropped the 4th parameter (Are) from the 2nd line.  How many CSV parameters...

Serqiy, my old friend... I'm sometimes amazed at the things people do that will either violate the security of the server, violate the integrity of the data, or just absolutely...

Try the corrections I made to the BCP first (my last post)... and since you must be running this as an "SA" user to even use the xp_CmdShell, the -T...

It's already been done... in QA, open the object browser (press the {f8} key), drill down to the table of choice, right click on the table and select [Script Object...

Are you saying that you want to pass a CSV variable (ie. 'col1,col3,col5') to a stored procedure and have it return a result set with col1, col3, and col5 in...

Hmmm.... the code is NOT exactly the same... you added .Txt to the file name and messed up on some spacing (ie. BCP SET came out as BCPSET in your...

DOD eh?  Haven't they heard of ISO standards for data?  Sheesh!  Where's Joe Celko when you need a good rant from him?   ...

Thanks Mita... I learn something new everytime I do something like this, so thanks for posting the problem.

Lemme know how long it takes to do the 14 million rows... I'm...

I'll try running the code you posted back when I get home from work, tonight.  Looks identical... dunno by more than casual glance why you are getting the BCP error...

I never ask that question because the answer is usually something that raises my hackles

It's usually ok for Developers to have read...