Browse by Tags

• column names
• Custom Task
• DTS
• integrated services
• programming
• remote
• Sql
• sql server
• Sql Server 2008 Launch
• SSIS Custom Task
• SSRS
• vb
• visual studio

• Find the Fully qualified NameSpace of SSIS DLL

  When writing a custom SSIS task the best practice is to create the UI separate from the control. This will allow the task to run faster during package execution. One of the problems people have when creating a custom SSIS task is, knowing the fully qualified... Posted Dec 01 2008, 09:38 AM by Mike Davis with | with no comments Filed under: ssis, vb.net, integrated services, sql server, programming, vb, visual studio, column names, Sql, Custom Task, SSIS Custom Task

• Sql Server 2008 Launch Jacksonville

  I will be speaking at the SQL server 2008 Launch in Jacksonville, FL. My sessions are: Converting DTS to SSIS : 11-Noon Reporting Services : 1-2pm http://www.sqlsaturday.com/eventhome.aspx?eventid=10 Join us on Friday, September 12, 2008, for a one day... Posted Sep 11 2008, 05:17 PM by Mike Davis with | with no comments Filed under: ssis, remote, vb.net, integrated services, sql server, Sql Server 2008 Launch, DTS, SSRS

• Converting a string to a time and date

  We had a customer that had time saved as a string and needed it converted to a date time field. They wanted to combine it with another date field. Here is a simple script to convert in situaions like this in an SSIS transformaion script. By the way some... Posted Sep 04 2008, 08:13 AM by Mike Davis with | with no comments Filed under: ssis, vb.net, integrated services, sql server

• Launch Remote SSIS Package Programmatically

  It can be a pain to launch an SSIS package remotely. So I developed a vb.net standalone application to remotely launch a package. It does require the host computer to have SSIS installed. This is just a beginning program. I am going to be adding other... Posted Aug 20 2008, 09:15 AM by Mike Davis with | with 1 comment(s) Filed under: ssis, remote, vb.net, integrated services, sql server