Showing posts with label control. Show all posts
Showing posts with label control. Show all posts

Sunday, March 11, 2012

Choose path to travel on!!

Hi there

I am up against a condition where my control flow should be divided into threads and depending on value of a variable i have to choose 1 of the threads.

Its something like

if a =1 then execute this

else execute this one.

Thanks and Regards

Rahul Kumar, Software Enggineer

You need conditional precedence constraints. This article explains them:

Introduction to Expressions on Workflow
(http://www.sqlis.com/default.aspx?306)

-Jamie

|||

Thanks a lot,

Regards

Rahul Kumar, Software Engineer

Wednesday, March 7, 2012

Checkpoints: FTP task download FTP files fails in between then what will happen?

Hi,

I have a FTP task in my control flow that download files from a FTP server. This ftp task is inside a foreach container that loops over a ADO recordset for the file name. The files that the ftp task pulls are huge. If the FTP task fails then I want the FTP task to restart and only download those files that have not been downloaded. Is this possible?

What possible configurations do I have to make to the foreach container and the filetask?

Thanks a lot in advance for your help and time.

Regards,

$wapnil

Experts!!!! any inputs on this.

Thanks in advance for your time.

Regards,

$wapnil

|||

anyone.....help!

Thanks,

$wapnil

Sunday, February 19, 2012

checking length of textbox value!

Hi

I was looking to check the length of a textbox then truncate it if it is graeter than some value and assign the that value for a textbox control in reporting service.How can i acheve this?

Thanks

This expression truncates any string in the textbox longer than 2 characters.

=Iif(Fields!FieldName.Value.ToString().Length() > 2, Fields!FieldName.Value.ToString().Substring(0,2), Fields!FieldName.Value)

You will need to change the field name to the actual field going into the textbox.

|||

I do not know who you are but I really would like to appreciate you !

Thanks a lot!

Ephi.

|||

I want to do the same thing as well as if the length of the field is shorted than the required length, I need to pad it with spaces. Can someone help with how to do that as well ?

Thanks

AY

checking length of textbox value!

Hi

I was looking to check the length of a textbox then truncate it if it is graeter than some value and assign the that value for a textbox control in reporting service.How can i acheve this?

Thanks

This expression truncates any string in the textbox longer than 2 characters.

=Iif(Fields!FieldName.Value.ToString().Length() > 2, Fields!FieldName.Value.ToString().Substring(0,2), Fields!FieldName.Value)

You will need to change the field name to the actual field going into the textbox.

|||

I do not know who you are but I really would like to appreciate you !

Thanks a lot!

Ephi.

|||

I want to do the same thing as well as if the length of the field is shorted than the required length, I need to pad it with spaces. Can someone help with how to do that as well ?

Thanks

AY

Thursday, February 16, 2012

checking for control files in SSIS

have a job that loads data from a data file into a table.

Is there a "task" that can be used to check to see if a file exists

and put error handling around it without programming ?

have you considered using the file watcher task? http://www.sqlis.com/default.aspx?23

Sunday, February 12, 2012

Checkbox

Hi,

In the reports tollbox there is no Checkbox control,In my report i want to add the checkboc control,How to add checkboc control to the toolbox.

Please help me.

Thanks in advance

I do not believe that you can do that. Are you wanting to add a check box to actual body of a report or are you wanting to use a check box to select a parameter?|||

Hi,

Thank you very much for your reply.I want to display available columns to the users,so he can select the columns he want,we have to display those selected columns in the report body.thatswhy i want to display avalable columns to user.Without checkbox how to achieve this.

Thanks inadvance

|||

Maybe use multivalue parameter with list of available report columns ? Every value have embedded checkbox and you can add default value "show all" or something like that.

Maciej

|||

Hi,

I tried in that way.I put one multivaled parameter that display all the available columns,Suppose i have the multivaled parameter named "columns" with values:Date,Empid,State.When user select date and Empid,Columns parameter returns the string in this format:'date,empid',then how we set the visibility property for the table columns based on this string.With this iam struggling.

Please help me

Thanks in advance

|||

Try this:

in your column visibility expression enter this code: "=iif(InStr(Parameters!Columns.Value,"show all") > 0 or InStr(Parameters!Columns.Value,"<this column name>") >0, true, false)"

I assumed that InStr() returns "0" or less when there is no match but better check it yourself

Maciej

Friday, February 10, 2012

check sql licence

Hi, May I know how to check what is my current sql licence installed? I've
learnt that in control panel, there is a SQL Licence setup icon which I can
check. But some of my MSSQL server don't have this icon. Can you help?
Thanks
andrewTry to run this:
select serverproperty('LicenseType')
, serverproperty('NumLicenses')
"andrew" wrote:

> Hi, May I know how to check what is my current sql licence installed? I'v
e
> learnt that in control panel, there is a SQL Licence setup icon which I ca
n
> check. But some of my MSSQL server don't have this icon. Can you help?
> Thanks
> andrew|||Hi,
The result is:
disabled, null
May I know how can I change the values?
"Andre Vigneau" wrote:
[vbcol=seagreen]
> Try to run this:
> select serverproperty('LicenseType')
> , serverproperty('NumLicenses')
>
> "andrew" wrote:
>|||andrew wrote:
> Hi,
> The result is:
> disabled, null
> May I know how can I change the values?
>
LicenceType is not "implemented" in a reliable way. There was post about
this same problem a couple weeks ago. Trying giving the ng a search on
Google.
David Gugick
Imceda Software
www.imceda.com

check sql licence

Hi, May I know how to check what is my current sql licence installed? I've
learnt that in control panel, there is a SQL Licence setup icon which I can
check. But some of my MSSQL server don't have this icon. Can you help?
Thanks
andrew
Try to run this:
select serverproperty('LicenseType')
, serverproperty('NumLicenses')
"andrew" wrote:

> Hi, May I know how to check what is my current sql licence installed? I've
> learnt that in control panel, there is a SQL Licence setup icon which I can
> check. But some of my MSSQL server don't have this icon. Can you help?
> Thanks
> andrew
|||Hi,
The result is:
disabled, null
May I know how can I change the values?
"Andre Vigneau" wrote:
[vbcol=seagreen]
> Try to run this:
> select serverproperty('LicenseType')
> , serverproperty('NumLicenses')
>
> "andrew" wrote:
|||andrew wrote:
> Hi,
> The result is:
> disabled, null
> May I know how can I change the values?
>
LicenceType is not "implemented" in a reliable way. There was post about
this same problem a couple weeks ago. Trying giving the ng a search on
Google.
David Gugick
Imceda Software
www.imceda.com

check sql licence

Hi, May I know how to check what is my current sql licence installed? I've
learnt that in control panel, there is a SQL Licence setup icon which I can
check. But some of my MSSQL server don't have this icon. Can you help?
Thanks
andrewTry to run this:
select serverproperty('LicenseType')
, serverproperty('NumLicenses')
"andrew" wrote:
> Hi, May I know how to check what is my current sql licence installed? I've
> learnt that in control panel, there is a SQL Licence setup icon which I can
> check. But some of my MSSQL server don't have this icon. Can you help?
> Thanks
> andrew|||Hi,
The result is:
disabled, null
May I know how can I change the values?
"Andre Vigneau" wrote:
> Try to run this:
> select serverproperty('LicenseType')
> , serverproperty('NumLicenses')
>
> "andrew" wrote:
> > Hi, May I know how to check what is my current sql licence installed? I've
> > learnt that in control panel, there is a SQL Licence setup icon which I can
> > check. But some of my MSSQL server don't have this icon. Can you help?
> >
> > Thanks
> > andrew|||andrew wrote:
> Hi,
> The result is:
> disabled, null
> May I know how can I change the values?
>
LicenceType is not "implemented" in a reliable way. There was post about
this same problem a couple weeks ago. Trying giving the ng a search on
Google.
--
David Gugick
Imceda Software
www.imceda.com