As much as I hate it you can use the Client Access (iSeriesAccess) ODBC or OLEDB provider within SSIS for your connection. At my current position I no longer...

You cannot do a Select From storedprocedure. You can convert the stored procedure to a table valued function and then you can join on the table valued function. ...

IN 2005 you use sp_send_dbmail as xp_sendmail is how SQL Mail worked which, as the error says, is not supported on 64-bit. Check out sp_send_dbmail in BOL.

The permission is specific to object you are selecting grant on. If I have a table users and I am Granting ALTER to that table to user1 then user1...

Use a For Each Loop Container to iterate over the rows in your variable and put the Send Mail Task into the For Each Loop. In the Execute SQL...

If you are really using SQL Server 2005 and you set the service account to a domain account during setup then the setup handles setting the necessary permissions.

If you changed...

I would cluster on the Identity column which will help with the MAX and the filter on the max. And depending on the the other queries affecting this table...

I think this is what you are looking for, keeping in mind my other comments:

[font="Courier New"]CREATE PROCEDURE OrderID

    @StartDate DATETIME,

    @EndDate DATETIME,

    @OrderID NVARCHAR (40) = NULL,

    @CustomerId NVARCHAR(40) = NULL,

    @ICPAuditID NVARCHAR(40) = NULL

AS

SELECT                

    T_OrderHeader.OrderID,

    T_OrderHeader.CustomerID,

    T_OrderHeader.ShipCountry,...

You need to specify what you granting ALTER to like:

Grant Alter On schema::dbo TO user/role, etc...

This is new because SQL Server 2005 has changed syntax for users, roles, etc... to...

I know what you mean. I did use the ODBC driver back in DTS days and have used the .NET driver in an ASP.NET web service. They work...

I don't believe that this is possible. The subreport uses the page settings of the master report. It would be a nice feature and I wanted it back...

First of all the code you posted only has one parameter defined and you reference 5 in the query so where are they coming from?

Here are a few things to...

Sure you can transfer data between AS400 and SQL Server using SSIS without HIS. You can use the ODBC or OLEDB provider provided by IBM or another provider to...

a.thomson2 (7/25/2008)

---

Just to confirm then, when the 3rd party app writes the data back to this table, hen the trigger fires and changes the last column to Null from what...

This is in addition to what GSquared and tertiusdp said. Although since the id field is character you can't convert it to an Identity column without changing the data type...