see other post

Steve Jones

steve@dkranch.net

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_impt_bcp_9yat.asp

Steve Jones

steve@dkranch.net

If you are querying through ADO, you can use sp_help 'procedurename' and see the 2nd recordset for the parameters.

Steve Jones

steve@dkranch.net

It be complex, but you can do it.

Here's a start:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtsprog/dtspapps_2e5f.asp

This gets you setup in VB. From there, you could have to create each part of the package, connections, tasks,...

Those are so crappy error descriptions. Not much better on technet, but you could try there.

Steve Jones

steve@dkranch.net

Thanks.

Steve Jones

steve@dkranch.net

There are some differences in the way the languages compile (they generate different ILS). However, you don't need to learn them. If a C# app runs faster than a VB/NET...

AFAIK, the only DTS competitors are expensive tools from 3rd party vendors. That was one of the big hits with DTS.

Steve Jones

steve@dkranch.net

I like Andy's method. In the past, when I haven't wanted to keep the same name, I have used BCP out/in which worked amazingly well (used scripts).

My method has usually...

Thanks for the followup. Was this an instance? Is this a startup parameter? Where was -s used?

Steve Jones

steve@dkranch.net

I too have small dbs, so I don't bother, but I worked with a company that had a heavy OLTP load. As a result, they wanted log backups often,...

I'd use the dyanmic properties task to generate a file name from a SQL statemetn and assign that to the text connection.

Steve Jones

steve@dkranch.net

I'd split this, or perhaps change the transaction size. You likely have some data issue somewhere that is not getting handled well.

Steve Jones

steve@dkranch.net

Never seen this, but we tend to make these mods when everyone is locked out. We also script do that the changes occur in a minimal amount of time.

Steve Jones

steve@dkranch.net

Never seen this, but we tend to make these mods when everyone is locked out. We also script do that the changes occur in a minimal amount of time.

Steve Jones

steve@dkranch.net