Search results for query: *

I agree gk53, up to a point. I found there is a 32,767 character limit to the text, so above that, even the browse won't work. My script is 51,000+. Even pointing to the SQL file in a connection, when pointing to the connection from the Execute SQL task was not working in the end. The SP...

Thanks for the post, Olaf. No, no 'GO's. I found a workaround. I took the entire script and made a stored procedure out of it and that seems to be working. My conclusion is that some SSIS objects do not always perform correctly. Brooks

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...

I figured this out. The DestFld text itself contained square brackets in the text. This messed up the Pivot where square brackets have special meaning.

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]<...

Thanks for the post, Robert. We didn't realize there were 2 Visual Studios. Is the other one a separate purchase? Is it still available? If we can't find VS 2008 VB.NET, will the Visual Studio 2008 BIDS Version work with a Visual Studio 2010 VB.Net?

Thanks for the post. That may be the problem - I don't have a Language folder/item. In my left pane are: Business Intelligence Projects Other Project Types Visual Studio Solutions (shows only Blank Solution in the right pane) What is the install file for VS 2008?

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

Thanks for the post, Frederico. What project or template type do I need in Visual Studio to create a winform? Is Visual Basic or Visual C# required? They do not seem to be installed on my VS. Brooks

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.

Thanks everyone for the posts. This turned out to be a problem because there was an (optional) attachment to the email message. This required some extra permissions in the master and/or msdb databases (can't remember right now - it was last week). I have a to-do to go back and document...

I think that might have been true initially. On my first run, the the error said "Executed as user: PROD\SVCQRMSQLAG". So I went into the job and changed the "Run as" to my userid. Now the error message says "Executed as user: PROD\myuserid" as noted in my OP. I've added permissions for...

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 figured it out. Wrong constant. It needed to be: aLinks = ActiveWorkbook.LinkSources(xlExcelLinks)

Running this code from inside Excel does not show any of the 3 links that I can see by going to menu: Data, Edit Links. Sub ListLinks() Dim aLinks As Variant Dim i As Integer aLinks = ActiveWorkbook.LinkSources(xlOLELinks) If Not IsEmpty(aLinks)...

It is not a new workbook. I am opening up and setting links to an existing workbook. I can see the worksheets and all the cells, just not the links/connections.

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...

Hi Skip, Yes, I know this. Am looking for a specific title/author. Brooks

I do that, too. Thanks Andy. Would still the book suggestion ... :-)