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 |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2006-07-20 : 05:34:43
|
| Hi i've a DTS Package where i've built up a few TASK , but at this stage my over all package is getting bigger, and i'd like to split it up into 2 package, instead of doing all the work again can i rename the package hence creating a new package ? and removing the TASK connections i do not want. Will this affect the connections etc ? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-07-20 : 05:40:32
|
| You can copy the package and remove the tasks. The connections will remain but that shouldn't matter.Maybe think about putting any sql tasks into a stored proc and calling that instead.==========================================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. |
 |
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2006-07-20 : 05:45:27
|
| How would i call the Stored procedure from my DTS package ? most of my SQL Task are like see example below, I have also connections to a Access database so their is some access embedded code int he SQL Task as i've the connect linked to my access database.(SQL Connection)DELETE UK_SBS.Operator, UK_SBS.[Agent Name], UK_SBS.Team, UK_SBS.[Desp Month]FROM UK_SBSWHERE (((UK_SBS.Operator) Is Null) AND ((UK_SBS.[Agent Name]) Is Null) AND ((UK_SBS.Team) Is Null) AND ((UK_SBS.[Desp Month]) Is Null));(Access Connection)UPDATE UK_SBS SET UK_SBS.[Currency] = "GBP";(SQL Connection)UPDATE PDR_Rate INNER JOIN UK_SBS ON PDR_Rate.Currency = UK_SBS.Currency SET UK_SBS.[Cost $] = ([Cost £ ]/[Rate]); |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-07-20 : 05:49:19
|
| Can you not do all the access work first (in a single task maybe).Then do all the sql server work - I would put this in a stored proc - you can call this from an sql task just by doing an exec mysp.In fact I might consider putting these in separate packages.==========================================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. |
|
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2006-07-20 : 06:12:12
|
| Thats whay i've done with regards to the access script, i will create a SP for the SQL script and call it from a single SQL TASK do you think it would be faster than the SQL task ? |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-07-20 : 06:13:02
|
| Not much faster but a lot easier to maintain.==========================================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. |
|
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2006-07-20 : 06:37:40
|
| Thanks, i've a few job that i think i will put into SP. |
|
|
|
|
|
|
DTS Packages