Inherited a .dtsx

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Inherited a .dtsx

Inherited a .dtsx

Rate Topic

Display Mode

Topic Options

Author

Message

jude-32296

Posted Tuesday, March 12, 2013 7:00 AM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, June 06, 2013 8:31 AM
Points: 204, Visits: 691

What is the best way to open this to see what it is doing? I am told it is executing a stored procedure & then writing to .csv file. It is running via scheduled job using exec master..xp_cmdshell (I think this may have something to do with migration & 32 bit vs 64 bit, but not sure). I do see that the scheduled job is executing & the .csv files are being populated, but how can I see this from the designer? I want to see each step in the process. Nothing I have tried to do will open it so I can see it via a design type of screen. Help? Please.

thx
jude

Post #1429767

Chris Harshman

Posted Tuesday, March 12, 2013 12:03 PM

SSCommitted

Group: General Forum Members
Last Login: Today @ 10:13 AM
Points: 1,573, Visits: 1,732

if you actually have a .dtsx file, you can work with it by doign the following:
in Visual Studio 2008 (BIDS) create a new Integration Services Project.
In the Solution Explorer, right click on SSIS Packages and select Add Existing Package. A wizard then lets you choose where it's at.

Post #1430025

jude-32296

Posted Tuesday, March 12, 2013 12:12 PM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, June 06, 2013 8:31 AM
Points: 204, Visits: 691

Thx
I was trying to use VS 2005 & when I try to create a new package it throws "object reference not set to an instance of an object"
Do I need to install VS2008 or can I do something to correct the above error?

thx
jude

Post #1430036

jude-32296

Posted Tuesday, March 12, 2013 12:39 PM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, June 06, 2013 8:31 AM
Points: 204, Visits: 691

I was able to get your suggestion to work on VS2005 on a different box.... THANX!!!!
jude

Post #1430052

Chris Harshman

Posted Tuesday, March 12, 2013 2:58 PM

SSCommitted

Group: General Forum Members
Last Login: Today @ 10:13 AM
Points: 1,573, Visits: 1,732

oops, sorry for the version confusion, forgot I was answering a question in SQL Server 2005 forum

Post #1430114

« Prev Topic | Next Topic »

Permissions