Why not use SSIS?

I saw an example where this issue is related to alias and I also believe that I saw an issue with the columns not in the schema.

Having the DDL would...

chukostar (7/21/2011)

---

hmm... I have both 2005 & 2008 SSMS installed in my Win7 PC, also installed both BC & DTS designer. How can you tell which instance it applied...

radb4u (7/21/2011)

---

Thank you for the reply. I have declared a package variable User::TableName which holds the tablename created from GUID (ex: tbl4e0dfc2c8389488ca2d050c202233871). It is runtime so we don't know each...

chukostar (7/21/2011)

---

sorry, I think I put it in a wrong way... shouldn't call it error message.

In 2008 SSMS, I go under 'Management', then 'Legacy', expand 'Data Transformation Services', all DTS...

:hehe:

gopalchalla (7/21/2011)

---

I am getting the below error.

The multi-part identifier "sep5.V_ALERTS.VIRUSNAME_IDX" could not be bound.

Msg 4104, Level 16, State 1, Line 8

The multi-part identifier "sep5.V_ALERTS.COMPUTER_IDX" could not be bound.

Msg 207,...

radb4u (7/21/2011)

---

I have a package variable which consists of the table name (created from GUID provided). In my script component I have to insert values into this table. As i...

chukostar (7/21/2011)

---

np... just so frustrated, DTS was working w/ 2008 before my system crashed yesterday. That's why I have to reinstall and redo everything... I remember I had the same...

So do you just need to...

gopalchalla (7/21/2011)

---

I am executing the below query, it is coming up with SQL inbound error. Can SQL gurus please help, what is wrong in this query

SELECT ...

chukostar (7/21/2011)

---

it's the same message:

SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special Web download, "SQL Server 2000 DTS Designer Components" to use this...

chukostar (7/21/2011)

---

Tried everything, still getting the same 'SQL Server 200 DTS Components...' error message with 2008 SSMS. I have both 2005 & 2008 SSMS installed in my WIN7 Prof., BC...

I would start Goggling in Advance on some of the tools on the market.

Look at their reviews, compare their features, consider cost, etc

The more informed you are as a consumer...

It appears that the master database may be corrupt and you need to rebuild it.

Error 823 usually indicates a disk problem.

http://www.julian-kuiters.id.au/article.php/sql2000-rebuild-restore-master-db