Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [ssis]

SQL Server Integration Services, used for data migration in and out of Microsoft SQL Server

77 questions
0
votes
1 answer

Connect to SSIS from within Management Studio

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.
Peter
  • 101
  • 6
0
votes
1 answer

SSIS 2014 - map NFS

We are migrating SSIS from SQL 2008 to SQL2014. Old OS: WINDOWS 2008 R2 SP1 New OS: WINDOWS 2012 R2 I use the Execute Process Task to map an NFS share to a drive. Executable: C:\Windows\System32\net.exe Arguments: use Q: :/vol/ When I execute…
Boeykes
  • 1
  • 1
0
votes
1 answer

Fixed Length Field Export from SQL Server

How do I go about exporting SQL Server 2005 tables to a fixed length field text file, with one record per line? SQL seems to think fixed length is the only way to delimit records, i.e. fieldLen1 + fieldLen2 + ... + fieldLenN = recLen. I can't find…
ProfK
  • 493
  • 5
  • 9
  • 28
0
votes
1 answer

SQL Server 2005: Copy database failing with unhelpful error

> 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:…
Rob Stevenson-Leggett
  • 613
  • 2
  • 7
  • 20
0
votes
1 answer

SSIS/ETL jobs fail with network related errors, when network is OK

We have a SQL Server 2012 instance that is our main ETL/DW server. The daily jobs consist of about 40+ ETL processes querying other data sources, updating the DataMart, standard ETL and BI processes. For the past several weeks, many jobs have failed…
Ddono25
  • 165
  • 3
  • 13
0
votes
2 answers

Exporting/restoring Multiple SSIS DTSx packages to file system

Is there a way to export and import multiple dtsx packages from SQL Server 2008? I'm trying to find a built-in way/free tool/script to automate right-clicking the package, selecting "File System" for package location, and specifying the same server…
Steve
  • 113
  • 4
0
votes
1 answer

SQL Server with one ethernet output and Webserver with another ethernet output

Scenario: I have one server which is virtualizated using VMWare ESXi. Specs: Windows Server 2008 R2 SQL Server Standard 2012 IIS 7.5 Hosting a MVC and a Webform application (using Reporting Services) Integration Services is also heavily…
equasar
  • 101
0
votes
1 answer

sql server sp2 doesn't update ssis

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…
phill
  • 327
  • 3
  • 13
  • 20
0
votes
2 answers

SQL server agent job to execute SSIS package fails, package succeds if run manually

I've got a SSIS package installed on a SQL server (SQL Server 2012). It's fairly simple and just fetches data from a remote data source and adds it into a local table. The remote connection string is using SQL server authentication, while the local…
growse
  • 8,020
  • 13
  • 74
  • 115
0
votes
1 answer

SSIS package hangs on Setting Source Connection

I have an SSIS package that has been executing successfully for the last 7 years. All of a sudden the package won't run and hangs at the Setting Source Connection step and has to be closed down via End Task. I can access all of the databases but…
kereberos
  • 101
  • 2
0
votes
2 answers

How to copy files to destination system through a specific LAN card?

I want to copy database backup from my running DB Server to Backup server. The source server has two LAN cards connected through their own IP address. One LAN card is used to connect to the application server and I want to user the other LAN card to…
hammad siddiqui
  • 1
  • 1
0
votes
2 answers

OpenSSH and remote invocation

Before I ask the questions, I have to provide some context information... I have a SSIS server which invokes a SSIS package. The SSIS package copies a file to a file server. After the copy action, the SSIS package must invoke a SFTP transfer to SFTP…
Patrick Peters
  • 135
  • 1
  • 7
0
votes
1 answer

Error with SharpZipLib in Script Task SSIS 2008

I am trying to create a script which can Zip any file on the fly. For this a DLL SharpZipLib i have used. But unable to run the Package. Following code i found on the internet which i have used as is for a sample inside Script Task…
Farhan Ahmed
  • 11
  • 3
0
votes
2 answers

how do you install SSIS on a cluster environment

I'm running SQL Server 2005 enterprise edition on a 2 node active-active cluster windows 2003 server. I go to add/remove programs, click on SQL Server and then the link for "to install a new component, click here". It then says enter the location.…
phill
  • 327
  • 3
  • 13
  • 20
0
votes
2 answers

SSIS Configuration problem: not returning SQL Server Table config values

I have a package that runs fine on my dev machine but in production the Config seems to stop working. I'm using SQL Server Table configuration to pull a value from a table and populate a variable. My Database connection string is passed in at…
Glenn M
  • 121
  • 3
1 2 3
4
5 6