Search results for query: *

I have a T-SQL script that is almost 1,100 lines of code that is acting strangely. It has 19 "steps" and if you copy and paste the code into a query window in SSMS, it runs perfectly. But if you add a link to the script in an SSIS connection and run it from an Execute SQL task, it runs steps 1...

This almost works. The SDM_Field contains character data. This should not show all nulls. Suggestions appreciated. Thanks, Brooks SELECT [DESTFLD] ,[AFS] as AFS,[CLCS] as CLCS,[CPI] as CPI,[ForeignOfficeDeposits] as ForeignOfficeDeposits,[HEQ] as HEQ ,[ILN] as ILN,[INVSEC] as...

I'm much more familiar with VBA and less so with T-SQL. Does the following code make sense? If a ‘WHEN’ statement evaluates as true, are the following WHEN statements skipped? update CPI_Temp Set [ID_OWAM] = CASE WHEN [Orig_wam]< 24 THEN '01Y' WHEN [Orig_wam]< 48 THEN '03Y' WHEN [Orig_wam]<...

Hi, I use VS 2008 to create SSIS packages, but when I go to File, New, Project it does not offer a VB.NET project type. Can someone tell me whether VB.NET is included in VS2008 or is it a separate licensing fee? What would be the name of the installation program for VB.NET? Thanks! Broks

I'm working on an application that will have about a dozen SSIS packages. These will be run manually on different days and times. What are the options for putting these onto one screen with 12 buttons (1 per package) that can be clicked to launch the package? Thx.

I have a SP, called SP_Test which includes the msdb SP sp_send_dbmail. When I run SP_Test from the Stored Procedure folder, it works perfectly fine and ends by sending an email. But when I run SP_Test from a Job in SQL Server Agent, I get this error when it hits the sp_send_dbmail: Executed...

I'm working with some Excel objects through VBA in Access. I'm working with a spreadsheet that has 3 connections. I can see them in Data, Edit, Links. But when I create and Excel object and a workbook object, I can't see the links. ?xlIn.ActiveWorkbook.Connections.Count 0...

Would appreciate suggestions for a good reference book for writing VBA code in Access which manipulates Excel objects. (not looking for a book for writing VBA WITHIN Excel) Thx

Error is: %1 could not be found Failed to open document Am using CR 2008. The error occurs regardless of whether I double-click on the *.rpt file or if I start CR then load the the *.RPT. I was working on this file last week and have quite a bit of time invested in it. It contains about 2...

I have a script which contains a "work" table that was being generated as it ran (via INTO). Later queries which used the table ran too slow so I added CREATE INDEX statements on the work table. This had no effect. So I made the work table permanent and added the indexes before the script...

I'm running a lengthy SQL script from the Visual Studio using a Execute SQL task. What statements can be added to the script to display the date/time at key points (similar to a Debug.Print)? Ideally, I'd like to write to the Progress window but saving to a text file would also work. Thx, Brooks