Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Inherited a .dtsx Expand / Collapse
Author
Message
Posted Tuesday, March 12, 2013 7:00 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 1, 2014 6:57 AM
Points: 204, Visits: 704
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
Posted Tuesday, March 12, 2013 12:03 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, July 25, 2014 10:03 AM
Points: 1,851, Visits: 2,010
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
Posted Tuesday, March 12, 2013 12:12 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 1, 2014 6:57 AM
Points: 204, Visits: 704
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
Posted Tuesday, March 12, 2013 12:39 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 1, 2014 6:57 AM
Points: 204, Visits: 704
I was able to get your suggestion to work on VS2005 on a different box.... THANX!!!!
jude



Post #1430052
Posted Tuesday, March 12, 2013 2:58 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, July 25, 2014 10:03 AM
Points: 1,851, Visits: 2,010
oops, sorry for the version confusion, forgot I was answering a question in SQL Server 2005 forum
Post #1430114
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse