Andy,

TS access to the server? HA! Like THAT will ever happen!

The paths issue is why, as a developer, I NEVER use drive letters. If you use a fully...

Error: -2147467259 (80004005);

This one drove me crazy for a while. I had a VB program that called a dts package to import an Excel spreadsheet. The error...

Custom tasks are very complex. Keep it simple and use vbScript in an activex transformation. Then all you need to do is:

Dim obj

Set obj = createobject("mydll.mycustombunk")

obj.dosomething

set obj = nothing

Be...

Andy,

I've never worked with the DTS designer in VB, but if you can open a DTS package in VB, then save it back to the server, that would be...

I've tackled this two different ways, but haven't found the exact answer you want. Here's what we've done.

To write to an Excel file, the best tool available...

Jon,

Establishing a linked server just stores your connection string information in the master..sysservers table as you have in the DTS package. The only ODBC traffic you'll see is from...

This might be usefull reading material:

INF: Understanding How the Transact-SQL KILL Command Works (Q171224)

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q171224

What doesn't work about it?

I would definitely go the job route. Set up a job to reset the table once per day. Then it's a simple matter of grabbing today's serial number from...

Sounds like there's a char(17) somewhere in the mix. Either that, or someone hexed your sql server.

A sure way to only get the first 15 characters is...

(Select COUNT(DISTINCT dbo.tblHotelReservations.HotelReservationID)

WHERE dbo.tblHotelReservations.DateCancelled IS NULL)

AS HotelResCount

I really don't know unless the length of table1.col1 is constant. If you know the length of table1.col1 was 3 for example you could:

insert into table1 (col1, col2)

select

...

You mean like this? (you'll have to convert to vbScript)

Dim fso As New Scripting.FileSystemObject

Dim f As File

Dim ts, ts2 As TextStream

Dim s As String

Set f = fso.GetFile("c:\test.txt")

Set ts = f.OpenAsTextStream(ForReading)

Set...

That's the road I was going down. You're passing LoadFromSQLServer the SQL login, not an NT login. The package is going to run under the context of IIS (whatever...

ok, so you can create the object. What does the DTS package do? Does the package need file access or rights on the network? What does strError return?

...