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...
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?
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...
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>...
When using the sql server 2005 oledb provider, I've found that the only way to get a resultset back from a stored proc that updates data behind the scenes is to include SET NOCOUNT ON in your stored proc. If I don't include SET NOCOUNT ON, I get the following error after I open my recordset...
I'm trying to create and xml representation of many tables (1 to many relationships). I've found the easiest way to do this is using the "for xml raw, elements" clause. All of the more advanced techniques involve creating a schema which I would like to avoid if possible. The only problem I...
When I run my query through i-series navigator's explain tool, it says that the query will use the CQE because translation is required. I've searched, but the only examples I've found of translation functions are upper, lower, and CCSID conversions. My query includes none of these. What other...
I come from an Oracle and DB2 backgroud. I am new to SQL Server. When using Oracle and DB2, I was always told to avoid large bulk inserts because you are likely to blow your rollback segments. I was told to instead use a cursor and commit after every 50,000 rows or so.
Now on SQL Server...
I am using BCP to import a fixed width flat file into an sql server staging table. The problem is that when a text field is blank, BCP is loading spaces into the staging table. I would like BCP to treat a blank field as null, not spaces. Is this possible?
- Dan
I have a source file QDDSSRC that contains many source members of type TXT (SQL scripts that are to be executed with strsqlstm). Editing them with SEU works, but can be tedious. Is there anyway to transfer a source member to an external Windows editer, and then transfer it back (FTP?). Copy...
The system table dba_ind_columns doesn't specify whether an index column is ascending or descending. Is there any way to determine this using database queries?
My platform is AS400 V5R4 DB2.
Is it possible for a sql stored procedure or stored function to determine what userid executed it? For example in oracle you could use the following select:
select user from dual ; Is there anything equivalent for DB2?
Does anyone know how I can simulate an aggregate function to calculate the median of a group of values? My query would look something like the following:select field1, sum(field2), avg(field2), median(field2)
from myTable
group by field1As far as I can tell, access does not have an aggregate...
Version 8.0.5.0
Operating System: Windows 2003 Server.
We just moved our oracle database to a new server that has significantly more resources - much faster CPU, more ram, much faster hard drives, much faster network. And as expected, oracle does run a little faster on the new server, but we...
I have created a drop down list in excel 97 to restrict entry to a fixed set of values. This restriction works fine as long as the user either uses the mouse to select a value from the drop down, or the user manually types in a value. The problem is that the user can use copy and paste to put...
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.