Data driven subscription problem - (Not able to see subcription tab in my report server)

Hi,
Can someone please help me in getting, Data Driven Subscription option in my Report Server.(Not able to see Subscription tab)

My Server Details
1) Operating System – Windows Server 2003, Enterprise Edition
2) SQl Server 2000 Reporting Services – Standard Edition
3) SQL Server 2000 – Enterprise Edition
4) Have Enabled Application Server, IIS, ASP, and Front Page Extensions
5) Visual Studio .net 2003

Appreciate your quick response. Please reply back.

Thanks
Mahesh

Mahesh N Raju wrote:

Hi,
Can someone please help me in getting, Data Driven Subscription option in my Report Server.(Not able to see Subscription tab)

My Server Details
1) Operating System – Windows Server 2003, Enterprise Edition
2) SQl Server 2000 Reporting Services – Standard Edition
3) SQL Server 2000 – Enterprise Edition
4) Have Enabled Application Server, IIS, ASP, and Front Page Extensions
5) Visual Studio .net 2003

Appreciate your quick response. Please reply back.

Thanks
Mahesh

Data Driven Subscription Not Available

I am trying to create a data driven subscription. However, on the
Subscriptions tab for the reports the New Data-Driven Subscription selection
is not present. Only the New Subscription selection is present. I can
create regular subscriptions but need to create a data driven subscription.
Is there something in the config file that needs changed to enable data
driven subscriptions?Do you have Standard or Enterprise. Data driven subscriptions is a
Enterprise feature.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Blaine" <Blaine@.discussions.microsoft.com> wrote in message
news:D1F3D1AB-E50E-42E3-BDC2-B7F52AED421D@.microsoft.com...
>I am trying to create a data driven subscription. However, on the
> Subscriptions tab for the reports the New Data-Driven Subscription
> selection
> is not present. Only the New Subscription selection is present. I can
> create regular subscriptions but need to create a data driven
> subscription.
> Is there something in the config file that needs changed to enable data
> driven subscriptions?|||Data driven subscriptions are only available with SQL Server Enterprise
Edition.
Are you running Standard?
"Blaine" <Blaine@.discussions.microsoft.com> wrote in message
news:D1F3D1AB-E50E-42E3-BDC2-B7F52AED421D@.microsoft.com...
>I am trying to create a data driven subscription. However, on the
> Subscriptions tab for the reports the New Data-Driven Subscription
> selection
> is not present. Only the New Subscription selection is present. I can
> create regular subscriptions but need to create a data driven
> subscription.
> Is there something in the config file that needs changed to enable data
> driven subscriptions?|||I thought I was running Enterprise everywhere but on this server it is only
the Standard edition. We are planning on upgrading to SQL Server 2005 1Q06 -
what version of it will I need to have?
Thanks for your help.
Blaine
"Bruce L-C [MVP]" wrote:
> Do you have Standard or Enterprise. Data driven subscriptions is a
> Enterprise feature.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Blaine" <Blaine@.discussions.microsoft.com> wrote in message
> news:D1F3D1AB-E50E-42E3-BDC2-B7F52AED421D@.microsoft.com...
> >I am trying to create a data driven subscription. However, on the
> > Subscriptions tab for the reports the New Data-Driven Subscription
> > selection
> > is not present. Only the New Subscription selection is present. I can
> > create regular subscriptions but need to create a data driven
> > subscription.
> > Is there something in the config file that needs changed to enable data
> > driven subscriptions?
>
>|||Data driven subscriptions is still an enterprise feature in RS 2005.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Blaine" <Blaine@.discussions.microsoft.com> wrote in message
news:3C1F63FF-EFBB-469D-9A1E-F27AE5A48165@.microsoft.com...
>I thought I was running Enterprise everywhere but on this server it is only
> the Standard edition. We are planning on upgrading to SQL Server 2005
> 1Q06 -
> what version of it will I need to have?
> Thanks for your help.
> Blaine
> "Bruce L-C [MVP]" wrote:
>> Do you have Standard or Enterprise. Data driven subscriptions is a
>> Enterprise feature.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Blaine" <Blaine@.discussions.microsoft.com> wrote in message
>> news:D1F3D1AB-E50E-42E3-BDC2-B7F52AED421D@.microsoft.com...
>> >I am trying to create a data driven subscription. However, on the
>> > Subscriptions tab for the reports the New Data-Driven Subscription
>> > selection
>> > is not present. Only the New Subscription selection is present. I can
>> > create regular subscriptions but need to create a data driven
>> > subscription.
>> > Is there something in the config file that needs changed to enable data
>> > driven subscriptions?
>>

Data being cut off on text import

I am trying to use SQL Server 2000 import/export funtion to import a
tab delimited text file. Some of the lines have upwards fo 27,000
characters in it. The first column of data is only 16 characters, the
rest in the second column. When I import it works however end up on
the largest data set to only have 8194 characters of data in the
field. I am importing the data into an NTEXT field but no joy. Any
suggestions?
Thanks.
JRHow are you determining that there are 8194 characters? Are you selecting
the data in Query Analyzer, copying it, and measuring the length? In this
case, the output is limited to 8192 characters, and does not necessarily
truly represent the data in the column. Try applying DATALENGTH() to the
column directly.
"JR" <jriker1@.yahoo.com> wrote in message
news:4d9da209-6bd6-4537-a3f9-184b6544ff49@.l1g2000hsa.googlegroups.com...
>I am trying to use SQL Server 2000 import/export funtion to import a
> tab delimited text file. Some of the lines have upwards fo 27,000
> characters in it. The first column of data is only 16 characters, the
> rest in the second column. When I import it works however end up on
> the largest data set to only have 8194 characters of data in the
> field. I am importing the data into an NTEXT field but no joy. Any
> suggestions?
> Thanks.
> JR