‘ Rename File from Connection Option Explicit Function Main() Dim oFSO Dim sFileName sFilename = DTSGlobalVariables.Parent.Connections(“Text File (Source)”).DataSource Set oFSO = CreateObject(“Scripting.FileSystemObject”) ‘ Check for file and return appropriate result If oFSO.FileExists(sFilename) Then ‘Main = DTSTaskExecResult_Success Main = DTSStepScriptResult_ExecuteTask Else ‘Main = DTSTaskExecResult_Failure Main = DTSStepScriptResult_DontExecuteTask End If Set oFSO = Nothing End Function
Author: Melvin
‘ Rename File from Connection Option Explicit Function Main() Dim oPkg Dim oConn Dim oFSO Dim oFile Dim sFilename Dim sFileDestination Dim sMonth Dim sDay Dim sYear Dim sHour Dim sMinute Dim sSecond ‘ Get reference to the current Package object Set oPkg = DTSGlobalVariables.Parent ‘ Get reference to the named connection Set oConn = […]
I found out today that if IE security (Tools-> Internet options-> Security -> Internet or Intranet -> Custom level -> User authentication) is set to anonymous logon, you will get the above error. I didn’t find any mention for this cause so here it is.
The solution that worked for me: Open your Internet Information Services manager and from the [your machine]/Web Sites/ Default Web Site node select the virtual folder which stores your project. Right Click and select Properties to select the ASP.NET tab page. Make sure the correct version ASP.NET Version is selected.
sp_help_job returns information about jobs that are used by SQLServerAgent service to perform automated activities in SQL Server. EXEC MSDB.DBO.SP_HELP_JOB
List all the database on SQL Servers. SQL SERVER 2005 System Procedures EXEC sp_databases EXEC sp_helpdb SQL 2000 Method still works in SQL Server 2005 SELECT name FROM sys.databases SELECT name FROM sys.sysdatabases
The UNC is a standardized method for naming servers, files, and directories in shared computer networks and for identifying the location of shared peripheral devices, such as printers, scanners, or other such resources. The format of a UNC file name usually uses two backslashes (\\) to designate a server and a single backslash to name […]
The db_datareader role The db_datareader role has the ability to run a SELECT statement against any table or view in the database. This role is often used in reporting databases where users would be coming in via a third-party reporting tool and building their own ad-hoc queries. If you need to restrict a user to […]
Categories
HtmlMeta Class
private void AddMetaRefresh() { HtmlMeta metaValue = null; metaValue = new HtmlMeta(); metaValue.Attributes.Add(“http-equiv”, “refresh”); metaValue.Attributes.Add(“content”, Settings.AutoRefreshInterval.ToString()); this.Page.Header.Controls.Add(metaValue); }
Problem: Couldn’t connect to MySQL on TGIIS from TGSQL Solution: Try this command (after logging into mysql with root) GRANT ALL PRIVILEGES ON *.* TO ‘myaccount’@’%’ IDENTIFIED BY ‘some_pass’ WITH GRANT OPTION; where myaccount is any new account you want to create. Note the hostname is ‘%’ which gives blanket permission to allow logging in […]