In SQL Server 2005/2008 you should be using varchar/nvarchar(max) not TEXT/NTEXT.

Basically you "have more than" 8060 bytes on the row because SQL Server does not store TEXT data in the...

Start with BOL (Books on Line) and see if you can find a SQL Administration class somewhere nearby and get in it.

Yousaf Khan (12/30/2008)

---

Hi Lorenzo Ascione

...

Does this mean you don't need any of the...

I won this time Gail.

Do you want only rows that match one of the dates exactly or rows with dates between the 2 dates?

You can modify the code I provided in my previous post...

This is basically a duplicate post. Please place answers in this thread, http://www.sqlservercentral.com/Forums/Topic627035-146-1.aspx.

If you are testing the Linked Server it is attempting to connect using your security Principal, not NT AUTHORITY\SYSTEM. So you either need to add your local login to...

One thing that is inconsistent in your question is that you have defined Cat1_ID and Cat2_ID as int in your table definition and then show character values in the example...

Jeff Moden (12/30/2008)

---

I was also looking at today's article on SSIS and what I think is a fairly simple import...

http://www.sqlservercentral.com/articles/SSIS/64766/

All I can say is "Good Grief"... it took this person...

You actually have 3 options to do this:

1. Use your Lookup and Conditional Split and use an Ole DB Command Task to do the updates. You would need...

Jeff Moden (12/29/2008)

---

Ok... I thought that things like DTS and SSIS were supposed to make things simple for people to do things in a database... I'm seeing more and more...

Jay Sapani (12/29/2008)

---

Thank You Guys For The Info But I Wanted 1 More Thing

Select * From OpenRowset('MSADSQL','Driver={Microsoft dBase Driver (*.dbf)};SourceType=dbf','Select * From C:\MyApp\MyTest.Dbf')

The Command Runs Perfect

But

Select * From OpenRowset('MSADSQL','Driver={Microsoft dBase...

It sounds like there has been some change to printer settings and that the problem is on the .NET side and not the Reporting Services side, since the report is...

I don't see a way to get that information passed along within the SSIS process. You may need to use a script component and set a variable with the...