We did it in SQL2000 like this (you need system admin permissions):

EXEC usp_TEXTCOPY

  @SRVNAME =  'ServerName',

  @LOGIN =      'Login',

  @PASSWORD =   'password',

  @DBNAME =     'DatabaseName',

  @TBNAME =     'TableName',

  @COLNAME =    'ColumnName',

  @FILENAME =   'Full UNC starting with...

Paul, Do you have time for a quick article for this forum where you show us how you did this? Thanks.

You need to supply more information.

When you tested it, did you test it in Enterprise Manager (EM)? Or did you test it as a job? In production, are you running...

How many steps/tasks in your package? Did all the steps run? Do you have logging enabled? If not, can you enable logging, rerun the package and review the logs. Is...

I agree Georgio, thank you, Jeff.

Noel,

Sounds interesting. Can you point us to where we can see some examples, articles, posts, etc. of this? Thanks.

Aaron, Many about 8 years ago, we had a similar problem, dealing with millions of rows and couldn't get the queries to get under a second no matter how we...

Ben,

If you have the appropriate permissions on the file server, just make sure that you specify a fully qualified UNC, i.e., \\someserver\somedirectory\\somesubdirectory\myfile.txt

This is how I do it; I can use it temporarily or use it as a production audit tool. I've even used it during troubleshooting in order to follow execution....

Thanks for sharing your thoughts with the rest of us and for getting the ball rolling. It seems like a good article invites responses. We all strive to be the...

Another way:

insert Sheet1A (UW,TYP,D01,D02,D03,D04,D05,D06,D07,D08,D09,D10,D11,D12,D13,D14,D15,D16,D17,D18,D19,D20,D21,D22,D23,D24,TOT)

SELECT *

FROM  OPENROWSET ( 'MICROSOFT.JET.OLEDB.4.0',

   'EXCEL 8.0;HDR=NO;DATABASE=\\SERVERNAME\Reports\UWCounts\UWCOUNTS200608.xls',

   'SELECT * FROM  [SHEET1$]')

Superlative article! worthy of a DTS for Dummies book.

What I've seen before are MRPOLECAT type scripts which I'm too dumb to get to work.

But your scripts really helped. I have...

I've taken the way suggested by Ben Sullins. The selected count does not go into a local variable but into a global variable specified as an output parameter. In a...

I am relatively new to SSRS myself, having written only about 30 reports. I had need for similar functionality and our SSRS guru said that this could be done with SQL...

This is a great collection of solutions!