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...
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...
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...
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...
...@TransactionSeq INT
IF @Source = 'Flat01'
IF @TableName IN ('TransactionMaster', 'Deduction', 'NameInvolvement')
BEGIN
/*
<Key>
<ProductCode>E&O</ProductCode>
<FeedDate>200911051127</FeedDate>
<TransactionId>25</TransactionId>...
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...
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.