I built a partitioned table by generating a persisted column which generates the least significant digit of the user's User_ID identity column.

Alas! We didn't get the performance improvements we...

Geez Steve, I'm a rookie here so I don't get to contribute very often, but I always find helpful information when I visit here and am looking for something. ...

Hey Sandy.

I'm not the "expert" that you seek, but I can offer a couple of thoughts.

I prefer to write as much of my stuff in Stored Procedures which I then...

Yikes! I always reluctant to post code up here Jeff because I'm such a neophyte when it comes to the inner workings of SQL Server, but I'll paste it...

A thousand "Thank you's to you Barry!"

I had searched BOL using various combinations of Stored Procedures and multiple result sets etc to no avail. Your advice had me look...

Many thanks again Richard.

The ExecuteNonQuery() call was already present, but I restructured the loop a bit so that it only initialized the OracleConnection object once before entering the foreach( )...

Wow!

Thanks a bunch Richard! Let me tear back into my code and see what I have it doing now. I think I figured out the ExecuteNonQuery() piece, but...

Oops! I forgot to explain that the TLog_Store_Summary table currently contains hourly data, so in order to summarize it with a view into a set of "daily" numbers by...

Wow! Thanks for the rapid replies Matt and Jason!

I continued playing around with T-SQL code until I discovered that the SUM( ) function will allow me to SUM multiple...

Roy,

The quickest/easiest/simplest way to do it is to perform a SELECT INTO in a stored procedure that you can easily execute on the fly or execute it from the Scheduler...

Hey Terry!

Aside from a small syntax change, I think what you wrote might work!

Set oNewPkg = CreateObject("DTS.Package")

oNewPkg.LoadFromSQLServer "SXADISCOVERY", "", "", "256",,,,"LKruseTestPkg2"

 sTmp = ""

 sFilePath = oNewPkg.GlobalVariables("gv_FileName")

 For...

Hey Terry!  Thanks again for the info. 

I've sent you a PM to clarify what I'm trying to do.

No, I don't think you are wrong Lee, I think that there might be more variables involved however.

I have a package with 1 single SQL Source.  I have 20 destination...

I tried to implement the suggestions made by Terry, but I can't get it to work like I need it.

here's the set-up for it:

I have an existing package which contains...

Dan,

In my reference, it looks like there are multiple methods available to save the package programatically.  Have you tried using those to persist those values?