SSIS

Endgame Viable 8 January, 2008 at 1:30 AM 0 words

8 entries. 1,815 words.

SSIS. 2006-05-31 5:34 PM.
- Technology
- thomaskrehbiel.com
At work, I’ve been playing with SQL Server Integration Services (SSIS) for use in an upcoming project. (“Integration” is one of those fancy “enterprise” terms that means “getting information from different places and organizing it into something useful.”) There’s some value in SSIS, but overall I’m not terribly impressed. In fact, it’s a bit of a pain. 193 words.

Avoiding SSIS query timeouts. 2006-06-07 12:36 AM.
- Technology
- thomaskrehbiel.com
Just so I have a record of this: In SSIS, I was trying to pull data from a SQL Server database with a complex, slow SELECT query (written by someone else) which took a good 15 minutes to run. 90 words.

Don’t Use A Lookup Component To Find Duplicate Rows. 2006-10-19 5:30 PM.
- Technology
- thomaskrehbiel.com
Another in a series of random programming tips by Thomas Krehbiel, mostly to help me remember them in the future. 299 words.

No Redirection For Data Destination Errors?. 2007-03-16 12:07 AM.
- Technology
- thomaskrehbiel.com
I had the “opportunity” to fix someone else’s SSIS package that was failing because of a data overflow on a date column at one of the data destination components. 261 words.
Mystery Date Crisis Solved. 2007-03-16 8:59 PM.
- Technology
- thomaskrehbiel.com
To follow up on yesterday’s mystery date problem: It turned out that one of the incoming dates had been erroneously entered with the year “1007” instead of “2007.” The date was valid on the Oracle data source, and it was valid within the SSIS data flow. However, SQL Server 2000 can’t store a date prior to the year 1753, so the data destination failed. I put in a script component to test for dates earlier than 1753, set them to “1/1/1753”, and flagged the row with an error. 98 words.
The DTEXEC /DECRYPT option. 2007-03-31 9:50 PM.
- Technology
- thomaskrehbiel.com
Today’s lesson is about how to avoid those annoying messages that SSIS gives you about being unable to decrypt sensitive data in a package. 421 words.

SQL Server 2005 Migration. 2007-06-30 5:34 PM.
- Technology
- thomaskrehbiel.com
We recently completed a migration from SQL Server 2000 to SQL Server 2005 at work. Here are some of the issues I’ve had to deal with from an application perspective. 369 words.

Excel Spreadsheet Table Names. 2008-01-08 1:30 AM.
- Technology
- thomaskrehbiel.com
If you have the unfortunate need to use an Execute SQL Task SSIS component on an Excel spreadsheet, make sure you specify the worksheet name as “[Your Sheet 1$]” in the FROM clause of your SQL statement. 84 words.