Please reply

Thanks a lot guys !!!

the use of the database for that connection string works, this is successfully retrieved from SQL server, but the challenge is retrieving the parameters for the OLE DB source connection.....

I...

Thanks for the replies,

What I have done so far is :

1. I have created 2 tables with relationship, one is describing what the package does and the other...

thanks for your reply...I am looking at keeping my parameters in SQL server....and retrieving them from there..... when i need them.... to solve the configuration files from going back to...

I want to use this as a script task to ensure clsuter to machine name are in sync

Can u show steps on how to do

thanks

I have worked on the package like u saod

placed it in a container.....

I guess I am still on the wrong road ...

Can u be kind enough to guide me...

Thanks for your reply ..

Should i give the script task a pre-execute event handler....

Can u help out with steps please...

Thanks

yes just one server not on any other server ...

trying to create a template for my org's development team

thks

Thanks a lot

that has been helpful , I have been working in a medium scale industry, so want to get myself prepped up for the real action soon..

regards

Thanks a lot .........

I guess SQL profiler and the DB tuning advisor are my best bets .... what types of common performance bottlenecks should i look out for in...