Need help to move data import from QA server to Production server
-
Using Visual Studio I have created a dtsx package to import data from and Excel spreadsheet (2010) into a SQL Server table. It has passed all of our tests and we are ready to move it into production. My question is, how do I move this onto the production server when the connections are to the QA server? I would think I could use parameters but I do not understand how to set up parameters and then use them for the Connection Managers. So I'm looking for help on using parameters, or if there is a better way to move onto production server.
Thanks
[font="Comic Sans MS"]Vic[/font]
www.vicrauch.com -
Have you tried Google?
Alvin Ramard
Memphis PASS Chapter[/url]All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
-
I tried Google once Alvin but the data throughput wasn't fast enough
Steve.
-
Yes, I have used Google and found that if I had a clue on how to do this, I might be able to follow what I have found on Google. But I am a complete rookie at SSIS, very new to SQL Server, and I'm trying to get this accomplished so I can move on to other work. The boss is getting unhappy so I thought SQL Server Central forum might help me get this accomplished much quicker than reading endless articles that Google finds for me. One article I was reading used this quote: "In the Connection Managers area, right-click the connection manager that you want to create a parameter for and then click Parameterize." The only place I knew that reference Connection Managers was the Solution Explorer within Visual Studio. I messed with that for a while trying to find the "Parameterize" wording. Finally I stumbled accross the "Connection Managers" area at the bottom of the screen. So I have now found the Parameterize dialog box, but I'm not really sure what is going to happen when I change a connection string to use the Product server.
That is why I'm asking the question out here, hoping for a personalized response to what I'm asking, rather than a generalized overview article that is usually found with Google. So if you can provide that personalized response to my specific question, I would greatly appreciate it.
[font="Comic Sans MS"]Vic[/font]
www.vicrauch.com -
I Googled "ssis using parameters for connection manager" and got several good results.
Alvin Ramard
Memphis PASS Chapter[/url]All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
-
SQLChick has a reasonably good intro (there are several others out there too). You're looking for configurations and parameterization, which at a glance, this sems to cover off nicely.
Steve.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply