The error occurs when you run the script for packages not of 2012 version. Please can you migrate your packages...

pchelptx (12/4/2015)

---

I managed to have the script load the DB with data in the "pkgStats" table. But when running the rest of the script there is no data in the...

The XML code behind of SSIS pkg slightly differs in 2008. I have...

Can you send me one package?

This should work. Can you please check if the package xml is...

bteague (11/25/2015)

---

Thanks. I received messages indicating issues with the variable and constraint sections (below). Also, it didn't appear to find any of the scripts in our packages.

...

------------------------Get all variable details-------------------------------------

Msg...

bteague (11/24/2015)

---

Testing now. Admittedly, I'm just executing this to see how the results look after one pass. How are subsequent executions managed? Do you have to DELETE rows from the...

corey lawson (9/1/2015)

---

Hmm... not too hard to do a small bit of googling (or better, searching on sqlservercentral.com) for how to ingest an XML file into a xml variable using...

Misha_SQL (9/2/2015)

---

Great work, thank you! One suggestion: it doesn't seem to play well in cases when there are complex multi-line expressions used for various properties. Maybe convert CR/LF...

Phil Parkin (9/1/2015)

---

Good work.

I have only skimmed the article so far, but one question which came to mind relates to project-level parameters.

As these are not part of the package DTSX,...

Phil Parkin (9/1/2015)

---

Good work.

I have only skimmed the article so far, but one question which came to mind relates to project-level parameters.

As these are not part of the package DTSX,...

Thanks for liking..hope it helps you.

Andy, I have used BIML in one of my project to create a package dynamically. The script created was using xquery of sql server to generate Biml code by fetching...

If your sp parameter name is always same as the table column named, the query below can be helpful.

select o.name,p.name as paraname,p.max_length as paralength, t.max_length, OBJECT_DEFINITION(o.object_id) Spdef

from sys.objects o

join...

kapil_kk (6/30/2014)

---

Hi all,

I have a scenario in which I need to capture count of rows returned by execution of stored procedure.

I new we can do it declaring OUTPUT parameter to...