Forum Replies Created

Viewing 15 posts - 9,331 through 9,345 (of 13,874 total)

  • RE: SSIS Task to Tell if Any Files Exist in Any Subfolder Within a Root Folder?

    brad.mccollum (4/3/2014)


    None at all of the examples I am finding actually work once I implement and modify the code for my particular situation. It only seems to loop through the...

  • RE: source code control for dtsx

    Have a look here.

    We don't use SSISDB in dev, just everything after dev.

  • RE: importing to SQL Server from .txt

    Without actually looking at the bothersome data, I'm running out of ideas on this one. It sounds like you should be able to narrow down roughly where the problem lies...

  • RE: source code control for dtsx

    Eric Mamet (4/2/2014)


    We include connection manager files and project parameter files. Apart from that, you are on the right track with solution, project, .dtsx

    Phil,

    In previous versions, I found...

  • RE: Nesting xml

    lmnorms (4/3/2014)


    Thank you. Adding in:

    Select '<?xml version="1.0"?>' + Cast((

    [Original Select

    ]

    ) AS VARCHAR(MAX)) as XMLData

    Worked nicely....

  • RE: Nesting xml

    You mention SS2012 in your post, yet this is a 2005 forum, which is a bit confusing.

    If you could post some source data in readily consumable format (see the link...

  • RE: SSIS 2012 Environment Variables and Source Control

    Koen Verbeeck (3/31/2014)


    Phil Parkin (3/31/2014)


    So at the moment, I think that scripting out the variables would provide only a reference, not something that can be executed.

    Apologies - I should...

  • RE: SSIS 2012 Environment Variables and Source Control

    So at the moment, I think that scripting out the variables would provide only a reference, not something that can be executed.

    Apologies - I should have mentioned that this...

  • RE: SSIS 2012 Environment Variables and Source Control

    Koen Verbeeck (3/31/2014)


    happycat59 (3/30/2014)


    Environment variables are actually stored in the registry. So, exporting them using something like "regedt32" will give you a ".reg" file that you can save into...

  • RE: Store a Value in a Variable

    sandeep.patel1 (3/28/2014)


    hi Phil Parkin,

    Can you please write the script code for doing this.

    --

    No.

    Please do some research and at least try to make it work for yourself, then post back with...

  • RE: Store a Value in a Variable

    If you are writing the value to a table somewhere, you can issue an ExecuteSQL query immediately after the data flow to retrieve it and assign it to an SSIS...

  • RE: escape single quote in a column

    Eirikur Eiriksson (3/26/2014)


    My 2 cent;

    An apostrophe is a valid character in a surname so that should be catered for.

    I agree - if you remove these, you are changing people's names.

  • RE: Type Mismatch on Excel Input

    dan-572483 (3/25/2014)


    The Excel file contains data going back several years and I'm only looking for data entered in the past few weeks. (Honestly it is a personal...

  • RE: SSIS sqlserver configuration

    Why are they being taken off-line?

  • RE: Purpose of CDC

    dan-572483 (3/21/2014)


    Good point. As I read more I see that CDC can also be configured to track and capture multiple changed to the same rows between SSIS job runs....

Viewing 15 posts - 9,331 through 9,345 (of 13,874 total)