Pages

Thursday, December 24, 2009

sp_help or describe a table structure

Describe temporary table:
tempdb..sp_help #monitor

Describe permenant table
sp_help db_jobs


Some of the stored procs are quite long and all of the code is not contained in the syscomments text column. The sp_helptext proc returns all the lines for a stored proc no matter how long it might be.
EXEC sp_helptext 'dbo.proc1';

Tuesday, December 22, 2009

SSIS

Start by running Microsoft Visual Studio on the server.
If you have issues importing an SSIS package or connecting via Integration Services to a Server,
then the service is not working.
- either start the service (SQL Server Integration Services)
- and check, if the instance is not the default instance for the box, it needs to be set up.


- Modify MsDtsSrvr.ini.xml
Should be in D:\Program Files\Microsoft SQL Server\90\DTS\Binn\
Replace .
with VirtualServername\instancename
- stop and restart the SSIS service


Excel and SSIS
SSIS export to excel works currently only in windows 32 bit environment. An excel file can only be created/copied from another excel template and not from scratch.