Open the SSIS-Framework-Community-Edition-File\SSISFrameworkDB\SSISFrameworkDB\92-Add_packages.metadata.sql SQL script. Edit the @PackageFolder parameter path found in three locations so it matches ...

Not as XML using the SQL Server 2005 XML datatype, but as the parsed data values into a table with a column for each element.<BR><BR>The simple method would appear to be using SQL Server's SSIS ...

I have to import this XML file into database using an SSIS project that was given to me. (I did not sign up to do SSIS, and only deal with it once a month, but there's nobody else to do it ...

Here's a quick trick to keep things running. By Eric Johnson 04/12/2010 When building an SSIS package, you probably find that a lot of the time you don't want one bad row to blow up the whole ETL.