March 12, 2013 at 7:00 am
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
March 12, 2013 at 12:03 pm
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.
March 12, 2013 at 12:12 pm
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
March 12, 2013 at 12:39 pm
I was able to get your suggestion to work on VS2005 on a different box.... THANX!!!!
jude
March 12, 2013 at 2:58 pm
oops, sorry for the version confusion, forgot I was answering a question in SQL Server 2005 forum
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply