It really depends on the site and the role of the DBA in the organisation. Is the DBA supporting production, development or both. If the DBA is supporting development then...

In the .bas files, look for the line

goPackage.Execute

Just before this line is a commented out line to save the package to the server. Uncomment the save line and comment...

You're correct you will need to use dynamic sql to provide the column name.

One other thing to consider, instead of outputting to an XLS file, output the data to a...

Take a look at mssqlXpress. It handles version control for all objects in the database, not just stored procedures.

http://www.mssqlxpress.com/

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface...

Take a look at the rowset return parameter in the ExecuteSQL task.

You can execute an SQL statement to return a list of countries and then assign that to a global...

To make it more manageable, break your package up into discreet sets of tables. ie: in each package only include tables that are dependent on other tables in the package....

Using UDL files can be a security risk. If you change the extension of the UDL file to TXT, you can read the connection string in plain text. Not very...

Is the import ONE dts package, or multiple packages?

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

Are these 25 tables all being imported in one DTS package?

What is the DBMS on Server A?

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

There two things I can see that are a problem,

1) You are doing two comparissons that are effectively the same thing.

CONVERT(varchar(20), s.u_sampledt, 106) BETWEEN ('17-Sep-2003') AND ('18-Sep-2003')

AND CONVERT(datetime, CONVERT(varchar(10), s.u_sampledt,...

Can you export the data from Server A to flat files? If so, then copying the files accross to Server B and using BULK INSERT to load the data, will...

What do you want to do with the file? Can you clarify what your entire process is?

Do you want to execute the sql statements? If so, you don't need to...

Just put the set statements before your procedure call,

eg:

SET ANSI_NULLS ON

SET ANSI_WARNINGS ON

EXEC dbo.DestViewCreator ...

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

Giving the trend towards electronic publications these days, was there any thought to publish SQLserver Standard electronically? Would allow you to distribute internationally without having to iron any logistical problems...

Weird format for the date. Why not just have 2003 for the year Anyhow, here's my bash at it.

SET NOCOUNT ON



CREATE TABLE...