• Sure you can convert them.

    Big question - Why?

    Is it just that you need that functionality in SSIS?

    Easy thing to do would be to call the stored procedure from an execute sql task in SSIS. No need to convert them in that case.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events