The correct driver name is "Provider = SQLNCLI" for dot net native driver for sql server.

Instead of using connection string, put directly in the open() method.

con.Open("Provider = SQLNCLI;Data Source...

The thing you are looking for is the C# code to convert to int

"select fname, lname, email from directory where admit_term < '" & cint(year(date))-3 & "01'"

You should write this...

In my view populating *ALL* values to Dim Time will degrade your cube processing and data viewing from cube. Also its a good practise for keeping a biggest date as...

A workaround ... top of my head, you could have a WMI task for clearing the Event Log as per your requirments. I'll get back to you with something more,...

Well the problem is with the security context and connection pooling. In the current design, after an application role is enabled on a client connection to SQL Server, you cannot...

Go to "SQL Server Agent" ... can be found in Database sever tree of you database in Server Management Studio. Expand it. You'll find a folder 'Jobs' ... expand that...

Well Shahab I have exactly this thing going on my project.

But for the sake of scalibility and options for re-runs and late / early arriving data. I download oracle data...

Simple test ...

declare @fp varchar(10)

set @fp = 'dba      ';

select len(@fp)

set @fp = '   dba   ';

select len(@fp)

set @fp = '   dba   .';

select len(@fp)

Verdict : in varchars leading spaces are neglected.

If you need hostname in the sql server ... try host_name() function

syntax:

Select @fp = Host_name()

I hope I helped.

Basic case example ... check the output of this script ...

declare @fp int;

set @fp = -1;

select  case @fp

 when -1 then 'NEW'

 else ''

 end

set @fp = @fp+1;

select  case @fp

 when -1 then 'NEW'

 else...

Thanks

I not sure how much its applicable in your case but ... I think what you can do is create a command to create / drop the table and use...

Hey Sergity,

What does this "N" does to the sctrings ... i have seen some of these Ns when calling a system utilities also. Is this is a UNICODE marker of somekind...