Great work, Gary! If you wanted to use this as part of a GUI so that the GUI would run this procedure, then execute the generated SQL to actually CREATE...

Here is a package that took 10 seconds to create using the wizard; I then converted it to VB, which is one way for you to accomplish what you want....

Cool!

My apologies. The execute was OK; due to a logic error within the generator proc, @SQL1 was not populating properly, @SQL2 was not populating at all, and there was a...

This is one of the most brilliant conversations to which I've been exposed. Thanks for including it. I've never written a line of Java code but this guy's attitude is...

Whatever it takes to prevent another 9/11.... moreover, search engines are in their infancy. Eventually with 128-bit or 256-bit operating systems, advanced search algorithms and the ubiquitous brilliance of the...

Review http://www.sqldts.com/default.aspx?210 and its links

also view http://www.sqldts.com/default.aspx?298

sqldts.com rocks!

BTW I've used both. The first one gives me problems and may have to do with the way our server is configured....

For the deep-minded this is a good function, albeit incomplete.

For the rest of us it is simply awesome! Also, congratulations to the author who took the time to analyze the...

Check out these two articles. They helped me a lot. As a result, what you are trying to do, I am now doing  all the time.

 http://www.sqldts.com/default.aspx?205

http://www.databasejournal.com/features/mssql/article.php/1459181

You can probably use a stored procedure to call the package (refer to SQLDTS.com for an example on how to do this). In the SP, make call the package once...