Replicate NetSuite Data to Azure SQL (SSIS in Azure Data Factory)
With Azure Data Factory V2 Integration Runtimes (ADFv2 IR), you can deploy enterprise replication tasks to the Azure cloud.
2020-07-17 (first published: 2019-01-02)
3,359 reads
Integration Services (SSIS_
Adding a Primary Key to a Prepopulated Table using a SQL Server Integration Services Package
In this tip we look at how you can use SSIS to build a package to add a primary key to an existing table that does not already have a primary key.
2018-12-03
2,109 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
Format Date with leading zeroes (T-SQL and VBScript)
Would someone please show me how to take a date and format it with leading zeroes. For example, 4/9/2005 and format it as 04/09/2005 (mm/dd/ccyy). I would like to know how to do this using T-SQL and ActiveXScript.Thanks in advance, Kevin
2005-05-06
9 reads
RE: User-Defined string Functions Transact-SQL
Igor, I'm doing a lot of work with string manipulation at the moment, and the AT and RAT functions will be certainly useful to me! Cheers!Alex
2005-05-05
RE: Need a RELIABLE table-exist test
If you truly need to use positive logic (IS NULL instead of IS NOT NULL) and you also want to check for a zero value, the NULLIF function does a nice job...IF NULLIF(OBJECT_ID('TempDB..##tablename'),0) IS NULL BEGIN yada...yada... ENDChecking for the temporary table name in SYSOBJECTS of the current database won't work because temp tables live […]
2005-04-29
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