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
2
votes
2 answers

SQL 2005 SSIS and Package

If I have a SSIS Package created in VS 2005 and asked to install and setup this package. Does the server that is going to run this SSIS package have to have SSIS installed? I am 99% sure this is yes, since when I run dtexec /DT packagepath it…
CWL
2
votes
1 answer

SQL server Intergration services 2008 sub queries

I am looking for a way to execute sub queries from within a main query that I execute in my SSIS package. So When I execute the package, I want to be able to execute the sub query after everyline that is produced by the main query and pass the data…
hadEnoughOfKeyboardGangstars
  • 133
  • 5
2
votes
3 answers

Problem transferring file to FTP server - 503 Could not create file

I try to transfer a file from SSIS package to a FTP server provided by my client. When I try connecting and transfer using a FTP tool (WinSCP) manually it works fine and file was transferred. But when i use the ftp command in command prompt and try…
blntechie
  • 141
  • 5
2
votes
0 answers

Emptied SQL Server Database broke the Cube

We have a SQL Server hosting our Analysis Services and accessing data from the ERP system by a ETL process. It was some duplicates in the data and therefore the SQL Server database was emptied. After running the ETL process again the end status is…
embe
  • 71
  • 4
1
vote
1 answer

Error: 0xC002918F at FTP Task, FTP Task: Unable to connect to FTP server using "FTP Connection Manager"

I am trying to download data files from a FTP server to local machine through SSIS. But it throws the error Error: 0xC002918F at FTP Task, FTP Task: Unable to connect to FTP server using "FTP Connection Manager". I have even explored all the…
Alekhya varma
  • 11
  • 1
1
vote
2 answers

SQL Server 2008 SSIS package compatability

I am trying to save an SSIS package on a sql server running 2005. The issue I have is that I am using SQL Server Management Studio 2008 on my local machine to do this and it won't let me save the package in on the server because its not compatible…
user23607
1
vote
0 answers

Unable to remotely connect to SSIS catalog

I have an SSIS installation on which I can not connect through our Citrix hosted Sql Server Management studio. I can connect to it when running SSMS locally. But if I try to connect remotely, with the Citrix hosted SSMS, I receive the following…
Reaces
  • 5,597
  • 4
  • 38
  • 46
1
vote
1 answer

Server Side Includes for certain files

at the moment, all of my .shtml files are being parsed by SSI. Some of these pages do not have SSI and it would be more efficient if they did not have to go through SSI. Is there anyway to specify a certain files or a group of files to be parsed and…
Tereno
  • 153
  • 6
1
vote
1 answer

Is it possible to keep 'owner' on file-copy?

When doing a "Operation: Copy file" using a "File System Task", is it possible to preserve the "Owner" attribute on the file? What happens: The destination file gets the "Owner" as the user running the SSIS-package. What I want: Keep the original…
Bassebus
  • 163
  • 1
  • 4
1
vote
1 answer

Connecting SSIS to AWS RDS SQL Server Instance

I am trying to connect SSIS to an AWS RDS SQL Server instance. Whenever I try to run the packages through the SQL Server Agent, I encounter this error message: Non-SysAdmins have been denied permission to run DTS Execution job steps without a…
jhnatr
  • 151
  • 2
  • 7
1
vote
0 answers

DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied

After moving a package to another server, I am unable to run it from a stored procedure using xp_cmdshell or from a job. The package exists in the file system, and I added it to the SSIS Package Store. If I run it in BIDS it runs. If I run it from…
user337113
  • 11
  • 2
1
vote
1 answer

deploy ssis 2012 packages on 2008r2 server

We've developed SSIS packages on ssis 2012, but now upon deployment, we need to deploy these to sql server 2008. I've been searching but haven't found a solution to do this. Is this even possible and what tools do I need to do this?
jelle
  • 35
  • 1
  • 8
1
vote
0 answers

What does this setting do when copying SSIS packages? "Duplicate package folder structure on destination for selected packages"

What does this setting do for copying SSIS packages? "Duplicate package folder structure on destination for selected packages." Is there any reason why I wouldn't want to duplicate the folder structure?
Ian R. O'Brien
  • 111
  • 6
1
vote
2 answers

MySQL ADO.NET Connector & MSSQL Integration Services

Here I am, day three... attempting to sync a data view on a Windows Vista box (64 bit) running MSSQL 2012 and Visual Studio 2010. Sanity is slipping and hunger for progress fills my attention. I went through hell trying to get the MySQL ODBC…
user1114330
  • 173
  • 1
  • 3
  • 11
1
vote
1 answer

SSIS DSN Not Showing as ODBC Data Source

I have been following the directions here: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/05ccd778-b78c-4a83-a10a-c4ae412cc6e4 And ran into a problem where my System DSN is not showing up as a ODBC provider. I found…
user1114330
  • 173
  • 1
  • 3
  • 11
1
2
3 4 5 6