Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kirknew2SQL
Posting Yak Master
194 Posts |
 Posted - 2007-12-11 : 16:44:00
|
| I used Tasks, Import Data to import a CSV file. During the process it asks if you want to save the SSIS. I did.The import was successful. T^hen I opened up the SSIS package and was going to run it. But I see no way to ececute it. How do I exeute SSIS created by wizerd? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-12-12 : 19:38:35
|
| When you open in BIDS you need to create a project and add the package to the project - then you will see the execute button enabled.Otherwise you can use dtexec.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
kirknew2SQL
Posting Yak Master
194 Posts |
Posted - 2007-12-13 : 09:30:40
|
| That got it. Thank you :) |
|
|
|
kirknew2SQL
Posting Yak Master
194 Posts |
Posted - 2007-12-13 : 11:09:38
|
| I played around with it and got it working. But I now on the start page I now have 2 solutions and 2 projects that i can't get rid of. How do you delete the solution and projects I don't want? |
|
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2007-12-13 : 14:46:11
|
| right click then remove? |
|
|
|
kirknew2SQL
Posting Yak Master
194 Posts |
Posted - 2007-12-13 : 15:08:33
|
| Right click on what? All i see is the start page with the recent projects box listing projects. when i right click on those nothing happens. |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2007-12-13 : 17:06:33
|
| Solution Explorer, there you have your solution/project and all the DTS packages under your solution. |
|
|
|
kirknew2SQL
Posting Yak Master
194 Posts |
Posted - 2007-12-13 : 17:23:48
|
| in recent projects there are two icons for the pr0jects i created. I want to remove the one oi made called "test". One is light blue the other has color in it. I click on the one with color and then open the solution explorer. At the top i see Solution Explorer - TESTI ritht click on the TEST at the top of the tree. the pop up has selections for build, rebuild, clean... but there is no Delete. There is a cut option. when i click on that nothing happens.Where should i be looking? |
|
|
|
|
|
|
How do I exeute SSIS created by wizerd