ssis

ssis: Archiving files with VB.Net
When creating ssis packages it's a common requirement to be able to archive the processed files. Here's VB.Net code snippet, with a quick walkthrough, that does exactly that. The script uses two variables, inFiles and archiveFiles . The variable inFiles contains the folder we want to move files from, and archiveFiles is the destination. Configure your variables in BIDS like below. Add a script task to the designer. Right click the script task, choose 'Edit'

Blog Content

ssrs

ssrs Performance Optimization and Analysis
Recently, I came across a very good article on ssrs Performance Analysis by Tom Mills using a tool called Fiddler . As the homepage of this tool states, "Fiddler is a Web Debugging Proxy which logs all HTTP(S) traffic between your computer and the Internet. Fiddler allows you to inspect all HTTP(S) traffic, set breakpoints, and "fiddle" with incoming or outgoing data. Fiddler includes a powerful event-based scripting subsystem, and can be extended using any .NET language." This article de

Blog Content

mssql

Integrate Optin Script
October 15th, 2009 Integrate Optin ScriptDear Freelancer,I have an Optin Script and an Optin Template.I Need to Integrate Optin Script to Optin Template.I Attached all Files.Payment Will be escrow. Thankyou. Regards, EsperanzaTradeSimilar JobsPhp Fox Expert WantedXml To mssql Db Script NeededVideo/picture Portfolio ScriptUpload ContentTroubleshoot Vb Script PageSwoopo Penny Auction CloneSimple Website To Be BuiltScript To Merge Csv DocsScript To Merge Csv DocsScript Installation Of TrafficScr

Blog Content

mssql

Integrate Optin Script
October 15th, 2009 Integrate Optin ScriptDear Freelancer,I have an Optin Script and an Optin Template.I Need to Integrate Optin Script to Optin Template.I Attached all Files.Payment Will be escrow. Thankyou. Regards, EsperanzaTradeSimilar JobsPhp Fox Expert WantedXml To mssql Db Script NeededVideo/picture Portfolio ScriptUpload ContentTroubleshoot Vb Script PageSwoopo Penny Auction CloneSimple Website To Be BuiltScript To Merge Csv DocsScript To Merge Csv DocsScript Installation Of TrafficScr

Blog Content

ssas

SNESSUG September Meeting
We had a good night with 13 people attending. I ran unopposed for president of SNESSUG for my second, and final, term. We were graced with the prescence of Jeff Moden, MVP and on of the top posters over at SQL Server Central . He was just visiting.�He's a great guy and I was very happy for the chance to meet him in person. Jeff is going to be at the PASS Summit this year, so you too can have a chance to meet him. The presentation was on ssas and SSRS by Sunil Kadimdiwan. He did a full int

Blog Content

sql server

What Is Using The Most Space In Your Database ?
As I work on moving a large system with multiple database servers from a 27TB SAN to a single database server with about 6TB of direct attached storage (DAS), I have to worry much more about space utilization. The stakes are also a little higher, since it is much harder to add space with DAS than with a modern SAN. There are several aspects to this problem, such as how large are your data files, how full are they, and how large are your database backup files. Within a database, you need to be

Blog Content

database administration

Oracle Certification Releases Live Exam: 1Z0-053 %26ldquo;Oracle database 11g: administration�II%26rdquo;
The new %26ldquo;Oracle database 11g: administration II%26rdquo; certification exam is now live in production. This new exam (1Z0-053) is a single exam requirement for those holding the Oracle database 11g Administrator Certified Associate (OCA) to earn to Oracle Certified Professional (OCP).Candidates can register now for the live exam, which is available at Pearson VUE testing centers worldwide with immediate scoring and pass/fail status. Candidates who participated in the beta can expect to receive your beta

Blog Content