DTS not able to open

Hi experts,
i have faced one issue with DTS, my office SQL server is 2000 x86
version, but my labtop using SQL Server managment studio, when i try
to expend the office SQL DTS package, which show me "this package
cannot be edited" and the following msg is "SQL server 2005 DTS
Designer components are required to edit DTS packages", "Install the
special Web download, SQL Server 2000 DTS designer components to use
this feature". however my co-worker are able to open, this is
something special , and my SQL studio setting almost same as him.
my labtop detail:
Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00
(xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 7.0.5730.13
Microsoft .NET Framework 2.0.50727.832
Operating System 5.1.2600
pls advise, many thanks
Hi
Check out the information on
http://technet.microsoft.com/en-us/library/ms143706.aspx for more
information. If you need to edit a DTS package you will need to download the
Microsoft SQL Server 2000 DTS Designer Components from the features pack
http://www.microsoft.com/downloads/details.aspx?FamilyID=50b97994-8453-4998-8226-fa42ec403d17
John
"XJ" wrote:

> Hi experts,
> i have faced one issue with DTS, my office SQL server is 2000 x86
> version, but my labtop using SQL Server managment studio, when i try
> to expend the office SQL DTS package, which show me "this package
> cannot be edited" and the following msg is "SQL server 2005 DTS
> Designer components are required to edit DTS packages", "Install the
> special Web download, SQL Server 2000 DTS designer components to use
> this feature". however my co-worker are able to open, this is
> something special , and my SQL studio setting almost same as him.
> my labtop detail:
> Microsoft SQL Server Management Studio 9.00.3042.00
> Microsoft Analysis Services Client Tools 2005.090.3042.00
> Microsoft Data Access Components (MDAC) 2000.085.1117.00
> (xpsp_sp2_rtm.040803-2158)
> Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
> Microsoft Internet Explorer 7.0.5730.13
> Microsoft .NET Framework 2.0.50727.832
> Operating System 5.1.2600
>
> pls advise, many thanks
>

DTS not able to open

Hi experts,
i have faced one issue with DTS, my office SQL server is 2000 x86
version, but my labtop using SQL Server managment studio, when i try
to expend the office SQL DTS package, which show me "this package
cannot be edited" and the following msg is "SQL server 2005 DTS
Designer components are required to edit DTS packages", "Install the
special Web download, SQL Server 2000 DTS designer components to use
this feature". however my co-worker are able to open, this is
something special , and my SQL studio setting almost same as him.
my labtop detail:
Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00
(xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 7.0.5730.13
Microsoft .NET Framework 2.0.50727.832
Operating System 5.1.2600
pls advise, many thanksHi
Check out the information on
http://technet.microsoft.com/en-us/library/ms143706.aspx for more
information. If you need to edit a DTS package you will need to download the
Microsoft SQL Server 2000 DTS Designer Components from the features pac
http://www.microsoft.com/downloads/details.aspx?FamilyID=50b97994-8453-4998-8226-fa42ec403d17
John
"XJ" wrote:
> Hi experts,
> i have faced one issue with DTS, my office SQL server is 2000 x86
> version, but my labtop using SQL Server managment studio, when i try
> to expend the office SQL DTS package, which show me "this package
> cannot be edited" and the following msg is "SQL server 2005 DTS
> Designer components are required to edit DTS packages", "Install the
> special Web download, SQL Server 2000 DTS designer components to use
> this feature". however my co-worker are able to open, this is
> something special , and my SQL studio setting almost same as him.
> my labtop detail:
> Microsoft SQL Server Management Studio 9.00.3042.00
> Microsoft Analysis Services Client Tools 2005.090.3042.00
> Microsoft Data Access Components (MDAC) 2000.085.1117.00
> (xpsp_sp2_rtm.040803-2158)
> Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
> Microsoft Internet Explorer 7.0.5730.13
> Microsoft .NET Framework 2.0.50727.832
> Operating System 5.1.2600
>
> pls advise, many thanks
>

DTS not able to open

Hi experts,
i have faced one issue with DTS, my office SQL server is 2000 x86
version, but my labtop using SQL Server managment studio, when i try
to expend the office SQL DTS package, which show me "this package
cannot be edited" and the following msg is "SQL server 2005 DTS
Designer components are required to edit DTS packages", "Install the
special Web download, SQL Server 2000 DTS designer components to use
this feature". however my co-worker are able to open, this is
something special , and my SQL studio setting almost same as him.
my labtop detail:
Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00
(xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 7.0.5730.13
Microsoft .NET Framework 2.0.50727.832
Operating System 5.1.2600
pls advise, many thanksHi
Check out the information on
http://technet.microsoft.com/en-us/...y/ms143706.aspx for more
information. If you need to edit a DTS package you will need to download the
Microsoft SQL Server 2000 DTS Designer Components from the features pack
http://www.microsoft.com/downloads/.../>
a42ec403d17
John
"XJ" wrote:

> Hi experts,
> i have faced one issue with DTS, my office SQL server is 2000 x86
> version, but my labtop using SQL Server managment studio, when i try
> to expend the office SQL DTS package, which show me "this package
> cannot be edited" and the following msg is "SQL server 2005 DTS
> Designer components are required to edit DTS packages", "Install the
> special Web download, SQL Server 2000 DTS designer components to use
> this feature". however my co-worker are able to open, this is
> something special , and my SQL studio setting almost same as him.
> my labtop detail:
> Microsoft SQL Server Management Studio 9.00.3042.00
> Microsoft Analysis Services Client Tools 2005.090.3042.00
> Microsoft Data Access Components (MDAC) 2000.085.1117.00
> (xpsp_sp2_rtm.040803-2158)
> Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
> Microsoft Internet Explorer 7.0.5730.13
> Microsoft .NET Framework 2.0.50727.832
> Operating System 5.1.2600
>
> pls advise, many thanks
>

DTS Import txt File looping.

Hello,
Here i my problem;
I have a number of files with all the exact same format and i need to import
all of them into the same table.
As i never faced the problem before im thinking
to created a txt source and and sql server source with a data transfrom
between them. I want to change the the txt source connection "File Name"
properties for each file I need to import and loop until im done importing
all my files.(FYY: I hold all the table names in a sql table that I refreash
before importing)
So my question are ;
Is this the best approch to solve the issue with i data provided above? how
(high level - unless u want to give me the code ;-) )
or is there other ways that are better then this?
FYI: I cant use a bulk insert because the flat file layout it has follows.
H`HAVL1 1`HVAL2 2`HVAL3 3`HVAL4 4
D`DVAL1 1
D`DVAL1 1`DVAL2 2
D`DVAL1 1`DVAL2 2`DVAL3 3
D`DVAL1 1`DVAL2 2`DVAL3 3 ` HVAL4 4
i could use a bulk insert if the layout were as follows BUT its not.
H`HAVL1 1`HVAL2 2`HVAL3 3`HVAL4 4
D`DVAL1 1```
D`DVAL1 1`DVAL2 2``
D`DVAL1 1`DVAL2 2`DVAL3 3`
D`DVAL1 1`DVAL2 2`DVAL3 3 ` HVAL4 4
Thanks!!I just did this very thing. You're on the right track.
I disabled the transformation step using Disconnected Edit (in my case this
step is called DTSStep_DTSDataPumpTask_2). I then had an ActiveX script loop
thru the file names calling that transformation step.
Here's some code/pseudocode:
Set oPkg = DTSGlobalVariables.Parent
Set oFSO = CreateObject("Scripting.FileSystemObject")
Dim strThisFileName
strThisFileName = yourfirstfilename ' Get the first file name from
your table here.
' Loop thru your file names here
Do While NOT ...EOF
If oFSO.FileExists(strThisFileName) then
oPkg.Connections("YourSourceFileConnection").DataSource =
strThisFileName ' Set the filename
oPkg.Steps("DTSStep_DTSDataPumpTask_2").Execute
' Import file into table
else
exit do
end if
strThisFileName = yournextfilename
loop
Set oPkg= Nothing
Set oFSO = Nothing
"John Smith" <zzaro@.excite.com> wrote in message
news:O4gYZ96cGHA.1260@.TK2MSFTNGP05.phx.gbl...
> Hello,
> Here i my problem;
> I have a number of files with all the exact same format and i need to
> import all of them into the same table.
> As i never faced the problem before im thinking
> to created a txt source and and sql server source with a data transfrom
> between them. I want to change the the txt source connection "File Name"
> properties for each file I need to import and loop until im done importing
> all my files.(FYY: I hold all the table names in a sql table that I
> refreash before importing)
> So my question are ;
> Is this the best approch to solve the issue with i data provided above?
> how (high level - unless u want to give me the code ;-) )
> or is there other ways that are better then this?
> FYI: I cant use a bulk insert because the flat file layout it has follows.
>
> H`HAVL1 1`HVAL2 2`HVAL3 3`HVAL4 4
> D`DVAL1 1
> D`DVAL1 1`DVAL2 2
> D`DVAL1 1`DVAL2 2`DVAL3 3
> D`DVAL1 1`DVAL2 2`DVAL3 3 ` HVAL4 4
> i could use a bulk insert if the layout were as follows BUT its not.
> H`HAVL1 1`HVAL2 2`HVAL3 3`HVAL4 4
> D`DVAL1 1```
> D`DVAL1 1`DVAL2 2``
> D`DVAL1 1`DVAL2 2`DVAL3 3`
> D`DVAL1 1`DVAL2 2`DVAL3 3 ` HVAL4 4
>
> Thanks!!
>