I am creating table in sql server 2005, by using the below script,but it
showing "syntax error near (" The below script is created from generate
script option of sql) ,I ll apprecite the solution asap,Thanx guys
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserRoles](
[UserRoleID] [int] IDENTITY(1,1) NOT NULL,
[UserID] [int] NOT NULL,
[RoleID] [int] NOT NULL,
[ExpiryDate] [datetime] NULL,
[IsTrialUsed] [bit] NULL,
[EffectiveDate] [datetime] NULL,
CONSTRAINT [PK_UserRoles] PRIMARY KEY CLUSTERED
(
[UserRoleID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]I assume that you by "it showing "syntax error near ("" Mean that when you execute the script from
some tool you get that error message? If so, can you specify what tool you use to execute the script
and against what version of SQL Server. Also, make sure you do not mark any text when you execute
it, or that you do mark only the text you want to be executed.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Rupesh Mondal" <RupeshMondal@.discussions.microsoft.com> wrote in message
news:849EDFC3-1CCB-4BDA-B338-E707C2B5F488@.microsoft.com...
>I am creating table in sql server 2005, by using the below script,but it
> showing "syntax error near (" The below script is created from generate
> script option of sql) ,I ll apprecite the solution asap,Thanx guys
> SET ANSI_NULLS ON
> GO
> SET QUOTED_IDENTIFIER ON
> GO
> CREATE TABLE [dbo].[UserRoles](
> [UserRoleID] [int] IDENTITY(1,1) NOT NULL,
> [UserID] [int] NOT NULL,
> [RoleID] [int] NOT NULL,
> [ExpiryDate] [datetime] NULL,
> [IsTrialUsed] [bit] NULL,
> [EffectiveDate] [datetime] NULL,
> CONSTRAINT [PK_UserRoles] PRIMARY KEY CLUSTERED
> (
> [UserRoleID] ASC
> )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY => OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
> ) ON [PRIMARY]|||I am not using any kind of tool, i am executing it from query analyzer of sql
server 2005 standard ediion
"Tibor Karaszi" wrote:
> I assume that you by "it showing "syntax error near ("" Mean that when you execute the script from
> some tool you get that error message? If so, can you specify what tool you use to execute the script
> and against what version of SQL Server. Also, make sure you do not mark any text when you execute
> it, or that you do mark only the text you want to be executed.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Rupesh Mondal" <RupeshMondal@.discussions.microsoft.com> wrote in message
> news:849EDFC3-1CCB-4BDA-B338-E707C2B5F488@.microsoft.com...
> >I am creating table in sql server 2005, by using the below script,but it
> > showing "syntax error near (" The below script is created from generate
> > script option of sql) ,I ll apprecite the solution asap,Thanx guys
> >
> > SET ANSI_NULLS ON
> > GO
> > SET QUOTED_IDENTIFIER ON
> > GO
> > CREATE TABLE [dbo].[UserRoles](
> > [UserRoleID] [int] IDENTITY(1,1) NOT NULL,
> > [UserID] [int] NOT NULL,
> > [RoleID] [int] NOT NULL,
> > [ExpiryDate] [datetime] NULL,
> > [IsTrialUsed] [bit] NULL,
> > [EffectiveDate] [datetime] NULL,
> > CONSTRAINT [PK_UserRoles] PRIMARY KEY CLUSTERED
> > (
> > [UserRoleID] ASC
> > )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY => > OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
> > ) ON [PRIMARY]
>
>|||>I am not using any kind of tool, i am executing it from query analyzer of sql
> server 2005 standard ediion
Then that tool would be query analyzer (or perhaps you meant SQL Server Management Studio).
Anyhow, I executed the code you posted and it worked just fine. I'm also on SQL Server 2005. My
guess is that you by mistake maked a part of the text so that only that text were submitted to sQL
Server.-
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Rupesh Mondal" <RupeshMondal@.discussions.microsoft.com> wrote in message
news:5A056BBA-0AC2-4BC4-93A3-79D1FD798AC4@.microsoft.com...
>I am not using any kind of tool, i am executing it from query analyzer of sql
> server 2005 standard ediion
> "Tibor Karaszi" wrote:
>> I assume that you by "it showing "syntax error near ("" Mean that when you execute the script
>> from
>> some tool you get that error message? If so, can you specify what tool you use to execute the
>> script
>> and against what version of SQL Server. Also, make sure you do not mark any text when you execute
>> it, or that you do mark only the text you want to be executed.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Rupesh Mondal" <RupeshMondal@.discussions.microsoft.com> wrote in message
>> news:849EDFC3-1CCB-4BDA-B338-E707C2B5F488@.microsoft.com...
>> >I am creating table in sql server 2005, by using the below script,but it
>> > showing "syntax error near (" The below script is created from generate
>> > script option of sql) ,I ll apprecite the solution asap,Thanx guys
>> >
>> > SET ANSI_NULLS ON
>> > GO
>> > SET QUOTED_IDENTIFIER ON
>> > GO
>> > CREATE TABLE [dbo].[UserRoles](
>> > [UserRoleID] [int] IDENTITY(1,1) NOT NULL,
>> > [UserID] [int] NOT NULL,
>> > [RoleID] [int] NOT NULL,
>> > [ExpiryDate] [datetime] NULL,
>> > [IsTrialUsed] [bit] NULL,
>> > [EffectiveDate] [datetime] NULL,
>> > CONSTRAINT [PK_UserRoles] PRIMARY KEY CLUSTERED
>> > (
>> > [UserRoleID] ASC
>> > )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY =>> > OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
>> > ) ON [PRIMARY]
>>|||Another posibility is that the server/instance you are running this against
is SQL 2000, not SQL 2005. The syntax you are usingis only valid on SSQL
2005. Try running
Select ServerProperty('ProductVersion')
If it returns a value where the first digit is 8, like
8.00.2039
then it is SQL 2000 and that is your problem.
But if it returns a value where the first digit is 8, like
9.00.3042.00
then it is SQL2005 and my guess is incorrect.
But if it is SQL 2000, then the entire clause WITH (...) is not valid syntax
and should be removed.
Tom
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%2393tq$SeIHA.3368@.TK2MSFTNGP02.phx.gbl...
> >I am not using any kind of tool, i am executing it from query analyzer of
> >sql
>> server 2005 standard ediion
> Then that tool would be query analyzer (or perhaps you meant SQL Server
> Management Studio).
> Anyhow, I executed the code you posted and it worked just fine. I'm also
> on SQL Server 2005. My guess is that you by mistake maked a part of the
> text so that only that text were submitted to sQL Server.-
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Rupesh Mondal" <RupeshMondal@.discussions.microsoft.com> wrote in message
> news:5A056BBA-0AC2-4BC4-93A3-79D1FD798AC4@.microsoft.com...
>>I am not using any kind of tool, i am executing it from query analyzer of
>>sql
>> server 2005 standard ediion
>> "Tibor Karaszi" wrote:
>> I assume that you by "it showing "syntax error near ("" Mean that when
>> you execute the script from
>> some tool you get that error message? If so, can you specify what tool
>> you use to execute the script
>> and against what version of SQL Server. Also, make sure you do not mark
>> any text when you execute
>> it, or that you do mark only the text you want to be executed.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Rupesh Mondal" <RupeshMondal@.discussions.microsoft.com> wrote in
>> message
>> news:849EDFC3-1CCB-4BDA-B338-E707C2B5F488@.microsoft.com...
>> >I am creating table in sql server 2005, by using the below script,but
>> >it
>> > showing "syntax error near (" The below script is created from
>> > generate
>> > script option of sql) ,I ll apprecite the solution asap,Thanx guys
>> >
>> > SET ANSI_NULLS ON
>> > GO
>> > SET QUOTED_IDENTIFIER ON
>> > GO
>> > CREATE TABLE [dbo].[UserRoles](
>> > [UserRoleID] [int] IDENTITY(1,1) NOT NULL,
>> > [UserID] [int] NOT NULL,
>> > [RoleID] [int] NOT NULL,
>> > [ExpiryDate] [datetime] NULL,
>> > [IsTrialUsed] [bit] NULL,
>> > [EffectiveDate] [datetime] NULL,
>> > CONSTRAINT [PK_UserRoles] PRIMARY KEY CLUSTERED
>> > (
>> > [UserRoleID] ASC
>> > )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY
>> > =>> > OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
>> > ) ON [PRIMARY]
>>
>|||Thanks, u r correct,but is there any other way, means if i can change any
configuration in sql server 2005 so that it works, or any other way or should
i uninstall sql 2000
Thank u
"Tom Cooper" wrote:
> Another posibility is that the server/instance you are running this against
> is SQL 2000, not SQL 2005. The syntax you are usingis only valid on SSQL
> 2005. Try running
> Select ServerProperty('ProductVersion')
> If it returns a value where the first digit is 8, like
> 8.00.2039
> then it is SQL 2000 and that is your problem.
> But if it returns a value where the first digit is 8, like
> 9.00.3042.00
> then it is SQL2005 and my guess is incorrect.
> But if it is SQL 2000, then the entire clause WITH (...) is not valid syntax
> and should be removed.
> Tom
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:%2393tq$SeIHA.3368@.TK2MSFTNGP02.phx.gbl...
> > >I am not using any kind of tool, i am executing it from query analyzer of
> > >sql
> >> server 2005 standard ediion
> >
> > Then that tool would be query analyzer (or perhaps you meant SQL Server
> > Management Studio).
> >
> > Anyhow, I executed the code you posted and it worked just fine. I'm also
> > on SQL Server 2005. My guess is that you by mistake maked a part of the
> > text so that only that text were submitted to sQL Server.-
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://sqlblog.com/blogs/tibor_karaszi
> >
> >
> > "Rupesh Mondal" <RupeshMondal@.discussions.microsoft.com> wrote in message
> > news:5A056BBA-0AC2-4BC4-93A3-79D1FD798AC4@.microsoft.com...
> >>I am not using any kind of tool, i am executing it from query analyzer of
> >>sql
> >> server 2005 standard ediion
> >>
> >> "Tibor Karaszi" wrote:
> >>
> >> I assume that you by "it showing "syntax error near ("" Mean that when
> >> you execute the script from
> >> some tool you get that error message? If so, can you specify what tool
> >> you use to execute the script
> >> and against what version of SQL Server. Also, make sure you do not mark
> >> any text when you execute
> >> it, or that you do mark only the text you want to be executed.
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://sqlblog.com/blogs/tibor_karaszi
> >>
> >>
> >> "Rupesh Mondal" <RupeshMondal@.discussions.microsoft.com> wrote in
> >> message
> >> news:849EDFC3-1CCB-4BDA-B338-E707C2B5F488@.microsoft.com...
> >> >I am creating table in sql server 2005, by using the below script,but
> >> >it
> >> > showing "syntax error near (" The below script is created from
> >> > generate
> >> > script option of sql) ,I ll apprecite the solution asap,Thanx guys
> >> >
> >> > SET ANSI_NULLS ON
> >> > GO
> >> > SET QUOTED_IDENTIFIER ON
> >> > GO
> >> > CREATE TABLE [dbo].[UserRoles](
> >> > [UserRoleID] [int] IDENTITY(1,1) NOT NULL,
> >> > [UserID] [int] NOT NULL,
> >> > [RoleID] [int] NOT NULL,
> >> > [ExpiryDate] [datetime] NULL,
> >> > [IsTrialUsed] [bit] NULL,
> >> > [EffectiveDate] [datetime] NULL,
> >> > CONSTRAINT [PK_UserRoles] PRIMARY KEY CLUSTERED
> >> > (
> >> > [UserRoleID] ASC
> >> > )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY
> >> > => >> > OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
> >> > ) ON [PRIMARY]
> >>
> >>
> >>
> >
> >
>
>|||If you use the SSMS scripts wizard to generate the script for the table, you
can tell it to generate a script that is compatable with SQL 2000. On the
Choose Scripts Options page there is an option named Script for Server
Version. Set that to SQL 2000 and it will generate a script that will run
on SQL 2000. Of course, if you are using features that are new for SQL
2005, those features won't be included.
Tom
"Rupesh Mondal" <RupeshMondal@.discussions.microsoft.com> wrote in message
news:8642EF7D-6437-4C7E-8B3F-29A22B330F7A@.microsoft.com...
> Thanks, u r correct,but is there any other way, means if i can change any
> configuration in sql server 2005 so that it works, or any other way or
> should
> i uninstall sql 2000
> Thank u
> "Tom Cooper" wrote:
>> Another posibility is that the server/instance you are running this
>> against
>> is SQL 2000, not SQL 2005. The syntax you are usingis only valid on SSQL
>> 2005. Try running
>> Select ServerProperty('ProductVersion')
>> If it returns a value where the first digit is 8, like
>> 8.00.2039
>> then it is SQL 2000 and that is your problem.
>> But if it returns a value where the first digit is 8, like
>> 9.00.3042.00
>> then it is SQL2005 and my guess is incorrect.
>> But if it is SQL 2000, then the entire clause WITH (...) is not valid
>> syntax
>> and should be removed.
>> Tom
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
>> in
>> message news:%2393tq$SeIHA.3368@.TK2MSFTNGP02.phx.gbl...
>> > >I am not using any kind of tool, i am executing it from query analyzer
>> > >of
>> > >sql
>> >> server 2005 standard ediion
>> >
>> > Then that tool would be query analyzer (or perhaps you meant SQL Server
>> > Management Studio).
>> >
>> > Anyhow, I executed the code you posted and it worked just fine. I'm
>> > also
>> > on SQL Server 2005. My guess is that you by mistake maked a part of the
>> > text so that only that text were submitted to sQL Server.-
>> > --
>> > Tibor Karaszi, SQL Server MVP
>> > http://www.karaszi.com/sqlserver/default.asp
>> > http://sqlblog.com/blogs/tibor_karaszi
>> >
>> >
>> > "Rupesh Mondal" <RupeshMondal@.discussions.microsoft.com> wrote in
>> > message
>> > news:5A056BBA-0AC2-4BC4-93A3-79D1FD798AC4@.microsoft.com...
>> >>I am not using any kind of tool, i am executing it from query analyzer
>> >>of
>> >>sql
>> >> server 2005 standard ediion
>> >>
>> >> "Tibor Karaszi" wrote:
>> >>
>> >> I assume that you by "it showing "syntax error near ("" Mean that
>> >> when
>> >> you execute the script from
>> >> some tool you get that error message? If so, can you specify what
>> >> tool
>> >> you use to execute the script
>> >> and against what version of SQL Server. Also, make sure you do not
>> >> mark
>> >> any text when you execute
>> >> it, or that you do mark only the text you want to be executed.
>> >>
>> >> --
>> >> Tibor Karaszi, SQL Server MVP
>> >> http://www.karaszi.com/sqlserver/default.asp
>> >> http://sqlblog.com/blogs/tibor_karaszi
>> >>
>> >>
>> >> "Rupesh Mondal" <RupeshMondal@.discussions.microsoft.com> wrote in
>> >> message
>> >> news:849EDFC3-1CCB-4BDA-B338-E707C2B5F488@.microsoft.com...
>> >> >I am creating table in sql server 2005, by using the below
>> >> >script,but
>> >> >it
>> >> > showing "syntax error near (" The below script is created from
>> >> > generate
>> >> > script option of sql) ,I ll apprecite the solution asap,Thanx guys
>> >> >
>> >> > SET ANSI_NULLS ON
>> >> > GO
>> >> > SET QUOTED_IDENTIFIER ON
>> >> > GO
>> >> > CREATE TABLE [dbo].[UserRoles](
>> >> > [UserRoleID] [int] IDENTITY(1,1) NOT NULL,
>> >> > [UserID] [int] NOT NULL,
>> >> > [RoleID] [int] NOT NULL,
>> >> > [ExpiryDate] [datetime] NULL,
>> >> > [IsTrialUsed] [bit] NULL,
>> >> > [EffectiveDate] [datetime] NULL,
>> >> > CONSTRAINT [PK_UserRoles] PRIMARY KEY CLUSTERED
>> >> > (
>> >> > [UserRoleID] ASC
>> >> > )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,
>> >> > IGNORE_DUP_KEY
>> >> > =>> >> > OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
>> >> > ) ON [PRIMARY]
>> >>
>> >>
>> >>
>> >
>> >
>>
Showing posts with label showing. Show all posts
Showing posts with label showing. Show all posts
Tuesday, March 27, 2012
Sunday, February 19, 2012
Create DTS Package in SQL server 2005 (Ver:9.0.1116).
Hi,
I am using SQL server 2005 (Ver:9.0.1116).
I am unable to find how to create a DTS package from Sql Server Management Studio.
It is showing "DTS 2000 Packages" in the "Object Explorer" of the Sql Server Management Studio.
I want to know how to start a Integration services in Yukon.
As,the DTS 2000 Packages in the Services tree does not Open nor can Import any package.
I am using SQL server 2005 (Ver:9.0.1116).
I am unable to find how to create a DTS package from Sql Server Management Studio.
It is showing "DTS 2000 Packages" in the "Object Explorer" of the Sql Server Management Studio.
I want to know how to start a Integration services in Yukon.
As,the DTS 2000 Packages in the Services tree does not Open nor can Import any package.
Thanks!
TechFreakYou need to use the "Business Intelligence Development Studio" to build SQL Server Integration Services (SSIS) packages, not SQL Server management Studio.
Go to: Start-->Programs-->Microsoft SQL Server 2005-->SQL Server Business Intelligence Development Studio
This is all in the documentation (Books Online) so look in there, and in the tutorials, to see how to go about building your first package.
-Jamie|||Yeah Jamie,
Thanx for the concern..
But using "Business Intelligence Development Studio" also it shows an error message as below:
"Could not load file or assembly 'Microsoft.DataTransformationServices.Wizards' or one of its dependencies.The System cannot find the file specified"
In the Yukon tutorials there is no info provided for Integration Services.
-TechFreak|||
Does anybody has a solution for this? I am getting the same error. I have Visual Studio 2005, SQL Server 2005 (Developer Edition) on Windows 2003 machine. I was trying to create an Integration Services Project, but getting the above error. Please help!
Thanks
|||even i am getting the same error, any help regarding this ?
Thanks
http://techyfreak.blogspot.com
|||You have to be sure that SQL Server Integration Services installed on your PC.
To check go Help -> About Microsoft Visual Studio.
I got the same error after reinstalled MS Visual Studio 2005 from default location
C:/Program Files/Microsoft Visual Studio 8 to D:/Program Files/Microsoft Visual Studio 8
due to insufficient disk space on C.
SQL Server Integration Services just disappeared from installed list.
I was trying repairing VS from CD. Did not help.
I had to uninstall VS from D to C drive again and leave MSDN on D. After I could start Integration project again.
Why this happened I do not know. May be because MS SQL Server 2005 was still on C drive. Not sure.
I hope this help.
Create DTS Package in SQL server 2005 (Ver:9.0.1116).
Hi,
I am using SQL server 2005 (Ver:9.0.1116).
I am unable to find how to create a DTS package from Sql Server Management Studio.
It is showing "DTS 2000 Packages" in the "Object Explorer" of the Sql Server Management Studio.
I want to know how to start a Integration services in Yukon.
As,the DTS 2000 Packages in the Services tree does not Open nor can Import any package.
I am using SQL server 2005 (Ver:9.0.1116).
I am unable to find how to create a DTS package from Sql Server Management Studio.
It is showing "DTS 2000 Packages" in the "Object Explorer" of the Sql Server Management Studio.
I want to know how to start a Integration services in Yukon.
As,the DTS 2000 Packages in the Services tree does not Open nor can Import any package.
Thanks!
TechFreakYou need to use the "Business Intelligence Development Studio" to build SQL Server Integration Services (SSIS) packages, not SQL Server management Studio.
Go to: Start-->Programs-->Microsoft SQL Server 2005-->SQL Server Business Intelligence Development Studio
This is all in the documentation (Books Online) so look in there, and in the tutorials, to see how to go about building your first package.
-Jamie|||Yeah Jamie,
Thanx for the concern..
But using "Business Intelligence Development Studio" also it shows an error message as below:
"Could not load file or assembly 'Microsoft.DataTransformationServices.Wizards' or one of its dependencies.The System cannot find the file specified"
In the Yukon tutorials there is no info provided for Integration Services.
-TechFreak|||
Does anybody has a solution for this? I am getting the same error. I have Visual Studio 2005, SQL Server 2005 (Developer Edition) on Windows 2003 machine. I was trying to create an Integration Services Project, but getting the above error. Please help!
Thanks
|||even i am getting the same error, any help regarding this ?
Thanks
http://techyfreak.blogspot.com
|||You have to be sure that SQL Server Integration Services installed on your PC.
To check go Help -> About Microsoft Visual Studio.
I got the same error after reinstalled MS Visual Studio 2005 from default location
C:/Program Files/Microsoft Visual Studio 8 to D:/Program Files/Microsoft Visual Studio 8
due to insufficient disk space on C.
SQL Server Integration Services just disappeared from installed list.
I was trying repairing VS from CD. Did not help.
I had to uninstall VS from D to C drive again and leave MSDN on D. After I could start Integration project again.
Why this happened I do not know. May be because MS SQL Server 2005 was still on C drive. Not sure.
I hope this help.|||Try Start>Run> DTSwizard
Create DTS Package in SQL server 2005 (Ver:9.0.1116).
Hi,
I am using SQL server 2005 (Ver:9.0.1116).
I am unable to find how to create a DTS package from Sql Server Management Studio.
It is showing "DTS 2000 Packages" in the "Object Explorer" of the Sql Server Management Studio.
I want to know how to start a Integration services in Yukon.
As,the DTS 2000 Packages in the Services tree does not Open nor can Import any package.
To check go Help -> About Microsoft Visual Studio.
I am using SQL server 2005 (Ver:9.0.1116).
I am unable to find how to create a DTS package from Sql Server Management Studio.
It is showing "DTS 2000 Packages" in the "Object Explorer" of the Sql Server Management Studio.
I want to know how to start a Integration services in Yukon.
As,the DTS 2000 Packages in the Services tree does not Open nor can Import any package.
Thanks!
TechFreak
You need to use the "Business Intelligence Development Studio" to build SQL Server Integration Services (SSIS) packages, not SQL Server management Studio.
Go to: Start-->Programs-->Microsoft SQL Server 2005-->SQL Server Business Intelligence Development Studio
This is all in the documentation (Books Online) so look in there, and in the tutorials, to see how to go about building your first package.
-Jamie|||Yeah Jamie,
Thanx for the concern..
But using "Business Intelligence Development Studio" also it shows an error message as below:
"Could not load file or assembly 'Microsoft.DataTransformationServices.Wizards' or one of its dependencies.The System cannot find the file specified"
In the Yukon tutorials there is no info provided for Integration Services.
-TechFreak|||
Does anybody has a solution for this? I am getting the same error. I have Visual Studio 2005, SQL Server 2005 (Developer Edition) on Windows 2003 machine. I was trying to create an Integration Services Project, but getting the above error. Please help!
Thanks
|||even i am getting the same error, any help regarding this ?
Thanks
http://techyfreak.blogspot.com
|||You have to be sure that SQL Server Integration Services installed on your PC.To check go Help -> About Microsoft Visual Studio.
I got the same error after reinstalled MS Visual Studio 2005 from default location
C:/Program Files/Microsoft Visual Studio 8 to D:/Program Files/Microsoft Visual Studio 8
due to insufficient disk space on C.
SQL Server Integration Services just disappeared from installed list.
I was trying repairing VS from CD. Did not help.
I had to uninstall VS from D to C drive again and leave MSDN on D. After I could start Integration project again.
Why this happened I do not know. May be because MS SQL Server 2005 was still on C drive. Not sure.
I hope this help.
Create DTS Package in SQL server 2005 (Ver:9.0.1116).
Hi,
I am using SQL server 2005 (Ver:9.0.1116).
I am unable to find how to create a DTS package from Sql Server Management Studio.
It is showing "DTS 2000 Packages" in the "Object Explorer" of the Sql Server Management Studio.
I want to know how to start a Integration services in Yukon.
As,the DTS 2000 Packages in the Services tree does not Open nor can Import any package.
To check go Help -> About Microsoft Visual Studio.
I am using SQL server 2005 (Ver:9.0.1116).
I am unable to find how to create a DTS package from Sql Server Management Studio.
It is showing "DTS 2000 Packages" in the "Object Explorer" of the Sql Server Management Studio.
I want to know how to start a Integration services in Yukon.
As,the DTS 2000 Packages in the Services tree does not Open nor can Import any package.
Thanks!
TechFreak
You need to use the "Business Intelligence Development Studio" to build SQL Server Integration Services (SSIS) packages, not SQL Server management Studio.
Go to: Start-->Programs-->Microsoft SQL Server 2005-->SQL Server Business Intelligence Development Studio
This is all in the documentation (Books Online) so look in there, and in the tutorials, to see how to go about building your first package.
-Jamie|||Yeah Jamie,
Thanx for the concern..
But using "Business Intelligence Development Studio" also it shows an error message as below:
"Could not load file or assembly 'Microsoft.DataTransformationServices.Wizards' or one of its dependencies.The System cannot find the file specified"
In the Yukon tutorials there is no info provided for Integration Services.
-TechFreak|||
Does anybody has a solution for this? I am getting the same error. I have Visual Studio 2005, SQL Server 2005 (Developer Edition) on Windows 2003 machine. I was trying to create an Integration Services Project, but getting the above error. Please help!
Thanks
|||even i am getting the same error, any help regarding this ?
Thanks
http://techyfreak.blogspot.com
|||You have to be sure that SQL Server Integration Services installed on your PC.To check go Help -> About Microsoft Visual Studio.
I got the same error after reinstalled MS Visual Studio 2005 from default location
C:/Program Files/Microsoft Visual Studio 8 to D:/Program Files/Microsoft Visual Studio 8
due to insufficient disk space on C.
SQL Server Integration Services just disappeared from installed list.
I was trying repairing VS from CD. Did not help.
I had to uninstall VS from D to C drive again and leave MSDN on D. After I could start Integration project again.
Why this happened I do not know. May be because MS SQL Server 2005 was still on C drive. Not sure.
I hope this help.
Subscribe to:
Posts (Atom)