SSIS Build Error
Nov 14, 2007
Hi,
I have developed one SSIS package. Later on i deleted one unused connection from it.
When I try to deploy the package, it is giving error that the connection is missing from the container of collection.
The same package is executing successfully even after throwing this error.
Please advice
Thanks is advance
View 1 Replies
ADVERTISEMENT
Mar 22, 2006
Hello,
we have automated build on every night. In our solution is SSIS project, where each package is encrypted per password. We call build process per command line like this..
C:ProgrammeMicrosoft Visual Studio 8Common7IDEdevenv.exe (c:DevelopmentX3\X3.sln /build Release)' in 'c:DevelopmentProjectsDailyBuild
Through build process we get a error:
External Program Failed: C:ProgrammeMicrosoft Visual Studio 8Common7IDEdevenv.exe (return code was 1):
We think a reason is, that on build of SSIS project must be entered a password. You can wonder for what we need that SSIS packages are part of our build. We hope that on build process is also created Deployment Utility, if so set in dtproject.user. Is it so? Is there any way to create Deployment utility on automated build process? Can be a password provided pre command line?
with best regards
Anton Kalcik
View 5 Replies
View Related
Oct 18, 2007
II am using file system for the SSIS Packages. I have several packages in a project. Most of these packages use configuration files. Infact there are several packages which use the same configuration files. Now when I try to run the build utility, it errors out saying that the name.dtsconfig file already exists. Seems like this is a bug. I would really like to use this utility.I know if the config file is not used in any other pacakge probably the build will not fail. But it is not good practice to have one config file for each package, it is redundancy, does not make sense to that. Is there any way I can use the build and deployment utility without this error.
Please advice.
Thank you.
View 4 Replies
View Related
Aug 28, 2006
hi,
i have a global variable that is a file dir param lets say: d:input2006_07_18.bcp.
this param supposed to be built from other 3 params i.e: day, month and year.
how do i build it dinamically i need the exact syntax. i have already put the filedir param as an evaluated expression but when i try to do somthing like:
@[User::Filename] + @[day] + @[month] + @[year] i get an error, although i succeed in putting only one param at its expression i.e: @[user:filename].
the question is how do i build the parameter that will b built from these 3 params in its expression.
Brian, i will b happy to hear from you in regard.
thx,
Tomer
View 8 Replies
View Related
Jun 28, 2007
Can anyone help me with this ?
I am trying to extract data from oracle 9i server and
pushing it onto the SQL Server 2005 using Data Flow Task.
Details for OLE DB Source are :
OLE DB Source Editor Details:
OLE DB Connection Manager - Oracle Source
Data Access Mode - SQL Command
SQL Command Text -
SELECT EMPNO, EMPNAME, JOB, HIREDATE
FROM EMP_DETAILS
WHERE (HIREDATE > TRUNC(SYSDATE) - 1)
SSIS parses this query succesfully but when i build the query it shows query
SELECT EMPNO, EMPNAME, JOB, HIREDATE
FROM EMP_DETAILS
WHERE (HIREDATE > TRUNC("SYSDATE") - 1)
Please note :- SYSDATE IN " "
This query returns no Result Set.
View 6 Replies
View Related
Apr 28, 2006
Hi,
I'm working with SSIS and I would add the Integration Service project to the daily build process but I need to know how to generate the <name>.SSISDeploymentManifest other then invoking the devenv.exe.
Thanks,
View 3 Replies
View Related
Oct 5, 2007
Afternoon everyone!
I would really be grateful for some advice regarding the above matter (note: am novice to the 'client/server' implementation, so would ask for your patience, pls!):
We have a front-end Access 2K app’n, which connects to some back-end data, (using a 'dsn-less' ODBC link (Access table)). The system was not in use for several months, during which time the server was re-built.
The problem I’m having is that although I can connect to the back-end data, the other users are unable to do this.
I have been looking into the problems/issues encountered so far, including:
· - Updating the dsn-less connection table within the front-end Access application (note: we have other applications which use this method for connectivity, without any problems here), i.e.
ODBC;Driver={SQL Server};APP=Microsoft Access;UID={updated username};PWD={updated password};Server={name of server};DATABASE={name of database on server}
· Re-visiting the ‘ODBC Data Source Administrator’ and checking the configuration of the ‘Microsoft SQL Server DSN Configuration’ (i.e. ‘Window authentication, using the network login’, etc).
The strange thing is that I’m able to access the back-end data, via the application without any problems at all (I’m using the full version of MS Access 2K, as need to eventually make changes to the front-en app’n. All of the users have MS Access 2K run-time only installed).
However when the user tries to log, they acquire ‘ODBC—connection to {Access application name} failed’ messages.
Up to three other users have tried to access the system, and acquire error message of the following nature:
Within the front-end application:
· ‘The {Access application name} is not available (Error No: 3151. Error: ODBC—connection to {Access application name}’ failed.)
· (1) Initially the user obtains the message: ‘The expression you entered has a function that ‘{Access application name}’can’t find.’ Then (2) I receive an ‘Action Failed’ on the ‘AutoExec’ macro (this is set up to execute a function which acquires the user’s window’s login details).
Linking to the back-end data:
· Connection failed: SQLState: ‘28000’. SQL Server Error: 18456. [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ‘{domain_name}{users_Windows_login_name}’.
· Whilst user was logged in at my desktop, I tried to implement a ‘SQL Server ODBC Data Source Test’. However the ‘Test Results’ have been as follows
“Microsoft SLQ Server QDBC Driver Version 03.85.1117. Running connectivity tests… Attempting connection [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ‘{domain_name}{users_Windows_login_name}’.
We currently have other client/server applications which link using the above methods (ODBC dns-less connections, etc), but have no problems with the user’s and their permissions to access these.
Would appreciate any help/suggestions/advice, etc with this.
Many thanks in advance.
Magnetar4
View 4 Replies
View Related
Aug 20, 2007
All:
I've implemented a variation of the Custom Logging provided in this post by Jamie Thomson.
http://blogs.conchango.com/jamiethomson/archive/2005/06/11/SSIS_3A00_-Custom-Logging-Using-Event-Handlers.aspx
Everything seems to work well on my desktop during development, but when I deployed the packages to our DEV environment the packages still execute, but I'm now receiving warning messages in the sysdtslog90 log table...
Precompiled script failed to load. Attempting to recompile. For more information, see the Microsoft Knowledge Base article, KB931846 (http://go.microsoft.com/fwlink/?LinkId=81885).
My log table (SSISLog) looks OK, with only OnPostExecute messages that include the package / task information and rowcounts.
The KB article suggests upgrading to SP2, but I'm well past SP2, using Build 3159 on both machines.
Any suggestions on how to get rid of the warnings?
Thanks!
Leda
View 2 Replies
View Related
Oct 16, 2006
Hello,
I am having problems installing the SP1 for SQL server 2005 on a W2K3 R2 server. It appears that the Database Services and Analysis Services are not being updated. I would appreciate any help with this if anyone has seen or had experience with this issue.
Thanks, the basic log file is listed below.
Redist9_Hotfix_KB913090_3.log
09/17/2006 19:15:53.408 ================================================================================
09/17/2006 19:15:53.408 Hotfix package launched
09/17/2006 19:16:57.719 Attempting to install instance: SQL Server Native Client
09/17/2006 19:16:57.735 Attempting to install target: HOSPSQL
09/17/2006 19:16:57.735 Attempting to install file: sqlncli.msi
09/17/2006 19:16:57.782 Attempting to install file: \HOSPSQLc$a9c93a7747dec24c4a58HotFixSqlncliFilessqlncli.msi
09/17/2006 19:16:57.782 Creating MSI install log file at: C:WINDOWSHotfixRedist9LogsRedist9_Hotfix_KB913090_sqlncli.msi.log
09/17/2006 19:16:57.782 Successfully opened registry key: SoftwarePoliciesMicrosoftWindowsInstaller
09/17/2006 19:16:57.782 Failed to read registry key: Debug
09/17/2006 19:16:59.610 MSP returned 0: The action completed successfully.
09/17/2006 19:16:59.626 Successfully opened registry key: SoftwarePoliciesMicrosoftWindowsInstaller
09/17/2006 19:16:59.626 Failed to read registry key: Debug
09/17/2006 19:16:59.626 Successfully installed file: \HOSPSQLc$a9c93a7747dec24c4a58HotFixSqlncliFilessqlncli.msi
09/17/2006 19:16:59.626 Successfully installed target: HOSPSQL
09/17/2006 19:16:59.626 Successfully installed instance: SQL Server Native Client
09/17/2006 19:16:59.626
09/17/2006 19:16:59.626 Product Status Summary:
09/17/2006 19:16:59.626 Product: SQL Server Native Client
09/17/2006 19:16:59.626 SQL Server Native Client (RTM ) - Success
09/17/2006 19:16:59.626
09/17/2006 19:16:59.626 Product: Setup Support Files
09/17/2006 19:16:59.626 Setup Support Files (RTM ) - Not Applied
09/17/2006 19:16:59.626
09/17/2006 19:16:59.626 Product: Database Services
09/17/2006 19:16:59.626 Database Services (RTM 1399 ENU) - Not Applied
09/17/2006 19:16:59.626 Analysis Services (RTM 1399 ENU) - Not Applied
09/17/2006 19:16:59.626 Reporting Services (SP1 2047 ENU) - Not Applied
09/17/2006 19:16:59.626
09/17/2006 19:16:59.626 Product: Notification Services
09/17/2006 19:16:59.626 Notification Services (SP1 2047 ENU) - Not Applied
09/17/2006 19:16:59.626
09/17/2006 19:16:59.626 Product: Integration Services
09/17/2006 19:16:59.626 Integration Services (SP1 2047 ENU) - Not Applied
09/17/2006 19:16:59.626
09/17/2006 19:16:59.626 Product: Client Components
09/17/2006 19:16:59.626 Client Components (SP1 2047 ENU) - Not Applied
09/17/2006 19:16:59.626
09/17/2006 19:16:59.626 Product: MSXML 6.0 Parser
09/17/2006 19:16:59.626 MSXML 6.0 Parser (RTM ) - Not Applied
09/17/2006 19:16:59.626
09/17/2006 19:16:59.626 Product: SQLXML4
09/17/2006 19:16:59.626 SQLXML4 (RTM ) - Not Applied
09/17/2006 19:16:59.626
09/17/2006 19:16:59.626 Product: Backward Compatibility
09/17/2006 19:16:59.626 Backward Compatibility (RTM ) - Not Applied
09/17/2006 19:16:59.626
09/17/2006 19:16:59.626 Product: Microsoft SQL Server VSS Writer
09/17/2006 19:16:59.626 Microsoft SQL Server VSS Writer (RTM ) - Not Applied
09/17/2006 19:16:59.626
09/17/2006 19:26:59.494 Hotfix package closed
View 12 Replies
View Related
May 8, 2007
Hi,
I removed a role in the datasourceview of a datamodel. Later I removed the role in the reportmodel. There are always two roles for one relation. Now I only have one role left and I can't delete it anymore.
This is the error I get when building the project.
Error 2 The RelatedRoleID property of the Role 'invoicelineid' refers to the Role 'Gd1b03590-f98b-46aa-945d-c90ccd5d6028', which is not in the same SemanticModel as the Role 'invoicelineid'. Max generiek.smdl 0 0
When I try to remove the role I'll get an error : object reference not set to an instance of an object.
If I look at the properties of the role I see that when I open 'related role' there is nothing in it, except an ID: Gd1b03590-f98b-46aa-945d-c90ccd5d6028 and as name: Object reference not set to an instance of an object.
I also tried to remove the whole entity but that resulted in the same error. It's not an option for mee to remove the whole model and autogenerate it again, but there is too much work in it already.
If I try to remove this thing in the xml itself it gives other errors and the model won't load anymore.
I hope somebody has a solution for this.
thanks in advance,
Julian Kooiker
View 1 Replies
View Related
Aug 25, 2015
When ever i tried to build a cube, i get stuck in this attribute relationship. either i shows a "yellow" icon in the hierarchy or "red" underline in the attribute column.I dont know how to rectify those errors.
View 2 Replies
View Related
Aug 1, 2006
I have a SSIS package that reads data from a dump table, runs a custom script that takes date data and converts it to the correct format or nulls and formats amt fields to currency, then inserts it to a new table. The new table redirects insert errors. This process worked fine until about 3 weeks ago. I am processing just under 6 million rows, with 460,000 or so insert errors that did give error column and code.
Now, I am getting 1.5 million errors. and nothing has changed, to my knowledge. I receive the following information.
Error Code -1071607685 Error Column 0 Error Desc No status is available.
The only thing I can find for the above error code is
DTS_E_OLEDBDESTINATIONADAPTERSTATIC_UNAVAILABLE
To add to the confusion, I can not see any errors in the data written to the error table. It appears that after a certain point is reached in the processing, everything, or most records, error out.
Any help is appreciated.
Thanks
Derrick
View 21 Replies
View Related
Feb 29, 2008
Hi all,
can anyone tell me if an oleDb connection (provider is Jet 4.0 to Access database) can be enlisted in a Distributed Transaction?
The goal is to copy data from SqlServer to Access within a transaction.
Pier
View 10 Replies
View Related
May 10, 2007
I have tired for this!
When I use SSIS for extract data from ssas, that means,I use mdx query.
then random error occured.
Hope some one can understand my poor English....
And the Error Info show below.
Code Snippet
Error: 0xC0202009 at Data Flow Task - For Individual User Tech Points, OLE DB Source 1 1 [31]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E05.
An OLE DB record is available. Source: "Microsoft OLE DB Provider for Analysis Services 2005" Hresult: 0x00000001 Description: "Error Code = 0x80040E05, External Code = 0x00000000:.".
Error: 0xC004701A at Data Flow Task - For Individual User Tech Points, DTS.Pipeline: component "OLE DB Source 1 1" (31) failed the pre-execute phase and returned error code 0xC0202009.
View 6 Replies
View Related
May 20, 2008
Hello,
I recently joined a company that is having an issue connecting to SQL Server Integration Services on one of their production servers. When trying to connect via management studio, both locally and remotely, they receive the error below. The server is a 64 bit server and is using third party replication (Veritas).
It sort of sounds like the issue described in this knowledge base article: http://support.microsoft.com/kb/919224. However, we do not have a problem creating maintenance plans. I'd just give it a shot but its a production server and getting approval to do anything that modifies the registry with the registry replication setup is a pain, so I'd like to determine if there could be another cause first.
TITLE: Connect to Server
------------------------------
Cannot connect to ***************.
------------------------------
ADDITIONAL INFORMATION:
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)) (Microsoft.SqlServer.DTSRuntimeWrap)
------------------------------
Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)) (Microsoft.SqlServer.DTSRuntimeWrap)
------------------------------
BUTTONS:
OK
------------------------------
View 1 Replies
View Related
Jan 28, 2008
Hi All,
Recently in an SSIS package I am getting the following error for a particular Data flow task.
Error: 2008-01-25 12:01:48.58
Code: 0xC0202009
Source: Import Datasynapse Data User Events Source [3017]
Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x8000FFFF.
End Error
Error: 2008-01-25 12:01:48.73
Code: 0xC004701A
Source: Import Datasynapse Data DTS.Pipeline
Description: component "User Events Source" (3017) failed the pre-execute phase and returned error code 0xC0202009.
End Error
Our guess is when the data size of User Events table is more it throws this error. If we try to transfer small subset of data it succeeds. What could be reason for this error?
Since this is very urgent, immediate response would be very much appreciated.
Thanks & Regards,
Prakash Srinivasan
View 4 Replies
View Related
Nov 21, 2007
I click on menu item SSIS and enable logging to my SQL Database (SSIS log provider for SQL Server). When I run the package it runs fine for the first time. Upon subsequent runs I get the following error.
[Log provider "SSIS log provider for SQL Server"] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80040E14 Description: "There is already an object named 'sysdtslog90' in the database.".
It seems like I need to drop the table every time to avoid this error. Is there a way I can log all package logs to single table historically? Any weblink or tip is appreciated.
Thanks!
Palak Mody
View 3 Replies
View Related
Jan 12, 2001
Hey folks, I just inherited a machine where select @@version returns this:
Microsoft SQL Server 7.00 - 7.00.710 (Intel X86)
Okay, I know that:
623 is orig sql
699 is sp 1
842 is sp 2
961 is sp 3 -- but what's 710 ?
going to http://search.support.microsoft.com/kb/c.asp?ln=en-us gets me exactly 0 <zero> hits. Is this a hotfix someone's aware of?
Any thoughts/documentation/whatever would be appreciated.
Thanks,
Tom
View 1 Replies
View Related
Nov 14, 2000
I know how to use sql to write a block of sql statements by cutting and pasting the results in to the execution window. Now my question is this...
is there a way to create the sql and execute the results. i.e. Automatically cut and paste the results into the execution window and run it??
Something to munch on if your bored. Ideas appreciated.
View 2 Replies
View Related
Feb 28, 2008
The common way that we use to delpoy reports in production server is using rsbuild.config file and running the command to execute it. Is this a Microsoft product ? does it have any licensing issue if i need to use this approach in my production environment to deploy the reports?
View 1 Replies
View Related
Jun 10, 2008
Hi,
I have two tables called Actcodes and a another table called FundBalances...
The Act codes have the following format..
PlanId int,
ClientId int,
StartDate datetime,
EndDate datetime,
ClientActCode char(2)
CodeDescription char(15)
so based on what the user has selected i am getting the names of each codes
and they have the following Rows.
PlanId ClientId Startdate EndDate ClientActCode CodeDescription
111 1 1/1/2008 3/31/2008 01 Begininng balance
111 1 1/1/2008 3/31/2008 02 Contributions
111 1 1/1/2008 3/31/2008 03 something
111 1 1/1/2008 3/31/2008 04 sdkfjdkf
111 1 1/1/2008 3/31/2008 05 dfdfd
111 1 1/1/2008 3/31/2008 06 dfddfs
111 1 1/1/2008 3/31/2008 09 dfdf
111 1 1/1/2008 3/31/2008 15 dfdkfdlfk
and my fund balance i have the following rows..
PlanId int
Participantid int
StartDAte datetime,
end date datetime,
FundId int
Loans
Act1 char(2)
TotAct1 money
.
Act20 char(2)
TotAct20 money
and the data is as follows
PlanId ParticipantId StartDate EndDate fundId Loans Act1 TotAct1 Act2 totact2 ----- Act20 TotAct20
111 1212 1/1/2008 3/31/2008 15 NULL 01 15.15 02 15.48 20 12.4561
111 1212 1/1/2008 3/31/2008 45 0 01 45.12 02 453.123 20 54.00
so on and so so forth
tht Act1 matches the ClientActCode in the Act..
So is there a way i can get those column in my select which have actCodes present in the Act code table. for in... in my act code table for this plan i have 01,02,03,04,05,06, 09, 15 clientAct codes
so can i get the its respective Acts and Totacts column as Act1, Act, Act3, Act Act5, Act6 based on the ClientAct codes.
Any help will be appreciated..
Thanks
Karen
View 23 Replies
View Related
Nov 12, 2003
Hi.
I know this querry:
"SELECT TOP 10 * FROM MyTable ORDERBY ..."
will give the top 10 rows.
But how can I build a querry that can get the rows from 40-50 (ie).
Thanks.
View 2 Replies
View Related
Mar 8, 2004
Hi,
Please Help me to build this query.
I have got a "User" Table
---------------------
UserID UserName
---------------------
1 Tuffy
Another Table "Groups" Table
---------------------
GroupID GroupName
---------------------
1 Manager
2 Employee
3 Sales
I have got a "UserGroup" Table HOLDING ID'S as Foreign key.
The data in the TABLE is like this
---------------------
UserID GroupID
---------------------
1 1(Manager from "Group" Table
1 2(Employee)
1 3(Sales)
2 2(Employee)
2 3(Sales)
---------------------
Now when a user logged in The Groups have to be returned as a string that contains pipe separated Group names
for example "Manager|Employee|Sales|"
So if User 1 log in I need something like that
UserID (1)-->"Manager|Employee|Sales|"
Please help me how to write this query.
Regards
View 5 Replies
View Related
Mar 22, 2004
I'm trying to add a CASE to my statement, I keep getting a syntax error. Can anyone see the issue? Should this CASE work?
Thanks for your thoughts,
Select tmp.Alternate_Name,dbo.tblClient.Salutation
CASE
WHEN (tmp.Alternate_Name > '') Then tmp.Alternate_Name As Card_Name
Else dbo.tblClient.Salutation AS Card_Name END
From dbo.tblClient INNER JOIN dbo.tblCards tmp ON dbo.tblClient.ClientID = tmp.ClientID
View 1 Replies
View Related
Sep 29, 2004
Hi there, I have 3 columns that contain the same kind of information and I would like to do a select that would return all the distinct records of all 3 colums. Any help woulb be appreciated.
Thanks
View 4 Replies
View Related
Jan 21, 2005
I have two tables linked with the colunm name systemId and I need to get all the systems responding to the condition (t1.software & 0000000001) = 1 and if they have any contacts I would like to see them.
Here is what I have for the moment however my querry do not return the system info if no contact exist and that is wrong.
select customers.customerId,customers.systemId,customers.country
from customers,contacts
where (customers.software & 0000000001) = 1
and customers.SystemId = contacts.SystemId
order by customerid
Systems
-SystemId
-CustomerId
-Name
...
Contacts
-ContactId
-SystemId
-Name
-Tel
...
View 1 Replies
View Related
Dec 12, 2005
please help me
i need for example
when my user clicke in the button a new table build in my sql database
please help me
View 1 Replies
View Related
Nov 16, 1998
Anyone know the final build # for the RTM version?
Thanks
View 2 Replies
View Related
Feb 23, 1999
I swear I saw a stored procedure that would tell me what version service pack and what build my sql servers are...
Does anybody know how to find out? I think its a transact query...
Also, I think I saw a stored procedure that would associate that cryptic string of numbers into text; ex: "SQL 6.5, Service Pack 5"
View 5 Replies
View Related
Jun 4, 2002
l would like to intergrate the the two procedures listed below into one procedure or function.
l'm doing it in two steps.This report will have each loan listed and a final line summed on each of the amounts?
enddate and startdate being my parameters and print the results to screen.And l'm failing to do that thats why its in two steps.Hope this makes it clear enough.
-- Exec New '2001-04-01 00:00:00.000','2002-05-29 23:59:59.000'
-- Exec New1 '2001-04-01 00:00:00.000','2002-05-29 23:59:59.000'
Alter procedure new (@startdate datetime,@enddate datetime)
as
begin
SELECT Distinct
Loan_no AS Loan_no,
Date_Issued AS Date_Issued,
Store AS Store,
Product AS Product,
Capital_Amount AS Capital_Amount,
Interest_Amount AS Interest_Amount,
Total_Amount AS Total_Amount,
Insurance_amount As Insurance_Amount,
Admin_Fee AS Admin_Fee,
User_Issued AS User_Issued,
LoanBook AS Company,
Status
FROM Loan
Where Date_Issued BETWEEN '2001-04-01 00:00:00.000' And '2002-05-29 23:59:59.000'
End
Alter procedure new1(@startdate datetime,@enddate datetime)
As
Begin
SELECT
Sum(Capital_Amount) AS Capital_Amount,
Sum(Interest_Amount) AS Interest_Amount,
Sum(Total_Amount) AS Total_Amount,
Sum(Insurance_amount) As Insurance_Amount,
Sum(Admin_Fee) AS Admin_Fee
FROM Loan
Where Date_Issued BETWEEN '2001-04-01 00:00:00.000' And '2002-05-29 23:59:59.000'
End
View 1 Replies
View Related
Jun 25, 2002
Whats the quickest way of building a calender split by day,month,year,day name of week. l want populate the table with that information.
View 1 Replies
View Related
Nov 2, 2006
The Accounting Department needed some reports, and this was back when I was first learning SQL, so I wrote a batch file that used osql to run a procedure. This procedure created a second batch file with several hundred lines to run another stored procedure and output to .rpt files complete with page breaks.
Now I'm revisiting this process having learned alot since then, and would like some input on how to handle this better. The batch file works, but I've never been one of those "if it's not broke" type of people. I'm one of those "If it's not broke, give me 5 minutes and it will be" kind of people
I'm specifically interested in something to replace this CURSOR that builds the batch file:
Code:
DECLARE @Dealer Varchar(20)
DECLARE Dealer_Cursor CURSOR
FOR SELECT Dealer_id FROM Dealer WHERE (Dealer_id != '-1') AND (isnull(Category,'-1') != 'NOBILLING')
OPEN Dealer_Cursor
FETCH NEXT FROM Dealer_Cursor INTO @Dealer
WHILE @@Fetch_Status = 0
BEGIN
/* @Folder is passed as a fully qualified path to the billing folder */
/* Logging and Command Window Notification, to be placed into DealerBilling.bat */
PRINT 'ECHO Creating report for Dealer: ' + @Dealer + ' ...'
PRINT 'ECHO Creating report for Dealer: ' + @Dealer + ' ... >> "' + Substring(@Folder,1,3) + 'Reportlog.txt"'
PRINT '"osql" -SMYSERVER -UMYUSER -PMYPASS -w 103 -Q "EXEC MYSERVER.MYDB.dbo.Proc_Dealer_Listing '''
+ @Dealer + '''" -o "' + @Folder + '' + @Dealer + '.rpt"'
FETCH NEXT FROM Dealer_Cursor INTO @Dealer
END
PRINT ' '
CLOSE Dealer_Cursor
DEALLOCATE Dealer_Cursor
View 1 Replies
View Related
Apr 24, 2007
I have a table with 2 columns:
Col1 Col2
stat1,stat2 AV,AD
stat3 TD
I need to build a query like this:
SELECT *
FROM table3
WHERE stat1=AV and stat2=AD and stat3=TD
How do I do this?
View 6 Replies
View Related