Connect to online webhost MS SQL database

Hello,
I signed up with 1and1 for webhosting and picked the business package which
includes MS SQL server. I would like to connect to
this database from a local Visual Studio C#.NET 2003 IDE. I went to the serv
er explorer and tried to create a new data connection,
filled in the database server, uid, password and database name but was not a
ble to connect to it. The error said "the server does
not exist or access denied". Does anyone know how I can do this? I would li
ke to make some data sets and populate them with data
from the online database.
Thanks,
Max.Hi
In general I would not expect you to work on a live database in this way! I
would expect any changes to use a local copy to be developed and tested
before going live. The live upgrade can either be packaged as scripts or a
backup to be implemented on the live system. This would help prevent you
implementing bad code and causing system problems by developing on live. You
should also be able to implement source code control and have roleback
strategies for any release.
Your host should provide tools to manage/upgrade the database.
John
"Max" wrote:

> Hello,
> I signed up with 1and1 for webhosting and picked the business package w
hich includes MS SQL server. I would like to connect to
> this database from a local Visual Studio C#.NET 2003 IDE. I went to the se
rver explorer and tried to create a new data connection,
> filled in the database server, uid, password and database name but was not
able to connect to it. The error said "the server does
> not exist or access denied". Does anyone know how I can do this? I would
like to make some data sets and populate them with data
> from the online database.
> Thanks,
> Max.
>

Connect to online webhost MS SQL database

Hello,
I signed up with 1and1 for webhosting and picked the business package which includes MS SQL server. I would like to connect to
this database from a local Visual Studio C#.NET 2003 IDE. I went to the server explorer and tried to create a new data connection,
filled in the database server, uid, password and database name but was not able to connect to it. The error said "the server does
not exist or access denied". Does anyone know how I can do this? I would like to make some data sets and populate them with data
from the online database.
Thanks,
Max.Hi
In general I would not expect you to work on a live database in this way! I
would expect any changes to use a local copy to be developed and tested
before going live. The live upgrade can either be packaged as scripts or a
backup to be implemented on the live system. This would help prevent you
implementing bad code and causing system problems by developing on live. You
should also be able to implement source code control and have roleback
strategies for any release.
Your host should provide tools to manage/upgrade the database.
John
"Max" wrote:
> Hello,
> I signed up with 1and1 for webhosting and picked the business package which includes MS SQL server. I would like to connect to
> this database from a local Visual Studio C#.NET 2003 IDE. I went to the server explorer and tried to create a new data connection,
> filled in the database server, uid, password and database name but was not able to connect to it. The error said "the server does
> not exist or access denied". Does anyone know how I can do this? I would like to make some data sets and populate them with data
> from the online database.
> Thanks,
> Max.
>

Connect to AS400 table

Hi,
Is there anyway to connect to AS400 table (something like link table feature in MS Access). OR. I have to use the DTS package and schedule it to update in intervals, this i am not preferring due to the performance issue ?

your help highly appreciate

thanks
Murali.As long as you have ODBC drivers that will allow a Windows application to access the AS400 table, you can use sp_addlinkedserver (http://msdn2.microsoft.com/en-us/library/ms190479.aspx) to allow SQL Server to access it too.

-PatP

connect dbase II in ssis

I am having trouble connecting dbf of version dbase II. I can connect dbase III and dbase IV in ssis package,but can't connect dbase II.hope your help!who can help me|||

MS does not support DBBase II with their solution (JET). See the supported versions listed here-

How to use dBASE data with Access and Jet
(http://support.microsoft.com/kb/230125/en-us)

You will need to find a third-party driver, for ODBD, OLE-DB or ADO.Net. Saying that, it is rather old now, and I have never seen one. If you can understand the file format, then you could write your own source and/or connection manager.

|||

liguancong wrote:

I am having trouble connecting dbf of version dbase II. I can connect dbase III and dbase IV in ssis package,but can't connect dbase II.hope your help!

have you tried saving the dbf as a version III or IV file?

Configuring SSIS package to read a value before executin

Hi,

Is it possible in any ways to Configure a SSIS package in such a way that based on the User Input the package runs. For e.g if there is a table which has say 10 distinct groups. Normal SSIS package would ideally pick all the data from the source to the Destination

I want to know how to configure in Such a way that I should be able to say Group X as the input and data related to GroupX alone should be copied.

Select * from SomeTable where GroupName = @.CongigVar.

how to achieve something like this?

thanks

Hello,

What kind of input are you intrested in getting?

If you have the group name that you want to get information from in a table, you can, in control flow, make a query to a table, and put it on a variable, then on the data flow you can use the variable as a parameter.

To use it on a parameter your query should be

"Select * from SomeTable where GroupName = ?"

Then in the parameter button on the left you choose the variable that will pass tha value to the question mark.

Is that good for you?

Regards,

|||

Hello,

I think that might just be what I need, but when I tried creating one, its failing with the error, 'Parameter Name Unrecognized'. I think am doing it wrongly. Can you post some links that explains how to put a value from a table onto a variable, and then use it as i/p to a Data flow?

thanks

|||

Nfrf wrote:

Hello,

What kind of input are you intrested in getting?

If you have the group name that you want to get information from in a table, you can, in control flow, make a query to a table, and put it on a variable, then on the data flow you can use the variable as a parameter.

To use it on a parameter your query should be

"Select * from SomeTable where GroupName = ?"

Then in the parameter button on the left you choose the variable that will pass tha value to the question mark.

Is that good for you?

Regards,

There's no need to store values in a table. You can parameterize your package by passing it values when you call it. Explore the /SET option of dtexec. All the information you require is in Books Online.

-Jamie

|||

Yes it is true. I just gave him a way.

The thing that i thnik he wanted to know was the parameter on the query.

Even so thanks

Configuring Flat File Connection Programmatically?

I am programmatically creating a package in c#. I need this package to contain a flat file connection manager. I have been successfully able to create the connection manager with the following code:

Package p = new Package(); //New package

ConnectionManager cm = p.Connections.Add("FLATFILE"); //Add a flat file connection manager

cm.ConnectionString = "C:\Dev\myTestFile.txt"; //Set up the connection string

At this point, I want to configure the flat file specific properties of the connection manager (RowDelimiter, HeaderRowDelimiter, etc.). The problem is that the properties collection of the ConnectionManager object is read only. I think I could access the inner object of the connection manager and set the properties in the following way:

ConnectionManagerFlatFileClassffClass = (ConnectionManagerFlatFileClass) cm.InnerObject; //Get the inner object

ffClass .RowDelimiter = "{LF}"; //Set the properties here

Even if this would work, I do not like the solution b/c the BOL states that the ConnectionManagerFlatFileClass "supports the SQL Server 2005 infrastructure and is not intended to be used directly from your code". Does anyone know the "right" way to set these properties?

Many thanks in advance!

David

Figured it out - it looks like I spoke too soon - the BOL does indeed state how to do this:

cm.Properties["RowDelimiter"].SetValue(cm, "LF");

Configure SSIS package

I would like to develop a SSIS package where in there are 'X' number of input data sources like flat files, MS Access mdb files etc. The details about the number of input data sources, type of each data sources, the physical path of the data file, name os database server, username for the database server, password for the database server etc has to come from the configuration file.

Can anyone help on this ?

While you can use configurations to set things like database connections, user names, etc, SSIS packages can't change the metadata used in a dataflow at runtime. They aren't self-modifying. If you are trying to build a "generic" package that can handle any data dynamically, you will need to build an application that creates the package on the fly. SSIS has a good API, so this is certainly in the realm of possiblity, but it is still a lot of work.