HI All, I am interested in getting knowledge on how to create SSIS pkg dynamically. Is it possible to guide me from where i can get some videos / study material, thanks Anky

what you mean by Dynamic? do you want to create a dynamic data flow? or you want to create a whole package dynamically? let us know what you need to do exactly and then we can help you better.http://www.rad.pasfu.com

If you have info for both, can you pls provide me both ThanksAnky

for dynamic data flow: simple answer: you can not do it simply, actually SSIS Data flow task doesn't support dynamic metadata. So this means that you should implement different data flows for different data structures. but there are workarounds, you can use ExecuteSQLTask or ScriptTask to do it dynamically with combination of variables and expressions, but not in all cases. for whole package: you can use programming, and create your package with C# or VB.NET code programmatically . this is good start point : http://msdn.microsoft.com/en-us/library/ms345167.aspxhttp://www.rad.pasfu.com