Eliminating Empty Output Files in SSIS
So you’ve got some packages that regularly extract data to one or more text files, but you know that from...
2009-09-30
14,019 reads
So you’ve got some packages that regularly extract data to one or more text files, but you know that from...
2009-09-30
14,019 reads
It's been well-documented through myriad blogs and forum posts about the case sensitivity of the comparisons in the SSIS lookup...
2009-09-29
2,749 reads
It had been about 5 years since I’d bought a new desktop machine for my home, and with my oldest...
2009-09-26
566 reads
A recent blog by Jack Corbett (No Training Budget Still No Excuse, followed up by SSC’s Steve Jones here) hit...
2009-09-25
1,907 reads
In this article, we'll see how you can use the Foreach loop and the Expression Language to create multiple, dynamic outputs through object reuse.
2009-09-24
13,272 reads
Today we have a guest editorial from Tim Mitchell that looks at the stereotypical geek. Have you worked with one? Is it harder to manage technical people? Or is it the job? Read Tim's thoughts and let us know if you agree.
2009-09-24
183 reads
Recently, my friend Jack Corbett asked a question on Twitter:
In a nutshell, the SSIS foreach loop will enumerate a given...
2009-09-23
3,475 reads
A recent blog by Jack Corbett (No Training Budget Still No Excuse, followed up by SSC’s Steve Jones here) hit...
2009-09-21
1,261 reads
In a couple of previous posts (Part One and Part Two), I shared some thoughts about starting a career path...
2009-09-21
1,239 reads
I’m more than 2 months into the netbook experience, and I’m happy to report that it’s still a good investment. ...
2009-09-19
612 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...
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
Comments posted to this topic are about the item An Unlimited Token Budget
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