In your trigger, try selecting from INSERTED into a temp table and adding the BatchID to the temp table. After updating the temp table with the BatchID, insert into your...

In SQL 2000 there is an OLE DB for ODBC provider (MSDASQL) that you can use to set up a linked server to the AS/400. Once you set up the...

From what little Spanish I know, it's seems like you're having authentication problems reading an XML data source using a SOAP endpoint?

Did you try enabling Kerberos and granting connect and...

You can create more complex logic in RS than one select statement. You can select the first group into a temp table with the correct aggregation and then join the temp table to the other...

I don't think you're going to like this, but here is another thread with the same situation. Note the respondant is a MSFT.

http://www.developmentnow.com/g/115_2005_4_0_0_510785/Invalid-column-name-ChunkFlags.htm

Have you tried to write the first line of the export file from the step where you select the global variables and then append the other records to the same file?

So you...

You could also create one or more global variables for your DTS package and concatenate the global variable onto a string variable with the first part of your table names.

The date...

Actually what SQL is doing is casting the float variable into scientific notation for the last value. You can cast the value as varchar and verify this for yourself. So if...

Have you tried setting the RepeatOnNewPage property to true? This property's default value is false.

Hope this helps,

Greg

No matter how you choose to do it, you'll have to create a linked server on the server where you are running the DTS package. The simplest way in DTS...

The easiest way to do this is to use a scripting task and instantiate a file object to see if the file exists. Then instantiate an Excel object and see...