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 |
|
trouble2
Constraint Violating Yak Guru
267 Posts |
 Posted - 2008-01-16 : 03:56:45
|
| In SQL Enterprise manager (SQL 2000) I could easily use DTS.I can't seem to find it in 2005.I saw this link which described I had to use BI Development Studio, but when I opened it, I saw no DTS project.is there anyone who can give me a hint.The secret to creativity is knowing how to hide your sources. (Einstein) |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-16 : 04:00:25
|
| you dont have DTS in SQL 2005. Look for Integration services Project in BI studio. |
 |
|
|
trouble2
Constraint Violating Yak Guru
267 Posts |
Posted - 2008-01-16 : 04:02:23
|
| Thanks, i'll try thatThe secret to creativity is knowing how to hide your sources. (Einstein) |
|
|
|
trouble2
Constraint Violating Yak Guru
267 Posts |
Posted - 2008-01-16 : 06:07:52
|
| Ok, I kind of got the hang of it.Now when I try to convert from access to SQL, I've got this column with empty values, and it tries to enter NULL values in SQL.I actually want it to enter empty strings.How can I do that?The secret to creativity is knowing how to hide your sources. (Einstein) |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-01-16 : 06:31:56
|
| just put two single quotesVinodEven you learn 1%, Learn it with 100% confidence. |
|
|
|
trouble2
Constraint Violating Yak Guru
267 Posts |
Posted - 2008-01-16 : 07:14:26
|
| Right, that worked, thanks....And I can't 'publish' to an external server.The secret to creativity is knowing how to hide your sources. (Einstein) |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-16 : 07:25:47
|
| publish? you mean deploy? Connect to Integration services engine on destination server and right cick select import package and give option of either SQL server or filesystem storage and select package from physical location.Add package name (it automatically selects ,change if you want). Give appropriate protection level(we use rely server roles).this will add package to either MSDB or file system folder of server. From here you can either right click and execute packages ad hocly or add a sql agent job to schedule and execute. |
|
|
|
trouble2
Constraint Violating Yak Guru
267 Posts |
Posted - 2008-01-16 : 07:29:01
|
| that would be nice, but the destination does not have integration services I think.The secret to creativity is knowing how to hide your sources. (Einstein) |
|
|
|
|
|
|
DTS