SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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…

Read more

0 comments, 1,493 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,…

Read more

14 comments, 30,751 reads

Posted in Devin Knight on 2 March 2009