FYI: Using Try's With Finally

Jul 25, 2006

Within my script component I was having some difficulty getting nested Exceptions to bubble out of the script component logic. The symptom appears when you get an ex.message of "Object reference not set to an instance of an object." As soon as I removed the Finally section my message (or the actual Exception object) was properly passed to the caller.

I've only done minimal work with Try/Catch/Finally structures. Is this normal?

Thanks,

Jeff Tolman
E&M Electric

View 6 Replies


ADVERTISEMENT

2k5 FINALLY Installed

Nov 7, 2006

So where do I go from here/

SSMS doesn't seem to have anything like QA?

I spent the better part of today installing everything...read somewhere about using VS to write code for sprocs.

What does everyone else do?

View 6 Replies View Related

Finally Crossed Over ...

May 13, 2008

Good morning (or afternoon, depending on your local).I've finally crossed over from Access to SQL Server. An interesting step fraught with surprises, syntax quirks and occasionally some exclamations of joy (just kidding).Anyway, here's my first question. I'm working on moving a currently functioning VB app from an Access backend to a SQL Server back end. In the process, I have been converting my app driven SQL calls to Server based stored procedures. Aside from a few issues (like SQL not liking concatenating string with the &), everything has worked out until this gem: SET NOCOUNT ONTRANSFORM Max(tE.EntryKey) AS Expr1 SELECT tE.ProjectKey FROM TS_tblWeeks tWINNER JOIN (TS_tblProjects tPINNER JOIN (TS_qryGroup tGINNER JOIN TS_tblEntry tE ON tG.GroupKey = tE.GroupKey) ON tP.ProjectKey = tE.ProjectKey) ON tW.WeekKey = tE.WeekKey WHERE (tE.WeekKey) = 1 And (tE.PersonKey) = 1GROUP BY tW.WeekKey, tE.ProjectKey, tP.ProjectSortORDER BY tW.WeekKey, tP.ProjectSort, tG.GroupKeyPIVOT tG.GroupKey;SQL server reports:Msg 102, Level 15, State 1, Line 1Incorrect syntax near 'tE'.Msg 156, Level 15, State 1, Line 13Incorrect syntax near the keyword 'PIVOT'.The highlighted lines are the TRANSFORM and PIVOT lines.The query works fine in Access, and works fine through ADO.NET as a supplied query. My intention is to make the two integers in the WHERE clause to be parameters supplied to the procedure.It's something simple, isn't it?Thanks!

View 14 Replies View Related

Finally Bought A Book Specifically For T-sql

Mar 30, 2008

Apress pro t-sql 2005. so far it seems pretty good in clearing up a lot of things Ive been doing but wasnt really sure I understood the same way I understand for example, C#. It was the little things about the language that Ive never been realy clear on such as basic control flow statements. Anyone else read this book yet ?

View 2 Replies View Related

Now It's Our Turn To Face This Issue.. When It Will Be Finally Resolved..

Sep 28, 2007

Hi all,
We have 2003 EE 64 bit & SQL 2005 EE 64 bit as well(service packs for windows & SQL pack 2 (9.030.42), now I have discovered this things with conversion of DTS to SSIS... We have set Oracle linked servers - they are working, at least we can see stuff, haven't tried to write on Oracle yet, sqlplus is also able to connect to oracle servers.. Our Oracle guy have installed 10.2.0.3 patch 10, but still no luck with SSIS...I'm not going to rename folders on production, like someone suggested it here...I checked path also, there was seems to be required folders included..I even tried to create SSIS on my PC and deployed it on 64 bit, using files method, without saving on SQL server - doesn't work, when it hit part with Oracle connection..And in connection string it looks like it use OLEDB..
I'm not excited about using OPENQuery etc, instead of SSIS.. It's just driving me nuts with this things...How Microsoft testing this stuff if bunch of people facing this issues and there's still no officiall fix or something like that..

View 9 Replies View Related

How To Launch Package From Client Machine, Display Progress And Finally Results?

Oct 4, 2006

Please help. I'm completely new to SSIS, and I was hoping someone could point me in the right direction(s).

I am developing a winforms client app, and I need to be able to provide the user with the ability to import data in CSV format into our application's database.

I'd like to use SSIS if possible, as long as what I am trying to do isn't near impossible.

I'm thinking of a UI where the user can specify a flat file (CSV) to upload and be processed by an SSIS package on a remote database server.

This package will be responsible for validating the CSV file and inserting data into the database as appropriate.

Is there a way I can:

launch an SSIS package remotely, from a winforms app on the client machine that is not running SQL server (preferably asynchronously) -- and pass it some parameters, including the import file itself
(optionally) provide progress feedback to the client pc to let them know it is being processed
display a nice SSRS report on the client upon completion that tells them exactly what the success/failure of the import was (how many rows processed, which ones failed and why, etc)

Any helpful examples, links, etc would be most appreciated.



Thanks in advance!

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved