Heh... unpaid overtime this weekend for me...

I suppose I spoke a bit out of turn by calling DTS a pig... it's great for stringing processes together, provides it's own "flow chart" in the process of doing...

The common meaning of "Ninja" is that above a black belt in whatever art is being practiced. In truth, Ninja's were professional assassins who were very good at what...

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...