Browse by Tags

• column names
• Custom Task
• DTS
• flat files
• foreach ADO Enumerator
• metadata
• programming
• remote
• Sql
• sql server
• Sql Server 2008 Launch
• SSIS Custom Task
• SSRS
• text qualifiers
• vb
• vb.net
• visual studio

• SSIS For Each ADO Enumerator Loop

  SSIS For Each ADO Enumerator Loop If you need an SSIS package to run an execute SQL task with a where clause and you need to have a parameter in the where clause traverse through a list of values in a table. In this example we will find the types of Customers... Posted Dec 19 2008, 12:09 PM by Mike Davis with | with no comments Filed under: ssis, integrated services, sql server, SSRS, Sql, foreach ADO Enumerator

• 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

• 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