James' answer is what you should use for the connection string.

sDBConnectionString = "data source=" & sDBServer & ";initial catalog=" & sDBName & ";persist security info=False;workstation id=" sWorkstationID...

It is a MAPI error not a file access error.

Just create a MAPI profile for the SQL Server Agent Account. To do that, open a Windows session using the Account used by...

You dont even need a global variable.

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

Update TT set ff=xx Where ....

IF @@ROWCOUNT=0

   RAISERROR 60001 'Error message'

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

When you raise an error in your stored procedure, the sql task...

Changing the destination database on the connection properties only changes the intial catalog (default). Transformation tasks use the fully qualified table names and you are stuck with database1.dbo.table1 when your...

And dont forget the

set nocount on

at the start of the PS.

HABIB.

After you run a DDL script in query analyzer you may need to refresh the tree in Query Analyzer Object Browser to the left of the screen.

Triggers will be found...

To be able to check permissions you need to establish a connection (other than the actual user's connection) to the database via a user with the role "db_securityadmin" or be a...

Use the "Execute Process Task" with the following command :

"c:\Program Files\Microsoft Office\Office11\msaccess.exe /compact /repair"

PS. Parameters can be localted in the parameters field.

HABIB.

The simplest way of doing it is to launch a Win32 utility called :

DTSRUNUI.EXE

You will find it in Program Files\Microsoft Sql Server\80\Tools\binn

It has an "Advanced" button that will allow...

I agree. Roles are the best way to go. You can further look into using an application role.

define an application role for every application that will be accessing the database....

It is only possible if you restrict access to your data through views or stored procedures.

With stored procedures you can begin by asking who the user is. The system function...

Sorry, Iforgot the line :

DTSDestination("col009")=MyDate

before the function return

This should do it :

MyDate = DTSSource("Col009")

if isnull(MyDate) then

   MyDate = Null

Else

   If Not isDate(MyDate) Then

      MyDate = Null

   Else

      MyDate = Mid(MyDate, 1, 4) & Mid(MyDate, 5,2) & Mid(MyDate,...

Staging is trhe best strategy for this situation. You must be careful however if you are populating a fact table in a datawarehouse. Updating records in a huge fact table can be...

I Think you restored an old version of your database.

In fact, when you do a backup, you have the option of adding or replacing existing backup copies on the...