Uploading On-Premises Data as JSON to Azure Blob Storage using SSIS
Using Azure Feature Pack for Integration Services to access Blob storage from Azure into SSIS packages
2019-04-23 (first published: 2019-03-26)
2,109 reads
Integration Services
SSIS: Read Event viewer with WMI Data reader
Access OS event viewer and read it from a SSIS package using WMI Data reader task
2019-03-05
1,168 reads
SSIS Basics: Data cleansing using derived columns
On this article I will show you how to perform a basic data cleansing using the derived column data transformation
2018-10-30
3,480 reads
Oracle ODBC in Windows Server 2003
We've been migrating DTSs from a Windows 2000/SQL 2000 box to a Windows 2003/SQL 2000 box and have had trouble moving the connections to Oracle. We installed first Oracle 9.2 and then Oracle 8.1.7 without any change. We're able to connect via SQL Plus to each of the databases without problem, so I know everything […]
2005-05-27
5 reads
RE: Is there is any way to know number of spindles present in the HardDisk?
Hi,It's part of Hardware details ask your vendor about it. Try to find it from regeistry
2005-05-23
Another Quickie- can Remi the demi(god) help again?!
Hi guys, I've heard there is a sql command which allows you to query a whole db for a certain column name and it will tell you what tables contani that column. Ie if you search for Customer_ID, it will tell you taht Customer_Details, Customer_Address, and so on all contain thiscolumn. Thanks!Alex
2005-04-29
Blogs
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Query Store Keeps Switching Itself Off, Getting it Moving Again
I recently received a complaint that Query Store for a particular database was turned...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers