SSIS Child Package Location

Question

Post reply

SSIS Child Package Location

ramchaitanya.s

SSC Enthusiast

Points: 102
More actions
December 8, 2009 at 10:13 am

#137418

Hi,
I deploy my packages by SQL Server method into msdb. I have a package where I will be using some child packages. Is there a way to configure the location of the child package in msdb? I will be using different versions of the child package deployed at different folders in msdb.
General way to point to child package is to specify the path in the PackageName property. Can this be made configurable, to be taken from the config file or something else.

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

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

sabyasm SSCarpal Tunnel Points: 4324 More actions · Answer 1

[font="Comic Sans MS"]

Yes - this can be done.

Funny you asked this question - I was doing exactly similar stuff myself. Use expression to define the 'packagename' property. Use the variable you wish - which will get the value from config file..

For my case - it might be a filesystem storage or sqlserver (msdb) storage. So the 'packagename' expression is as follows:

(@[User::PackageStorage] =="FileSystem") ? NULL(DT_WSTR, 1) : @[Template::FolderPackages] +"Load_"+@[User::PkgName] +"_Feed"

Here Template::FolderPackages is the foldername as you mentioned...

[/font]

[font="Comic Sans MS"]--
Sabya[/font]

ramchaitanya.s SSC Enthusiast Points: 102 More actions · Answer 2

Hi..

This doesnt seem to work for me... I used the same expression as given by you as below

@[User::StagingPackPath] + "Load_" + "StageDataToSQL.dtsx" + "_Feed"

Can you please help me with this. I am new to SSIS, so not aware of many things.

sabyasm SSCarpal Tunnel Points: 4324 More actions · Answer 3

[font="Comic Sans MS"]

your expression doesn't look right to me.

what is your actual package name and msdb folder structure ?

[/font]

[font="Comic Sans MS"]--
Sabya[/font]

sabyasm SSCarpal Tunnel Points: 4324 More actions · Answer 4

[font="Comic Sans MS"]

@[User::StagingPackPath] + "Load_" + "StageDataToSQL.dtsx" + "_Feed"

Also the packagename doesn't right to me. Note:-

1)The extension .dtsx doesn't appear for the packages stored in msdb

2)The path appears within \

So if your working directory under msdb is : something_dev

and original package you developed was : Load_something_Feed.dtsx

The expression needs to be evaluated as: \something_dev\Load_something_Feed

Let me know how it goes...

[/font]

[font="Comic Sans MS"]--
Sabya[/font]

ramchaitanya.s SSC Enthusiast Points: 102 More actions · Answer 5

Thanks Sabya,

It did work. The .dtsx shouldnt be given, and with the prefixes and suffixes of load and feed, it was giving me invalid path, without them its working if i directly giving the path.

like \packagelocation\PackageName

Thanks for your replies.

But i have another problem, where in one specific machine I am getting error when i try to use expressions for Execute Package Task. It gives me the following error on clicking the browse button on expressions:

"The object does not support type information. This occurs when the runtime attempts the type information from an object to populate the properties collection. The object must support type information."

Also the task has some properties missing when compared with the same task on other machine. Is this some issue with the installation or something??