This is what I do. I backup the prod dbase. Use a VB Script to move the backup. Then I restore on the Dev end. You can even zip up...

Defintely Check the SCRIPTS page. There are a lot of good examples in there. -jG

-JG

Are you simply wanting to copy the table structure over, Then import data? If so,

You can:

Select * into <New table Name> From <Current Table> Where...

You got it going on man! I was looking into the Views but it was not showing the int or smallmoney bytes the sys table had all that.

Thanks - JG

-JG

I am looking for accros the column.

-JG

Column8, would you mind posting or sending me your DMO code used to scan for the differences of SQL2K and SQL7. I am new to DMO and I am trying...

Are you using ODBC to connect to the DBIII File? Make sure the ODBC connection resides on the SQL Server. When you execute DTS it runs off of your Client....

Is the log option only avaiable in SQL2K? I looked through the properties of the DTS on SQL7 and I can not find a Log option.

Yes, both pkg are on the same server. Here is the code:

Main = DTSTaskExecResult_Success



Dim oPkg, sServer, sPkgName

Set oPkg = CreateObject("DTS.Package")



sServer = "labsql1"

sPkgName = "Step2"





oPKG.LoadFromSQLServer sServer,...

Brian has a nice article on capacity planning

http://www.sqlservercentral.com/columnists/bknight/sizingadatabase.asp

A lot of DBA's created tables within each database that tracks specific info about the data and structure. You can then query on...

Look in BOL under the DATEADD Function.

Something like this

select dateadd(wk, 20, getdate()) 

I can not get calling another package to work.

When I call the name of the other pacakge to execute i get:

The Specified DTS Package('NAME =...

What about the syntax for the Object BulkInsertTask?

Could I do somthing similar to what you are performing with opening another package?

Would it be something like?:

Dim oTask

Set oPKG = CreateObject("DTS.BulkInsert Task")

oTask.Execute...

When I have the file collection.

If colFiles.Count > 0 ThenFor Each objFile in colFilesIf UCase(Right(objFile,4)) ".TXT" Then

What would be the proper SQL Syntax after my Then to: BCP/Insert the txt...

Steve,

They are all *.txt, and they are named sequntialy after a date i.e 01012001 (being mmddyyyy)

Through FSO I am able to place them all in a file collection. Then I...