June 17, 2010 at 8:12 am
Hi,
I used the Import/Export wizard to create a package to import a flat file with fixed length fields to a SQL table. I saved the package to the file system.
Now I'd like to go back and edit the column sizes using the same type of interface I used to create it. I don't see how to do that. Import/Export wizard doesn't let you re-open a package file and continue working on it. Does it? I saw something that said to use Visual Studio, but don't see how to do it using that.
Thanks,
Dave
June 17, 2010 at 8:17 am
If you saved it to your file system you should be able to open the dtsx file with visual studio. that is assuming you are using the BIDS version that comes with the SQL install and not some other version of Visual studio.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
June 17, 2010 at 8:24 am
Well, when I try to open SQL Server BIDS from the start menu, SQL group, I get my full Visual Studio instead. I'm not sure why, but it looks like that's the problem.
June 17, 2010 at 8:26 am
you may still be able to open it you might try going to the folder in explorer and right click on the dtsx and select edit
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
June 17, 2010 at 8:31 am
Yes, right click/Edit worked. Thank you.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply