Showing posts with label dynamically. Show all posts
Showing posts with label dynamically. Show all posts

Sunday, March 25, 2012

Changing Chart with dynamically

Hi,

I have a chart which gets generated dynamically for as many months as specified in the front end.But every time the width of the chart remains constant.How do i make it change as per the No: of months to be displayed?

One way of doing this is to apply an approach described in this related thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=369675&SiteID=1

-- Robert

Wednesday, March 7, 2012

Change the File Name in File connection Manager

Hi,

How can I dynamically change the file name in File connection Manager in SSIS package?

I can do this in SQL 2000 but how to achieve the same thing in SQL 2005. I have to generate 10 different excel file and just need to change the file name in connection manager for excel file

Thanks

Shafiq

You'll need to put an expression on the ConnectionString property of the flat file connection manager. Step 3 in here demos this: http://blogs.conchango.com/jamiethomson/archive/2005/05/30/1489.aspx

In fact, that whole post maps pretty well to what you seem to want to do.

-Jamie

|||

Jamie,

Your article is good, but some how the expression tab of For Each loop does not have connectionstring property in the dropdown list.

I am using Excel Connection Manager for my files.

Please Guide

|||

ConnectionString is a property of the Flat File Connection Manager. Not of the ForEach loop.

-Jamie

Change the chart size dynamically

Hi All,
I have a small problem ,i am not able to change the size of the chart and the bar in the bar chart dynamically.

The only items that grow horizontally are matrix and chart. Some people have created reports with multple copies of the chart and had a flag that hid all but one of them. Also, custom report items will have the ability to grow dynamically. The width of the bars in the chart are determined based on the number of points.|||thanks for the reply
but how to grow the chart horizantally.

Friday, February 24, 2012

Change SQL Collation programmatically

hi all...

how can i change the collation of a table that i dynamically created during runtime??

i wanna change the default collation to Arabic

You start with Nvarchar, Nchar, NText, Nvarchar (max) and Nchar (max) columns then you use collation precedence that is you add the collation of the column in your DML(data manipulation langauge) and that is the collation posted below. I think you should also do column level collation. All you need is covered in the links below. Hope this helps.

146

nocase.256

Dictionary order, case-insensitive

SQL_Latin1_General_Cp1256_CI_AS_KI_WI

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

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


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

|||

i created a table for collating a column with "Tamil Language" in sqlserver 2005

CREATE TABLE jobs1 ( job_id text IDENTITY(1,1) PRIMARY KEY CLUSTERED, job_desc varchar(50) COLLATE Indic_General_90 NOT NULL DEFAULT 'New Position - title not formalized yet', )

but it throws an error "

Msg 448, Level 16, State 2, Line 7

Invalid collation 'Indic_General_90'."

can any one help me.should i stall any new collation in sqlserver