SSIS
0 words.
8 entries. 1,815 words.
2006-05
-
SSIS.
2006-05-31.
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.
- Technology
2006-06
-
Avoiding SSIS query timeouts.
2006-06-07.
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.
- Technology
2006-10
-
Don’t Use A Lookup Component To Find Duplicate Rows.
2006-10-19.
Another in a series of random programming tips by Thomas Krehbiel, mostly to help me remember them in the future.
- Technology
2007-03
-
No Redirection For Data Destination Errors?.
2007-03-16.
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.
- Technology
-
Mystery Date Crisis Solved.
2007-03-16.
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.
- Technology
-
The DTEXEC /DECRYPT option.
2007-03-31.
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.
- Technology
2007-06
-
SQL Server 2005 Migration.
2007-06-30.
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.
- Technology
2008-01
-
Excel Spreadsheet Table Names.
2008-01-08.
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.
- Technology