SSIS Lookup Cache Connection Manager with Excel
The lookup transform in SSIS 2008 gives you the ability to join data and eliminate non matching rows. One of...
2011-09-26
1,716 reads
The lookup transform in SSIS 2008 gives you the ability to join data and eliminate non matching rows. One of...
2011-09-26
1,716 reads
When setting up a lookup in SSIS it is usually just a basic comparison between two key fields like an...
2011-09-23
834 reads
On a forum post recently the questions was asked how to replace a cursor with an SSIS package. This can...
2011-09-22
1,393 reads
Using SSIS to load a flat file into a database is a common use of the tool. This works great...
2011-09-12
4,073 reads
The Merge Join Transform in SSIS is a great way to load a Data warehouse quickly and an easy way...
2011-09-06
12,774 reads
I am super excited to announce that there is a strong demand for the Foundation Training to be held more...
2011-09-02
564 reads
Variables and expressions help make any SSIS package dynamic and flexible. It is always a best practice to use variables...
2011-09-02
1,523 reads
Converting EBCDIC to ASCII in SSIS 2008 can seem like a daunting task. There is a lot of manual work...
2011-08-31
8,751 reads
A common request I have received over the years is to move or copy files from one directory to another...
2011-08-29
10,615 reads
The checksum function in SQL is a great way to compare two rows to see if the data matches. The...
2011-08-15
4,034 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Call Cs 08218200233 Jl. Borobudur No.I, RT.03/RW.07, Mojolangu, Kec. Lowokwaru, Kota Malang, Jawa Timur...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, true)
GO
See possible answers