What is Dynamic package ?

Question

What is Dynamic package ?

deepak.a

SSCertifiable

Points: 5330
More actions
September 22, 2011 at 3:35 am

#248570

Hi All,
I'm new to SSIS and just started learning SSIS, can any body tel me what is Dynamic package ? and how create the dynamic package ?
Thanks & Regards
Deepak

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 1

As someone new to SSIS I would not even THINK about dynamic packages.

A dynamic package is one created by code and then executed. This is a VERY advanced topic and with the learning curve of SSIS already being fairly high I would not be looking at this yet.

CEWII

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 2

Elliott Whitlow (9/22/2011)
As someone new to SSIS I would not even THINK about dynamic packages.
A dynamic package is one created by code and then executed. This is a VERY advanced topic and with the learning curve of SSIS already being fairly high I would not be looking at this yet.
CEWII

Can't a dynamic package just be a package that is configured through package configurations/variables/parent configurations/...?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

deepak.a SSCertifiable Points: 5330 More actions · Answer 3

Can't a dynamic package just be a package that is configured through package configurations/variables/parent configurations/...?

yes , because of this doubt i posted the question , what is dynamic package ?

Regards - Deepak

steveb. SSC-Forever Points: 46733 More actions · Answer 4

deepak.a (9/23/2011)
Can't a dynamic package just be a package that is configured through package configurations/variables/parent configurations/...?
yes , because of this doubt i posted the question , what is dynamic package ?
Regards - Deepak

It really depends on the context,

there is no offical meaning but it can range from using variables, to writing code to create the packages. Basically anything that cause the package to 'change' at run-time given a set of inputs.

I would leave it to after you have learned a bit more about the basics

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 5

Well if I misread context or meaning then I apologize. I was using the definition akin to dynamic SQL..

CEWII