We have a new local server that processes data using sql server 2008 and ssis. in this server i have dedicated drive to do different things. the c drive is for the os and software. the d drive is for db storage , and the ssis . The e drive is a ssd drive that … Read more
This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center. Closed 9 years … Read more
I have an Azure-hosted SQL Database. As is well documented, SSIS is not currently supported on Azure. There are a number of articles about running SSIS and SQL on an Azure VM, but this is prohibitively expensive. Is it possible to deploy SSIS packages to an Azure VM and have them execute against my Azure … Read more
Created a SSIS package, it is running fine when I run it on premise but when i try to execute it from sql server agent it gives me error for login failed for user, I am using SQL authentication to connect to the Azure database which are working fine on premise but erroring out on … Read more
This question already has an answer here: All I want to see are the specs (1 answer) Closed 4 years ago. how can I find the CPU and speed of a UCS B230 Blade server? The chassis that I have do not power on and I was wondering if there is another way to find … Read more
I am new to blade chassis management, and i want to know what is the purpose of mid plane apart from connectivity. Does it provide load balancing among the power supplies. If so does that mean it automatically ensures power supply redundancy or for redundancy some specific OR’ing circuit is needed. Appreciate any help Answer … Read more
the company i work for is installing a program which requires it to run on SQL Server Service pack 2 which uses SSIS to import data. I just installed SQL Server service pack 2 and I noticed it will only update analysis services, database services and reporting services, but not SSIS. do I need to … Read more
> Event Name: OnTaskFailed Message: > Operator: ***\administrator > Source Name: > ***_Transfer > Objects Task Source ID: > {9135C978-DD50-4418-A843-7E8FCE455181} > Execution ID: > {F6819FBA-4258-4723-B87D-525F1CF0673B} > Start Time: 19/08/2009 16:21:39 End > Time: 19/08/2009 16:21:39 Data Code: > 0 I’m getting this error in the event log after trying to copy a database on my … Read more
A newbee question: Connect to SSIS from within Management Studio? I have a running service named: Integration Services 10.0, but from within Management Studio, I don’t know how to connect to it, it doesn’t appear under the connect button. Tx. Answer In Management Studio -> Object Explorer, click on “Connect”. You should have a drop-down … Read more
I’m trying to use SSIS to traverse a directory of Excel files and put them into a table in SQL Server. I seem to have a basic choice – either I get the same spreadsheet dumped in the table 10 times or I get an error message. I’m using the instructions here: http://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx Error message: … Read more
