SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


MOVE SSIS PACKAGES from Development to Production server...


MOVE SSIS PACKAGES from Development to Production server...

Author
Message
sql_freak
sql_freak
Valued Member
Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)

Group: General Forum Members
Points: 55 Visits: 100
Hi Guys

I am new to SSIS

Current situation in company

They have SSIS packages which are already been deployed in production server, But 2day we found one package in that to be edited and i edited and now the package works perfect in the development environment..

My concern is how could I replace or deploy my new SSIS package in production server
without deploying all SSIS packages in the project/solution that have been deployed already to Server?

And also the Production is in remote location... plzz help...
Baskar B.V
Baskar B.V
Old Hand
Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)

Group: General Forum Members
Points: 311 Visits: 341
sql_freak (8/11/2010)
Hi Guys

I am new to SSIS

Current situation in company

They have SSIS packages which are already been deployed in production server, But 2day we found one package in that to be edited and i edited and now the package works perfect in the development environment..

My concern is how could I replace or deploy my new SSIS package in production server
without deploying all SSIS packages in the project/solution that have been deployed already to Server?

And also the Production is in remote location... plzz help...


How the SSIS packages were deployed in production? Are they stored in some network folder?
In that you can just overwrite the existing package which you have modified with the newer version.

BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.

sql_freak
sql_freak
Valued Member
Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)

Group: General Forum Members
Points: 55 Visits: 100
Thanks alot bhaskar.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search