Package Configuration

Question

Package Configuration

sabarichandru

SSCommitted

Points: 1704
More actions
August 31, 2010 at 10:29 am

#387705

Hi,
i have created package configurations using Sql Server options and stored the source and Destination connection string informations in table.
but now requirement is i need to capture those connection string values from table with help of variable and pass it to the package .
can anybody guide me how to acheive this .
i never used variables in my project thats the reason i dono how to capture the connection string in the variable and pass it to the packages.
anybody explain it in steps so it will be thankfull to them.
its very urgent for me . today i need to accomplish this task . Anybody help me to resolve this issue.
Thanks in Advance!
Sabarinathan

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: 102296 More actions · Answer 1

I'm not 100% sure I understand the question. As I read it, you have configured the package to use configurations, now you want it to NOT use them but you want to pass the information in?

Also how are you running the package?

CEWII

sabarichandru SSCommitted Points: 1704 More actions · Answer 2

Hi,

Thanks for your reply.

yeah i need to pass the Server name to the package instead of manually changing inside the package,

Scenario :

usually for configuring the package i will use XML config . but now my client requirement is they need to store the package information in Sql Table whenever they change the server name in the table it should refer to the package for deployment in the 'Prod Server'

Eg: suppose i developed my package in Servername'SISCHNAPP01' now i should configure this packages in Prod Server Name 'SISCHNTST01'. if i change the Name in the table as 'SISCHNTST01' it should pass this value to the package.

I Hope you understand my requirement. Pls Help me to resolve this issue!

Thanks and Regards!

Sabarinathan

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 3

Instead of passing the database name to the package, would it be acceptable to have the first step in the package read that value from the database?

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

sabarichandru SSCommitted Points: 1704 More actions · Answer 4

Hi Alvin,

I'm not passing the Database name . i'm passing the server name thats the reason i'm capturing the Connection String information in the [SSIS_Config] table . suppose if client changes the server name in the table. automatically the packages should refer to the newly changed connection string.

Because across the servers i replicated the Databases . so only thing is that i should change the server in the Config table so the package should point to the newly changed server name and it should get run smoothly .

Regards,

Sabarinathan

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 5

I think you need to take a look at the DTExec statement and look at how you can use it to pass parameters.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]