in

Pragmatic Works

Enabling your business intelligence enterprise.
All Tags » integrated services (RSS)

Browse by Tags

  • 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 namespace of the task to enter into the UITypeName...
    Posted to Mike Davis (Weblog) by Mike Davis on 12-01-2008

  • 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 names in the first data row” SSIS sets the first...
    Posted to Mike Davis (Weblog) by Mike Davis on 10-31-2008

  • 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 (5 items)
Copyright Pragmatic Works
Powered by Community Server (Non-Commercial Edition), by Telligent Systems