Anyone know of a good source for SSIS/SQL2008?

Topic

New Reply

Sorry,

I know that in the past, several posts have been answered with “there are several good sources for SQL on the net, please look for them.” And please redirect this, as necessary.

Here’s the deal.

1. My office set up a virtual developer machine where they installed SQL2008(Express) and BIDS(Business Intelligence Development Studio).

2. I’m trying to upload some XML data to my handy dandy db on SQL2008.

This sounds simple, but here’s what I’m getting:

1. Setting up a connection manager – it won’t find my handy dandy db. If I put the name in the Logical Name, and save it, everything seems to be okay until I go to either test out the connection manager or try to run my package. I just keep getting one of two messages – either my Windows login doesn’t have permission to use my handy dandy db or I am already in my handy dandy db and blocking my package.

2. I’ve tried moving my handy dandy db (and I know this is a big no-no) into the Master db, but when I do this, it still isn’t available and then the same disaster awaits as in #1 above.

I would just as soon keep everything on the BIDS project in XML, since I’m trying to interface with another application, but the XML I have now is for lookup tables and I fear once I get the test data, it will be looking for those lookup tables in the XML references.

Any suggestions? I’m supposed to have something for this project by next week.

Reply | Quote

Replies

1. My office set up a virtual developer machine where they installed SQL2008(Express) and BIDS(Business Intelligence Development Studio).

2. I’m trying to upload some XML data to my handy dandy db on SQL2008.

This sounds simple, but here’s what I’m getting:

1. Setting up a connection manager – it won’t find my handy dandy db. If I put the name in the Logical Name, and save it, everything seems to be okay until I go to either test out the connection manager or try to run my package. I just keep getting one of two messages – either my Windows login doesn’t have permission to use my handy dandy db or I am already in my handy dandy db and blocking my package.

2. I’ve tried moving my handy dandy db (and I know this is a big no-no) into the Master db, but when I do this, it still isn’t available and then the same disaster awaits as in #1 above.

1.) Do you have SQL Server 2008 SP-1 installed?
2.) Are you trying to access from a different PC?
3.) If yes to 2., can you attach to the SQL instance?
4.) Can you use some other tool like Access to make sure you can get to the SQL instance?

Joe

--Joe

Reply | Quote

1.) Do you have SQL Server 2008 SP-1 installed?
2.) Are you trying to access from a different PC?
3.) If yes to 2., can you attach to the SQL instance?
4.) Can you use some other tool like Access to make sure you can get to the SQL instance?

Joe

1.) Do you have SQL Server 2008 SP-1 installed?

yes

2.) Are you trying to access from a different PC?

no – same virtual machine has SQL2008/BIDS
3.) If yes to 2., can you attach to the SQL instance?

Funny you should ask that – I can open both and the sql server knows who I am. I even set my login credentials to be administrator
4.) Can you use some other tool like Access to make sure you can get to the SQL instance?

wish I could – my project would go much faster. I was able to export the XML to another xml file, but I don’t think this tells anyone anything.

I’ve looked up everything from the specific error (login failed for user…) to creative uses of SSIS, SQL2008 and BIDS. I downloaded the tutorial from MS but I can’t install Adventureworks (I know how to fix this, just don’t have the time). Everything points to all is okay, until I go to find the table in my newly-created db.

Does this help?

Reply | Quote

I’ve looked up everything from the specific error (login failed for user…) to creative uses of SSIS, SQL2008 and BIDS. I downloaded the tutorial from MS but I can’t install Adventureworks (I know how to fix this, just don’t have the time). Everything points to all is okay, until I go to find the table in my newly-created db.

Are you shutting down the VM and losing changes?

Joe

--Joe

Reply | Quote

Are you shutting down the VM and losing changes?

Joe

Joe,

First of all, thanks so much for trying to help!

No – everything saves. I did notice something amiss though…When I create a new db, it goes into a folder called, to protect the innocent, Program FilesSQLServerMickey1.1Data. However, when BIDS links to the developer machine(which it thinks is Mama Server), the reference is Program FilesSQLServerMickey10.1DATA. So Mickey10.1DATA only has the standard master and tmp files. Could this be the problem?

Reply | Quote

Joe,

First of all, thanks so much for trying to help!

No – everything saves. I did notice something amiss though…When I create a new db, it goes into a folder called, to protect the innocent, Program FilesSQLServerMickey1.1Data. However, when BIDS links to the developer machine(which it thinks is Mama Server), the reference is Program FilesSQLServerMickey10.1DATA. So Mickey10.1DATA only has the standard master and tmp files. Could this be the problem?

Joe,

You know, right after I typed the above, I went and then went back to the SQL server and connected to Mickey10.1 and voila back in business.

I owe you a

Reply | Quote

You know, right after I typed the above, I went and then went back to the SQL server and connected to Mickey10.1 and voila back in business.

Glad you figured it out. Good luck with the deadline. Thanks for posting back.

Joe

--Joe

Reply | Quote