in

SQL Server Community Blogs

Voices of the SQL Server Community
All Tags » script (RSS)

Browse by Tags

  • Script out Procedures and Functions - Part 2

    Part 1 uses information_Schema.routines view and this is based on sp_helptext declare @sps table ( texts varchar ( 8000 )) insert into @sps select 'sp_helptext ''' + name + '''' from sysobjects where xtype in ( 'p' , 'fn' ) order by xtype , name create table scripts ( sps varchar ( 8000 )) declare @texts...
    Posted to Madhivanan (Weblog) by Madhivanan on 12-13-2007

  • HTTP Authenticatoin Download of File in SSIS to XML file

    Recently I posted a script that allows you to download a CSV file to SSIS through HTTP Authentication, today, I'm posting a slightly different script that uses some XML references in order to download an XML file. You can probably use the other way that I wrote for the CSV file, but since I had both...
    Posted to greenmtnsun (Weblog) by greenmtnsun on 09-07-2007

  • HTTP Authenticatoin Download of File in SSIS to CSV file

    I recently needed to perform a download of a CSV file with HTTP Authentication in SSIS to a CSV file. Its possible, but I needed a script to do it. I couldn't use an HTTP connection because nothing in SSIS would consume it. Nothing, including the File System, WMI and execute process tasks would work...
    Posted to greenmtnsun (Weblog) by greenmtnsun on 09-06-2007

  • Generate SQL Script

    --This procedure will generate the structure of the table Create Procedure GenerateScript ( @tableName varchar(100)) as If exists (Select * from Information_Schema.COLUMNS where Table_Name= @tableName) Begin declare @sql varchar(8000) declare @table varchar(100) declare @cols table (datatype varchar...
    Posted to Madhivanan (Weblog) by Madhivanan on 08-27-2007

  • Scripts Stored Procedures and Functions through query

    This query will script the Procedures and Functions All you have to do is replace DBname by the actual Database Name exec master..xp_cmdshell 'bcp "Select routine_definition from DBname.information_Schema.routines order by routine_name" queryout "C:\scripts.sql" -c' After it runs successfully, the file...
    Posted to Madhivanan (Weblog) by Madhivanan on 08-27-2007

  • VSTA SSIS c# Script

    Posted to Blog Images (Gallery) by simonsabin on 06-04-2007
Page 1 of 1 (6 items)
Powered by Community Server (Commercial Edition), by Telligent Systems