Browse by Tags

• column names
• DTS
• flat files
• integrated services
• metadata
• programming
• remote
• sql server
• Sql Server 2008 Launch
• SSRS
• text qualifiers
• vb.net
• visual studio

• Text Qualifier in Column Names

  If you have a flat file with quotes around the data as text qualifiers you may have seen the issue where the headers has the quotes even after you put the quote in as the text qualifier. This is a simple issue to resolve. If you check the box “Columns... Posted Oct 31 2008, 08:46 AM by Mike Davis with | with no comments Filed under: ssis, integrated services, sql server, DTS, programming, visual studio, column names, metadata, flat files, text qualifiers

• 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