MSDE and DTS packages

Hi all
I am new to the msde and have worked with SQL for a little while. I have developed my database on my SQL server and now have transfered it to MSDE with only one problem.
I have exported the dts package to a text file, but when I import it into MSDE there is nothing there.
My question is can I (and how) create a DTS package through vbscript or osql? I have looked in MSDN and found the dtswiz with command line switchs, but I can not find an example using a text file. I unbderstand that there are a few more switches to tell
it the delimitation.
Any help would be very appreciated.
Thanks for your help in advance.
I'm guessing you want to import dts packages into MSDE (if not my
appologies).
you can save the package as a structured storage file and use a little vb
app to load the package in memory and then save it to the msde using
SaveToSQLServer function of the package class ?
If you have a SQL Server then you can also use enterprise manager to simply
save the DTS packes directly to your msde instance.
Hope this helps.
Ranjeet.
"whiggins" <anonymous@.discussions.microsoft.com> wrote in message
news:8A03C082-9B78-4106-83EF-F2DC7FBD65E6@.microsoft.com...
> Hi all
> I am new to the msde and have worked with SQL for a little while. I have
developed my database on my SQL server and now have transfered it to MSDE
with only one problem.
> I have exported the dts package to a text file, but when I import it into
MSDE there is nothing there.
> My question is can I (and how) create a DTS package through vbscript or
osql? I have looked in MSDN and found the dtswiz with command line switchs,
but I can not find an example using a text file. I unbderstand that there
are a few more switches to tell it the delimitation.
> Any help would be very appreciated.
> Thanks for your help in advance.

MSDE ,SSMSE connection

hi friends,

I'll be thankful if anyone solve this problem.

When i developed my application, i used sql 2000 as a server side DB.
Now my client want to install MSDE instead of SQL 2000.

so i uninstall SQL2000 and installed MSDE .

AS we all know, MSDE doesn't have GUI. So i installed Microsoft SQL Server Management Studio Express - Community Technology Preview (CTP)
(includeing xmlparser,windows installer,.net 2.0).

now i could able to view tables and everything. but i couldn't make the connection. Getting error like "SQL server not found. CMPNAME\MSDERELA"
I used same kind of connection string for SQL 2000. Worked well.here what happened?

Connection String : "Data Source = CMPNAME\MSDERELA;Database =TEST; User id ="xxx; Password =xxxx;"

OS: Windows server 2003.
i used VB.NET to develop the apps. (VS2003). Connecting from Pocket PC.

kindly help me to solve this problem.

(Already i posted this in SQL tools forum. i hope this is the right place to post this question. so posting again.)

Thank u!

First I suggest you install the release version of SSMS-E.

Then can you go into the services panel in Windows and see if there are any services that start with MSSQL$, if there are please make sure it is started.

If it is started then please test the connection by using osql from a cmd prompt.

|||

You mean i need to install SSMSE before installing MSDE?

Let me share, what i 've done

1) installed MSDE

2)Windows installer 3.1

3).net framework 2

4)XML Parser

5) SSMSE

6) Start the MSDE agent and enabled TCP/IP.

Only thing is, i didn't check the connection in command prompt.

I checked with apps.

Thanks.

|||

So you know for sure the the MSSQL$ service is running (not the agent service)?

Can you please try connecting using osql from the command line please?

MSDE & SSMSE -CTP connection problem

hi friends,

I'll be thankful if anyone solve this problem.

When i developed my application i used sql 2000 as a server side DB.
Now my client want to install MSDE instead of SQL 2000.

so i uninstall SQL2000 and installed MSDE .

AS we all know, MSDE doesn't have GUI. So i installed Microsoft SQL Server Management Studio Express - Community Technology Preview (CTP)
(includeing xmlparser,windows installer,.net 2.0).

now i could able to view tables and everything. but i couldn't make the connection. Getting error like "SQL server not found. CMPNAME\MSDERELA"
I used same kind of connection string for SQL 2000. Worked well.here what happened?

OS: Windows server 2003.
i used VB.NET to develop the apps.

kindly help me to solve this problem.

why do you need to have a gui interface on the same box. you can connect to it from another SQL client machine/Server.|||

I don't understand ur point.

My server machine has MSDE DB only.

Clients are Pocket PCs.

|||? Hi, I have seen one other person with a problem like this when they created a SQL Server database from Visual Studio. Can you confirm that MSDE is installed as a named instance MSDERELA? Open a command shell window and type the following: SQLCMD -S .\MSDERELA What do you see? If you see a prompt like this: 1> then you are able to connect to the instance using SQLCMD which is a start. I notice that you have a CTP installed. You need to be VERY careful when you later come to uninstall this and go to SSMSE RTM build. There is a specific order in which to uninstall items to achieve a successful uninstall. Andrew Watt MVP <ar_pad@.discussions.microsoft.com> wrote in message news:434cb1f0-4b2c-43c5-97da-5aea1f39295f@.discussions.microsoft.com... hi friends, I'll be thankful if anyone solve this problem. When i developed my application i used sql 2000 as a server side DB.Now my client want to install MSDE instead of SQL 2000. so i uninstall SQL2000 and installed MSDE . AS we all know, MSDE doesn't have GUI. So i installed Microsoft SQL Server Management Studio Express - Community Technology Preview (CTP) (includeing xmlparser,windows installer,.net 2.0). now i could able to view tables and everything. but i couldn't make the connection. Getting error like "SQL server not found. CMPNAME\MSDERELA"I used same kind of connection string for SQL 2000. Worked well.here what happened? OS: Windows server 2003.i used VB.NET to develop the apps. kindly help me to solve this problem.|||

Hi,

Yes. It's a named instance. computername\MSDERelA.

can i use the same cmd? SQLCMD -S .\MSDERELA where can i see these kind of commands?

I followed this order. 1) windows installer

2)dotnetfx.exe

3)msxml6.msi

4) SSMSE

is it correct?

Thanks!

|||

That's the right order to install Management Studio Express.

The command line syntax for sqlcmd is very similar to the syntax for osql. You can get the command line syntax for sqlcmd by typing the following in a command window:

sqlcmd /?

"sqlcmd -S .\msderela -E" will connect to your local msderela instance using Windows authentication. You can type "quit" to exit sqlcmd.

Here's the online help topic for sqlcmd: http://msdn2.microsoft.com/en-us/library/ms165702(SQL.90).aspx

Hope this helps,
Steve

MSDE & SSMSE -CTP connection problem

hi friends,

I'll be thankful if anyone solve this problem.

When i developed my application i used sql 2000 as a server side DB.
Now my client want to install MSDE instead of SQL 2000.

so i uninstall SQL2000 and installed MSDE .

AS we all know, MSDE doesn't have GUI. So i installed Microsoft SQL Server Management Studio Express - Community Technology Preview (CTP)
(includeing xmlparser,windows installer,.net 2.0).

now i could able to view tables and everything. but i couldn't make the connection. Getting error like "SQL server not found. CMPNAME\MSDERELA"
I used same kind of connection string for SQL 2000. Worked well.here what happened?

OS: Windows server 2003.
i used VB.NET to develop the apps.

kindly help me to solve this problem.

why do you need to have a gui interface on the same box. you can connect to it from another SQL client machine/Server.|||

I don't understand ur point.

My server machine has MSDE DB only.

Clients are Pocket PCs.

|||? Hi, I have seen one other person with a problem like this when they created a SQL Server database from Visual Studio. Can you confirm that MSDE is installed as a named instance MSDERELA? Open a command shell window and type the following: SQLCMD -S .\MSDERELA What do you see? If you see a prompt like this: 1> then you are able to connect to the instance using SQLCMD which is a start. I notice that you have a CTP installed. You need to be VERY careful when you later come to uninstall this and go to SSMSE RTM build. There is a specific order in which to uninstall items to achieve a successful uninstall. Andrew Watt MVP <ar_pad@.discussions.microsoft.com> wrote in message news:434cb1f0-4b2c-43c5-97da-5aea1f39295f@.discussions.microsoft.com... hi friends, I'll be thankful if anyone solve this problem. When i developed my application i used sql 2000 as a server side DB.Now my client want to install MSDE instead of SQL 2000. so i uninstall SQL2000 and installed MSDE . AS we all know, MSDE doesn't have GUI. So i installed Microsoft SQL Server Management Studio Express - Community Technology Preview (CTP) (includeing xmlparser,windows installer,.net 2.0). now i could able to view tables and everything. but i couldn't make the connection. Getting error like "SQL server not found. CMPNAME\MSDERELA"I used same kind of connection string for SQL 2000. Worked well.here what happened? OS: Windows server 2003.i used VB.NET to develop the apps. kindly help me to solve this problem.|||

Hi,

Yes. It's a named instance. computername\MSDERelA.

can i use the same cmd? SQLCMD -S .\MSDERELA where can i see these kind of commands?

I followed this order. 1) windows installer

2)dotnetfx.exe

3)msxml6.msi

4) SSMSE

is it correct?

Thanks!

|||

That's the right order to install Management Studio Express.

The command line syntax for sqlcmd is very similar to the syntax for osql. You can get the command line syntax for sqlcmd by typing the following in a command window:

sqlcmd /?

"sqlcmd -S .\msderela -E" will connect to your local msderela instance using Windows authentication. You can type "quit" to exit sqlcmd.

Here's the online help topic for sqlcmd: http://msdn2.microsoft.com/en-us/library/ms165702(SQL.90).aspx

Hope this helps,
Steve