Search results for query: *

I tried deploying my package to the server and runing it with a sql agent job. It ran fine. It did not prompt for the child package's password. So it would seem that it only prompts for the password when running in visual studio. I can live with that.

I am using SSIS 2008. I am trying to use the execute package task to execute a child package that is password protected. Eventhough I have entered the child's password into the execute package task's password property, I still get prompted for the child's password when I run the parent...

Thanks Bill. Select statements with openquery have always worked fine. But I'm now trying to see if I can call stored procedures.

I have a linked server pointing to DB2 on AS400. I am trying to call a stored proc on the AS400 from SQL Server 2008. I first tried:select * from openquery ( ADM_AS400_LPAR, 'CALL XGGNDTAADM.EFILE_GET_QUICK_SEARCH (''C007984A'')')I get the error message: The OLE DB provider "IBMDA400" for...

I've sorted your results by RecNo to make them easier to read. RecNo Item# RealEffDt RealEffDt_End EffDt_Diff 1123 101493 NULL 12/31/2008 NULL 1124 101493 NULL 12/31/2008 NULL 1125 101493 NULL 12/31/2008 NULL 1126 101493 NULL NULL...

Emtucifor, I first tried running trace on the remote system to see what it was actually executing. The original update statement with openquery resulted in the following 2 executions on our remote system:SELECT grbpqs AS RequestStatus FROM xggndta.zagrdf00 WHERE grbpqs=? AND crcrda=? AND...

Emtucifor Thanks for all of your suggestions. I'll try them out tomorrow. I have a feeling that I may ultimately go with your stored procedure idea. Since I don't need to join to sql server tables, that probably will give me my best performance. - Dan

I am attempting to update a table on our AS400 from a SQL Server 2008 stored proc using a linked server. UPDATE OPENQUERY( ADM_AS400_LPAR, 'SELECT grbpqs AS RequestStatus, FROM xggndta.zagrdf00 a WHERE grbpqs = ''10'' AND grcrda = 1100809 AND grcrti = 1514 AND...

In SSIS 2008, I was able to define an odbc connection manager. But when I go to the tool bar, I can't find an ODBC data flow source. The only data flow sources I see on the tool box are ADO NET, Excel, Flat File, OLE DB, Raw File, and XML. So how can I use my odbc connection manager?

Philhege, SELECT MIN(ABS(b.NetPremium - d.NetPremium))I understand that is the problem because b.NetPremim refers to a field that is outside the sub-query and that is not allowed in an aggrate function. I don't understand why SQL Server does not allow this, but apparently it doesn't. My 2nd...

Here is my original query:UPDATE #AdjustedPremium SET AdjustedNetPremium = c.NetPremium FROM #AdjustedPremium a INNER JOIN AccountCurrent b ON a.AccountCurrentID = b.AccountCurrentID INNER JOIN #PremiumFinancialTemp c ON b.ProductCode = 'CHIRO1' AND b.BookDate...

I'm attempting to re-write an ETL solution with SSIS that was originally written using MS Access 97. The Access 97 solution contains a lot of custom VBA scalar functions that encapsulate business logic. These scalar functions are used to create derived columns in many different queries. The...

Why don't you give an example of your xml input and desired output.

The following link suggests that the quoted_identifier must be on when using certain xml methods such as nodes an value. http://vadivel.blogspot.com/2005/07/xml-data-type-and-quoted-identifier.html Can anyone confirm this?

Markros, I would agree that there is nothing obvious requiring usage of quoted identifier. Never the less, it is required for some reason. Otherwise I get the following error message: The following link gives more details on the problem...

This is one of the stored procs that require quoted_identifier on. Otherwise the insert statements generate a run-time error. CREATE PROCEDURE dbo.sp_ErrLogInsert ( @ErrorCode VARCHAR(5), @Keys XML, @TableName VARCHAR(50), @Source VARCHAR(50) ) AS...

I noticed that not all of my stored procs behaved the same when compiled using sqlcmd instead of management studio. The culprit appears to be how QUOTED_IDENTIFIER is defaulted. Management studio defaults it to ON. Sqlcmd defaults it to OFF. So I'm now tempted to explicitely put SET...

George, You da'man. Your solution worked great! - Dan

The following code snippet works:DECLARE @Response XML SET @Response = '<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <soap:Body> <ProcessUWResponse>...

Thanks guys for your help. At least I understand why this was happenning. Sounds like the easiest sollution is to SET NOCOUNT ON. pwise's solution would also work.