Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

SSIS packages deployed by consultant

  
   Database Help (Home) -> DTS RSS
Next:  Dividing an integer value by a decimal one  
Author Message
Peter

External


Since: Jan 30, 2008
Posts: 40



(Msg. 1) Posted: Wed Dec 10, 2008 2:00 pm
Post subject: SSIS packages deployed by consultant
Archived from groups: microsoft>public>sqlserver>dts (more info?)
We have many SSIS Packages running in Jobs maintained through SSMS. I can
connect to Integration Services in SSMS and see the Stored Packages in MSDB,
but how do you find the .sln file for some dtsx packages so I can fix them in
BIDS VS2005? Is there a table in msdb with this information?

 >> Stay informed about: SSIS packages deployed by consultant 
Back to top
Login to vote
Gerald Aichholzer

External


Since: Jul 23, 2008
Posts: 16



(Msg. 2) Posted: Thu Dec 11, 2008 4:25 am
Post subject: Re: SSIS packages deployed by consultant [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Hello Peter,

Peter wrote:
> We have many SSIS Packages running in Jobs maintained through SSMS. I can
> connect to Integration Services in SSMS and see the Stored Packages in MSDB,
> but how do you find the .sln file for some dtsx packages so I can fix them in
> BIDS VS2005? Is there a table in msdb with this information?

as far as I know you have to export the packages to the file system,
modify them with BIDS and then reimport the modified packages. If
there's a better solution please let me know.

regards,
Gerald

 >> Stay informed about: SSIS packages deployed by consultant 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Cant locate SSIS Tutorial Packages -

how to save ssis packages before next database restoration - Hi all, I am very new to sql server 2005. So please bear with me. I created a couple ssis package through import and export wizard for our current testing database in sql management studio. Here are my questions. I will restore a full backup produtio...

How to find TSQL Code in SSIS Packages - I've got > 300 very complicated SSIS packages which execute TSQL and stored procedures. SSIS Packages are executed by jobs and some are executed manually. At various times I have issues with executing spids and need to hunt down offending code. ...

SSIS Newbie: Create new text logs when a SSIS package is run - Hi there, I was wondering if you could point me in the right direction on how I could create new csv/ txt files whenever a SSIS package is run? As far as I could understand, the SSIS have the ability to create logs, but I have noticed that it creates..

migrated DTS to SSIS package, how to run SSIS package from.. - Hi all, I am kind of new in this topic and get stuck for awhile. I migrated DTS packages from SQL Server 2000 (Windows 2000) to be SSIS packages on SQL Server 2005 (Windows 2003 Server) but don't know how to modify ASP code to run SSIS on a local..
   Database Help (Home) -> DTS All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]