Subscribe to this blog
Devin Knight
Devin is a BI consultant at Pragmatic Works Consulting. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services and was an author in the book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Devin has spoken at past conferences like PASS and at several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, FL, Devin is a participating member of the local users’ group (JSSUG).
Archives: March 2009
SQL Agent Job failure with FTP connection
There are hundreds of post on this topic but I just ran into this problem recently so I thought I should add one more. I created a package that sends a flat file to an FTP. The package runs fine in BIDS but when you deploy and try…
0 comments, 249 reads
Posted in Devin Knight on 4 March 2009
Cube Processing Error HY008
If you've ever had this error "OLE DB error: OLE DB or ODBC error: Operation canceled; HY008." appear while processing your cube you may be a little confused. Here were some of my frustrations with it:
-
First, this error doesn't really give you a single place to start looking.
-
Second,…
10 comments, 3,605 reads
Posted in Devin Knight on 2 March 2009