Any work around for 4000 char maximum limitation in Expression

Hello,

I have to build dynamic sql statement in an SQL task.

The SQL statement is way over 4000 char.

The expression builder complains the length of the expression.

Any work around to this limitation?

Thanks a lot!

Add multiple varchar(4000) together.

DECLARE @.sql1 varchar(4000), @.sql2 varchar(4000), @.sql3 varchar(4000)

SET @.sql1 = 'stuff'
SET @.sql2 = 'more stuff'
SET @.sql3 = 'even more stuff'

EXEC (@.sql1+@.sql2+@.sql3)

|||Are you building the expression using variables and other things, or can you stick that SQL statement in a view?|||Instead of using an expression, you could build your SQL statement in a Script Task and write the result out to a file. The Execute SQL Task can read statements from a file connection. The OLE DB Source component cannot, but you could use the Execute SQL Task to put the results in a variable, then shred the results in your Data Flow using a Script Source Component.

Any work around for 4000 char maximum limitation in Expression

Hello,

I have to build dynamic sql statement in an SQL task.

The SQL statement is way over 4000 char.

The expression builder complains the length of the expression.

Any work around to this limitation?

Thanks a lot!

Add multiple varchar(4000) together.

DECLARE @.sql1 varchar(4000), @.sql2 varchar(4000), @.sql3 varchar(4000)

SET @.sql1 = 'stuff'
SET @.sql2 = 'more stuff'
SET @.sql3 = 'even more stuff'

EXEC (@.sql1+@.sql2+@.sql3)

|||Are you building the expression using variables and other things, or can you stick that SQL statement in a view?|||Instead of using an expression, you could build your SQL statement in a Script Task and write the result out to a file. The Execute SQL Task can read statements from a file connection. The OLE DB Source component cannot, but you could use the Execute SQL Task to put the results in a variable, then shred the results in your Data Flow using a Script Source Component.
sql

Any way to programmatically deploy an SSAS solution?

Hi all,

I'm trying to add a nightly build/deploy process for my SSAS solution. Basically - to take my AS solution from source control, deploy it to our dev server, and process just a few partitions.

What's the best way to do this? Looking at the solution folder, the .dsv, .dim, .cube, .ds files are all xml-based, which is good, but they don't seem like XML/A. (Seem very similar to a serialized version of AMO objects, but not quite exactly)

The only way I'd guess to do this is to manually load the individual xml files into an object model, and then map them to the AMO objects (since they're pretty similar..), and deploy those to the server. Is there a more efficient way to directly de-serialize the .dim,.cube, etc files into the AMO structures and deploy?

Take a look at the Deployment Wizard which you can run from Start... Programs... Microsoft SQL Server 2005... Analysis Services... Deployment Wizard.

Also see more info including command line switches here:

http://msdn2.microsoft.com/en-us/library/ms174817.aspx

|||

Furmangg, perfect tip on using the deployment wizard. I think this will suit our needs very well.

I was going to follow up w/ the correct method of compiling - I tried msbuild unsuccessfully, but I found this great blog post by Thomas Kejser -

http://schastar.spaces.live.com/blog/cns!12BCB785A5D8B3D4!148.entry?beid=cns!12BCB785A5D8B3D4!148&d=1&wa=wsignin1.0

Sweet!

Any video/other tutorials for ASP.Net and ReportViewer control?

I have figured out how to build a report for reportserver - I even have a
video that tells me how to use the reportviewer in a Windows app, but I need
to learn how to do the basics in an ASP.Net page, with the ReportViewer
control.
Are there any basic, step by step web pages that show this, or even better -
any videos to checkout on the web?On Jan 18, 1:02 pm, "Elmo Watson" <s...@.here.com> wrote:
> I have figured out how to build a report for reportserver - I even have a
> video that tells me how to use the reportviewer in a Windows app, but I need
> to learn how to do the basics in an ASP.Net page, with the ReportViewer
> control.
> Are there any basic, step by step web pages that show this, or even better -
> any videos to checkout on the web?
These articles might be helpful.
http://www.aspfree.com/c/a/ASP.NET/Binding-Data-to-the-ReportViewer-Control-Dynamically-in-ASPNET-20/
http://msdn2.microsoft.com/en-us/library/ms252104(VS.80).aspx
Regards,
Enrique Martinez
Sr. Software Consultant

Any MySQL book recommendations for newbie?

I just bought the book, Build Your Own Database Driven Website, by
Kevin Yank, and I'll start working on a database soon. Any other
books, etc., you can think of that a know-nothing newbie should read?
Is the book above a good one?

Thanks!
Steve HThis is a Microsoft SQL Server group so if you are looking for
recommendations on MySQL books you will probably get more help elsewhere.

Some book lists and other resources for SQLServer (not MySQL):

http://vyaskn.tripod.com/sqlbooks.htm
http://www.aspfaq.com/2423

--
David Portas
SQL Server MVP
--

Any Good SQL Server Intermediate Training Courses?

Quick question. I am in the NYC area (Westchester) and I am using Cognos DecisionStream to build my SQL Server 2000 Enterprise Data Warehouse.

I want to learn more about complex SQL, specifically for SQL Server.

What do you reccommend? Should I go for strictly an advanced SQL course, or should I go for SQL Server training.

Does anyone know of a really good site where I can find Advanced SQL training?

Also, I want to learn more about scripting and VB. Can anyone reccommend a place where I can get this beginner training.

Sorry to take up your time, but to sum up:

1. Advanced SQL training in NYC area
2. Beginner VB training in NYC area.

Cost is not necessarily an issue.

Thanks!You are asking for recommendations, which mean you want other people's opinions. I've always got at least one of those to spare!

For VB and Microsoft SQL Server, I'd recomment Quilogy (http://www.quilogy.com/). in my opinion, Alan Groh is one of the best teacher/mentor types in the business.

For the really, really interesting SQL, I'd recomment Joe Celko (http://www.celko.com/). Joe was on the committee that defined what SQL ought to do, and he has been a consultant for years teaching and helping folks figure out just what the existing SQL engines really do, especially when that deviates from the standard. If nothing else, he's fun to listen to when he discovers a new "feature" in one of the SQL dialects!

-PatP|||Thank you very much, I will look them up! I really appreciate it!|||Logon to these forums daily and look at what people are asking and try to figure the problems out...

kinda like a pop quiz every day...

Oh and read the solutions...

Do you have access to sql server and client side tools?

What do you consider "complex sql" to be?

Theta joins always give me a moment to pause...|||I consider complex SQL to be anything other than the simple select statement, like sub-queries, and transformation/alterations on fields like date conversions, etc.

Do you suggest any books with good amounts of source code and puzzles, that is up to date?|||Yeah...Celko's SQL for Smarties should blow your mind...it's not really platform specific

Ken Hendersons Book The Guru's Guids to SQL Server, Stored Procedures, XML and HTML is, and it's outstanding...AND comes with a cd loaded with code...

And there's also

http://www.sqlteam.com/store.asp