If I recall correctly (and I might not), that's based on the default trace.  If...

My question is simple... how many rows per day will that normally include?

What I would like to ask here is if it is faster to perform a lot of INSERTS to repopulate tables, or if it would be better to perform...

Ah, there you are.  The forum had a probem with email notifications that they just fixed in the last 2 days and I couldn't find this thread.  I'll go back...

Just curious... I might have missed it in the now 4 pages of post but how many rows per day are you looking to do this for?

We are trying to get requirements from the development group who has just started programming.  We are creating a spreadsheet to send out to all of the dev groups...

I'm not opposed to xp_cmdshell, and was wanting the csv files to be pipe(|) delimited. These 3 files will be used in a P/S import process to SQL as...

It started with grouping records by week to see the amount of data, and once I saw that I needed it to break down by day in 8 hour...

I think the important thing is to reflect on the lessons learned and ask what we would do better with the benefit of hindsight.

... The point is these...

Heh... wow... this post sure has taken a turn.  What ever happened to "Get records by week"?

I'll add to that... look at what you're doing... You're writing T-SQL in PowerShell to do backups?  Just write a stored procedure and then you don't have to worry about...

In fairness, as I mentioned before, these files have been fine for years except for this month but yes we will have to add some more defensive checks to...

Yep, but no one using SSIS seems to like it.  Why not just use stored procedures without SSIS?

I can't help here but I have to tell you that putting passwords  into clear text is a really bad idea.  They really need to be "trusted" connections based on...

Ah, got it.  Thank you.  Heh.... yep. Been there and done that myself.