Browse by Tags

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 look at the new features of SQL Server 2008 as we...

Posted to Mike Davis (Weblog) by Mike Davis on 09-11-2008
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 of the time strings were null and some had bogus...

Posted to Mike Davis (Weblog) by Mike Davis on 09-04-2008
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 features like variables and config files. Eventually...

Posted to Mike Davis (Weblog) by Mike Davis on 08-20-2008

Page 1 of 1 (3 items)

Pragmatic Works