Accessing (writing into) Terdata by ado.net and SSIS

Hello everybody,

my name is Christof and I#m currently trying to write into our Terdata Warehouse by SSIS. In the Management Studio we can perfectly access Terdata - reading from it - but we actually see no way writing back Data into that system. Is there any hidden feature, any configuration menu that we had′nt seen so far?.

In the software documentation we found a tip "ADO.NET" as Data Destination is′nt imlemented for now - please wait until ....

I′m asking me if someone has had the same problem before and could help me out with a little tip.

thx in advance!

Christof

Moved to the SSIS forum. It doesn't sound like you're having a problem with ADO.NET itself, but rather how to get SSIS to do what you want, so I think this is the best place to start.

Thanks,
Sarah

Accessing (writing into) Terdata by ado.net and SSIS

Hello everybody,

my name is Christof and I#m currently trying to write into our Terdata Warehouse by SSIS. In the Management Studio we can perfectly access Terdata - reading from it - but we actually see no way writing back Data into that system. Is there any hidden feature, any configuration menu that we had′nt seen so far?.

In the software documentation we found a tip "ADO.NET" as Data Destination is′nt imlemented for now - please wait until ....

I′m asking me if someone has had the same problem before and could help me out with a little tip.

thx in advance!

Christof

Good luck with non-SQL Server destinations.

Read through here for tips: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=106559&SiteID=1

Access Vs SQL Server

Hello!

I am trying to gather information on why MS SQL Server 2000 is a better enterprise level database management system MS Access 2002. There is an article on the Microsoft Technet, but when I try and access the article I get a 404 error. Link is there, but page behind is missing.

http://www.micrsoft.com/sql/techinfo/planning/SQLAccess.asp

I know the basics, just want stats and facts to back them up.

Thanks...Originally posted by swestenhofer
Hello!

I am trying to gather information on why MS SQL Server 2000 is a better enterprise level database management system MS Access 2002. There is an article on the Microsoft Technet, but when I try and access the article I get a 404 error. Link is there, but page behind is missing.

http://www.micrsoft.com/sql/techinfo/planning/SQLAccess.asp

I know the basics, just want stats and facts to back them up.

Thanks...

1) Volume of data
2) Scalbility
3) Performance
4) OLAP
5) Security features
6) Easy Query processing
7) Data distribution and replication
8) Job scheduling
9) Programmability

There are lots of reasons like this. Access is good if your data is less than 2GB and depends what you are looking from a database.|||Access is not a database "Server". Thus, if you have a query in Access that joins a parent table with 10,000 rows to a child table with 100,000 to return a filtered set of records consisting of, say 200 rows, Access will transfer all 110,000 records from both tables over your network and then perform the SQL statement on whatever (slow) desktop the user happens to be at.

Under SQL Server, all the calculation is done on the (powerfull quad-processor, RAM out the wazzoo) server, and only the final 200 rows are returned over your network.

In a nutshell, running Access as an Enterprise solution drags a network to its knees.|||Originally posted by blindman
Access is not a database "Server". Thus, if you have a query in Access that joins a parent table with 10,000 rows to a child table with 100,000 to return a filtered set of records consisting of, say 200 rows, Access will transfer all 110,000 records from both tables over your network and then perform the SQL statement on whatever (slow) desktop the user happens to be at.

Under SQL Server, all the calculation is done on the (powerfull quad-processor, RAM out the wazzoo) server, and only the final 200 rows are returned over your network.

In a nutshell, running Access as an Enterprise solution drags a network to its knees.

Thanks all!! This should be good fuel for my client to use... thanks for the help!|||Hey...no one told him about the cost...

What's the differences between a kia and a bentley?|||Originally posted by Brett Kaiser
Hey...no one told him about the cost...

What's the differences between a kia and a bentley?

I know the cost differences involved, and the client is aware as well, and in the long run, user connection timeouts and database size limitations may outway the costs based on recovery and migration...

Thanks again!

Access to integration services

Hi Guys,

I have a quick question, Can i access the SSIS services of a Server from a remote server using Sql Server management studio.

I'm trying to access a third DB server and i can access it using Sql server management studio with sa and password but the integration services aren't there and when i try to explicitly connect to it, it is not connecting

Any ideas?

P.S: Can any of you recommend a very good book as I've done some work with it but it seems i might be the one doing more work with BI from now on as the organisation is not going to appoint anyone else in this position.

Thank you

Gemma

Do you have the SSIS service running on the server? Do you get any error messages?|||

Gemma wrote:

P.S: Can any of you recommend a very good book as I've done some work with it but it seems i might be the one doing more work with BI from now on as the organisation is not going to appoint anyone else in this position.

This is a good book. Especially for doing ETL with SSIS.

http://www.amazon.com/Expert-Server-Integration-Services-Programmer/dp/0470134119/
|||

If you want something that is more of a reference, the Kirk Haselden Microsoft SQL Server 2005 Integration Services is really good. The Wrox Programmer to Programmer SQL Server 2005 Integration Services is also decent. (They cover nearly the same topics, you will only need one or the other)

I'd agree that Expert SSIS is a good book (through about half of it now). The Expert SSIS is more of a walk through while explaining some of the theories and providing tips and best practices. It often tells the reader to refer to the SQL Server 2005 Integration Services book for more detailed information on the various tasks / transforms.

If you are looking for a reference on Datawarehousing / B.I. in relation to SQL 2005 SSIS / Analysis Services / Reporting etc, The Microsoft Data Warehouse Toolkit by Joy Mundy and Warren Thornthwaite is pretty good. If you are just looking for Datawarehousing / B.I. theory then you should probably read The Data Warehouse Toolkit Second Edition by Ralph Kimball.

I also have the Delivering Business Intelligence with Microsoft SQL Server 2005 (Larson) and Practical Business Intelligence with SQL Server 2005 (Hancock) but have not had a chance to read through them as of yet....

|||

Gemma wrote:

Hi Guys,

I have a quick question, Can i access the SSIS services of a Server from a remote server using Sql Server management studio.

I'm trying to access a third DB server and i can access it using Sql server management studio with sa and password but the integration services aren't there and when i try to explicitly connect to it, it is not connecting

Any ideas?

We were having this problem until earlier this week (we are in the beginning phases of using SSIS ourselves). We were able to resolve the access denied issue (if that is what you are having) by following the steps in the following article: http://sqljunkies.com/WebLog/knight_reign/archive/2006/01/05/17769.aspx

|||

Thanks to all of you, who contributed. I have made a note of your suggested books.

Can any of you also tell me a very good t-sql book as I'm really really bad in t-sql?

Thanks again

Gemma

|||

You'll want two: Inside SQL Server 2005: T-SQL Programming and T-SQL Querying. You will need to read the Querying before the programming as the programming book builds off of ideas presented in the first book.

(Although I only bought them a little less than a month ago and haven't read them yet, when I did research those were the two that came with the highest recommandations)

|||

Thank you

Ta

Gemma

Access SQL Server 2005 via HTTP

Hi

Is it possible to access sql server 2005 via http and do some management and administration task?

Thanks in advance,

Larry

I believe that there may be a web based admin tool in development. Otherwise, your only good options are third party products or VPN.

access sql server 2005 via http

Hi

Is it possible to access sql server 2005 via http and do some management and administration task? if possible how?

Thanks in advance,

Larry

Hi larry,

I suggest you configure a windows 2000 or 2003 VPN or cisco VPN
to actually access the Sql server box via http
this is i think more secure.

You can however access sql server via SQL server Endpoint
but i suggest you do configure a VPN
since it is more secure

regards,
joey|||

http://www.microsoft.com/downloads/details.aspx?FamilyID=c039a798-c57a-419e-acbc-2a332cb7f959&displaylang=en closely related to SQL 2000 or MSDE, but you are looking for SQL 2005 instance so as suggested endpoings are good to go, http://www.developer.com/db/article.php/3390241 and http://davidhayden.com/blog/dave/archive/2006/03/31/2897.aspxfyi..

http://codebetter.com/blogs/raymond.lewallen/archive/2005/06/23/65089.aspx tooq

Access denied to vbs file

Hi All,
Am trying to create a job in management studio 2005, that uses an sql
server agent proxy, but when I try to open the Active X proxy (a vbs script)
on my my c:\drive, it gives me error message: Access to the path 'C:\Program
files\Microsoft Learning\2780\Mod7\Practices\CreateOrder
.vbs' is denied.
(mscorlib). I tried to shared the drive in the folder security, but no joy.
foscoHi All,
Silly me, the script was supposed to save to a path pointing to D:\ and I
check inside the script to discover this, so the job was able to execute as
instructed, changed it to C:\ drive and it worked, thanks so much.
Fosco
"fosco" <folabii@.hotmail.com> wrote in message
news:edmrXaZPIHA.1756@.TK2MSFTNGP06.phx.gbl...
> Hi All,
> Am trying to create a job in management studio 2005, that uses an sql
> server agent proxy, but when I try to open the Active X proxy (a vbs
> script) on my my c:\drive, it gives me error message: Access to the path
> 'C:\Program files\Microsoft Learning\2780\Mod7\Practices\CreateOrder
.vbs'
> is denied. (mscorlib). I tried to shared the drive in the folder security,
> but no joy.
>
> fosco
>

Access denied to vbs file

Hi All,
Am trying to create a job in management studio 2005, that uses an sql
server agent proxy, but when I try to open the Active X proxy (a vbs script)
on my my c:\drive, it gives me error message: Access to the path 'C:\Program
files\Microsoft Learning\2780\Mod7\Practices\CreateOrder.vbs' is denied.
(mscorlib). I tried to shared the drive in the folder security, but no joy.
fosco
Hi All,
Silly me, the script was supposed to save to a path pointing to D:\ and I
check inside the script to discover this, so the job was able to execute as
instructed, changed it to C:\ drive and it worked, thanks so much.
Fosco
"fosco" <folabii@.hotmail.com> wrote in message
news:edmrXaZPIHA.1756@.TK2MSFTNGP06.phx.gbl...
> Hi All,
> Am trying to create a job in management studio 2005, that uses an sql
> server agent proxy, but when I try to open the Active X proxy (a vbs
> script) on my my c:\drive, it gives me error message: Access to the path
> 'C:\Program files\Microsoft Learning\2780\Mod7\Practices\CreateOrder.vbs'
> is denied. (mscorlib). I tried to shared the drive in the folder security,
> but no joy.
>
> fosco
>