January 20, 2015 at 1:27 am
I have a bunch of packages in msdb. Is there any easier way to move those packages from msdb to DataTools/BIDS, instead of adding one package at a time using ADD option.
January 20, 2015 at 1:33 am
You can use dtutil to copy multiple packages from SQL to file system. Here is an example of moving them around which I'm sure you can modify to meet your needs: http://www.databasejournal.com/features/mssql/article.php/3734096/Using-dtutil-to-copy-SSIS-packages-stored-in-SQL-Server.htm
January 20, 2015 at 1:44 am
Thanks a lot for the quick reply. Yes, I can use DTUTIL to export to folder. Then, from there, should i have to add each pkg, one at a time in a SSIS project (BIDS/Data tools).
January 20, 2015 at 2:04 am
balasach82 (1/20/2015)
Thanks a lot for the quick reply. Yes, I can use DTUTIL to export to folder. Then, from there, should i have to add each pkg, one at a time in a SSIS project (BIDS/Data tools).
That is correct.
You might want to try to edit the XML of the project file directly. Maybe copy pasting is faster than adding packages one by one.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 20, 2015 at 2:38 am
Thanks again. I will use the copy option instead of ADD.
Furthermore, a rather dumb question. I cant find SSDT in a windows 2012 server. Since there is no start button, how to open SSDT. It is installed. I cant find it in the search window.
January 20, 2015 at 2:40 am
Try typing SQL in the search of the start and see what pops up.
It's pretty annoying when you have multiple SQL versions and you need to find out which Management Studio you need to open.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 20, 2015 at 2:43 am
Yes, I tried that. It lists all, but not data tools. I tried the same in another windows 2012 server and it lists there.
I am not clear why its not displaying in search. Is there any other way or shortcut to open SSDT. I have to add the packages and edit them.
January 20, 2015 at 2:45 am
On my system, SSDT is located here:
"C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\devenv.exe"
I would just add a shortcut on the desktop and pin it to the taskbar.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 20, 2015 at 2:54 am
Yes :-). Obviously the final option is that.
Now, I am wondering if SSDT was installed. I checked and IS service is running.
January 20, 2015 at 2:55 am
balasach82 (1/20/2015)
Yes :-). Obviously the final option is that.Now, I am wondering if SSDT was installed. I checked and IS service is running.
Installing Integration Services does not install SSDT.
You explicitly need to include it in the set-up.
(and in SQL 2014, it is a seperate download)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 20, 2015 at 2:56 am
January 20, 2015 at 3:00 am
Install Shell ?? I wish. Its prod, i cant install anything 🙁
I will check and install SSDT.
Thanks all
January 20, 2015 at 3:07 am
PB_BI (1/20/2015)
Or you could download and install Classic Shell and get your start menu back😀
That's only for quitters 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 20, 2015 at 3:10 am
Koen Verbeeck (1/20/2015)
PB_BI (1/20/2015)
Or you could download and install Classic Shell and get your start menu back😀
That's only for quitters 😀
Give in to the dark side Koen 😀
To the OP - just being pedantic but if it's prod, why do you need SSDT on there? Shouldn't you be doing your development on a development server? *runs away*
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply