You could use a script transformation without a ForEach Loop container - i.e.

Option Strict Off

Imports System

Imports System.Data

Imports System.Math

Imports System.IO

Imports Microsoft.SqlServer.Dts.Runtime

Public Class ScriptMain

Public Sub Main()

...

You could always iterate through your timesheet table at COB and update the records accordingly, i.e.

UPDATE MyTimeSheetTable WITH(ROWLOCK)

SET ClockOut = 1, MyDateColumn = CAST((CONVERT(varchar(10),getdate(),101) + ' 16:00:01') as datetime)

FROM MyTimeSheetTable

WHERE...

Sounds like a good candidate for SSIS. You can empower HR/Managment to update the text file, etc. and use a package to pull in the contents of the text file...

MS has a whitepaper that goes into great detail - good luck 🙂

http://www.microsoft.com/downloads/details.aspx?familyid=3F0F2A3F-DFF9-49CD-8EA7-581AA7A303A4&displaylang=en

Yes. The alternative would be to create an SSIS package for maintenance operations in BIDS and use a script task to delete files, i.e.

Imports System.Data

Imports System.Math

Imports System.IO

Imports Microsoft.SqlServer.Dts.Runtime

Public Class ScriptMain

...

You should be good to go. You will likely want to rename the server after demoting it. In this case, just use a sp_dropserver, sp_addserver to change the name in...

Appears to be an issue with the WYSWYG editor in SSC. I've sent an e-mail to Steve Jones to see if I can get a link on the page to...

Just FYI, Steve was kind enough to put up a link to download the file "Who.txt". Save this file as "Who.rdl"

Thanks.

Just FYI, I've been working with Steve offline on the WYSWYG editor. If you take the code from SSC site and run into the error on line 1036. Perform the...

After working w/ several of you offline, it appears as though the WYSWYG editor might be the culprit. I'm working with Steve to see if this might be the case...

CodePlex now maintains the AdventureWorks sample databases (www.codeplex.com)

Just FYI, I've also posted a newer version with support for an AutoRefresh interval (90 seconds default) and without my e-mail address on the bottom. If want a copy before...

Thanks for the feedback. Please try the following and let me know if this resolves your issue.

1) Launch MS VSS or BIDS. Select File -> New -> File

2)...

You could take this VBS script below and rewrite into .NET (shouldn't be too difficult),

put into a SSIS script task (use some variables). If your new to SSIS, just Google

"Script...

Use regular expressions within CLR. Here is a link to a blog with a specific example (validating an e-mail address even :))

http://blogs.mscommunity.net/blogs/tkralj/default.aspx