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

learn more… | top users | synonyms

4
votes
2answers
10k views

Can I tell the last modified date on an SSIS package from Integration Services

Using SQL Server 2005 (and 2008) With a DTS package, I can open it, and it lists the date that the package was last modified. I have some SSIS packages, and I need to know if they have been modified ...
4
votes
1answer
707 views

Distributed and/or Parallel SSIS processing

Background: Our company hosts SaaS DSS applications, where clients provide us data Daily and/or Weekly, which we process & merge into their existing database. During business hours, load in the ...
3
votes
3answers
9k views

SQL Server 2005: Copy SQL Server Agent Job?

I have a SQL Server Agent job comprised of 10 steps and each step has many parameters defined. Now I need another job almost exactly the same, but with a few differences. Since "copy / paste" isn't an ...
3
votes
3answers
25k views

Installing ONLY SSIS and not the whole SQL Server system?

I have a production SQL Server 2008 running on Windows Server and I do testing and development on my laptop. My laptop is running Win XP and SQL Server Express 2008. In addition to having SQL Server ...
3
votes
4answers
3k views

can SSIS connect to another sql server?

Can an SSIS package run on one SQL Server instance but process data that is located on another SQL Server instance? I'd like to know this before I attempt to install SSIS and require a possible ...
3
votes
2answers
6k views

SSIS: How to create and export data to Microsoft Access 2003 database?

Goals - Automate exporting SQL Server 2005 views to Microsoft Access 2003 database (no transformation required) through SQL Server Job (with SSIS package) There is no "Access DB Destination" in BI ...
3
votes
5answers
441 views

Executing SSIS package

I posted my question on stackoverflow but I was told that it might be better off here. I have a problem executing my SSI package from command line. I created the package via SQL Server Business ...
3
votes
4answers
1k views

Unix and Triggering MS SQL Server Integration Services Jobs

We have an AIX server which contains a lot of data, and once a night we dump that data to CSV for import into MS SQL Server for reporting reasons. At the moment, each step in the process is unlinked, ...
2
votes
3answers
5k views

How can I make my SSIS process consume more resources and run faster?

I have a daily ETL process in SSIS that builds my warehouse so we can provide day-over-day reports. I have two servers - one for SSIS and the other for the SQL Server Database. The SSIS server (...
2
votes
2answers
6k views

How can I Import Data using SQL Servers SSIS, when using foreign key constraints?

I'm trying to set up an import form live database to our development database. I trying to do this using SSIS, but the import is failing because of constraints. E.g. I have the following tables: ...
2
votes
2answers
533 views

Why does SQL 2005 SSIS component install fail?

I am trying to install SSIS on our production SQL 2005 SP2 box. Each time I try, the install/setup screen results in failure, starting with the native client, and moving on down. Screen shots below ...
2
votes
1answer
5k views

The package failed to load due to error 0xC0011008 Error Loading from XML

Environment: Windows Server 2008 SP2 Enterprise Edition 64-bit SQL Server 2008 SP3 Standard Edition 64-bit Previously had SQL Server 2005 Developer Edition 32-bit Integration Services. That has now ...
2
votes
2answers
70 views

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, ...
2
votes
1answer
885 views

Execute SSIS package from a SQL Agent on another server

Here's my situation: I have two servers, Server A has the Database Server installed and the SQL Agent (SQL Server 2008 Enterprise Edition, 64-bit). Server B has a vendor specific application that ...
2
votes
3answers
1k views

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 ...
2
votes
1answer
173 views

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 ...
1
vote
2answers
126 views

Is there a performance hit when using an external URL rather than an internal IP to address a server in SSIS?

I'm running SQL Server Integration Services (SSIS) packages in SQL Server agent every day. I've been monitoring the performance of the packages and see a lot of network activity in Resource Monitor. I'...
1
vote
1answer
3k views

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 ...
1
vote
1answer
3k views

SQLServer2008 CopyDatabaseWizard Job Fails - Unable to determine if owner of job has server access

Trying to copy a SQL2000 database on server TUNA to destination server MOJITO which runs default instance of SQL2008 (at ServicePack1) via the CD Wizard. Resulting job fails on MOJITO with this in ...
1
vote
2answers
520 views

Can SSIS transfer data from a SQL Server 2005 database to a 2008 database?

I need to transfer data on a regular automated basis from a database running on a SQL Server 2005 instance to a remote database running on a SQL Server 2008 instance. I'm new to database ...
1
vote
1answer
33 views

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 ...
1
vote
1answer
76 views

Edit SQL Server SSIS Package

I ran the Export wizard to output some data to Excel, and I saved the package to run agan later. I now want to edit the SQL used to generate the Excel, but it is not clear how I do this. The package ...
1
vote
2answers
352 views

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 ...
1
vote
1answer
393 views

MSSSQL: SSRS, SSAS, SSIS edition

How can I know which edition of SSRS, SSAS and SSIS service is installed on a server? Finding database edition is easy but how to find edition for other SQL services? Any help please? Thanks in ...
1
vote
1answer
28 views

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 ...
1
vote
1answer
629 views

odbc connect to cluster node error

I recently installed SQL Server Integration Services onto one of the nodes of a single cluster thats running windows 2003 enterprise. When I attampt to create a system odbc connection to the database ...
1
vote
1answer
24 views

SQL Server Agent Service - SSIS package scheduling not working

We have a local admin privilege to our VPN users and we have created SSIS packages but not able to run it through SQL server agent services as its not allowing to run throwing error being non-...
1
vote
0answers
58 views

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 ...
1
vote
0answers
97 views

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....
1
vote
1answer
801 views

Deploying an SSIS Package - TNS:could not resolve the connect identifier specified

I have an SSIS package which has 4 connections - a WebService, 2 SQL Server connections (across 2 domains), and 1 connection to an Oracle DB. When the package is run from Visual Studio from a laptop, ...
1
vote
0answers
60 views

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 ...
1
vote
2answers
2k views

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 ...
1
vote
0answers
350 views

SSIS on W2K8 R2, SQL Server 2008 SP2 and Oracle

I'm in the process of migrating an old SQL Server 2000 SP4 on Windows 2000 to a new SQL Server 2008 SP2 on Windows 2008. In the old server we have a DTS that does some simple tasks against an Oracle ...
1
vote
1answer
352 views

PostgreSQL - Using COALESCE keyword in SSIS

When I am trying to use the COALESCE key word in an OLE DB Source control, it always returns a negative number in the results set. I am using a Native OLE DB\PostgreSQL Native Provider as a ...
1
vote
1answer
440 views

How do I filter duplicates from a sharepoint list using ssis

I have successfully connected a sql data base to a sharepoint list using ssis. The problem is that every time I run the project all the data gets dumped into the list and causes duplicates. Is there ...
0
votes
2answers
2k views

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 ...
0
votes
2answers
604 views

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 ...
0
votes
2answers
8k views

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 ...
0
votes
2answers
322 views

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 ...
0
votes
1answer
2k views

Access SSIS Projects Stored in MSDB Database in BIDS?

I have a database server (db1) that has SSIS installed and configured (SQL 2008). I have configured it so I can remotely connect to SSIS through SSMS. Now I am trying to open one of these SSIS ...
0
votes
1answer
2k views

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 + ...
0
votes
1answer
17 views

Why is SSIS reading so much data from my hard drive?

We're running SQL Server 2012 on Windows Server 2008 R2 for a our CRM and ERP services. Unfortunately, the majority of the setup was outsourced to an "expert" company who neglected to provide any ...
0
votes
1answer
36 views

How do I update Dynamics CRM with from flat file via Kingswaysoft?

I've been trying for some time to update existing leads in CRM via .csv files and the migration tool by Kingswaysoft. I am trying to update fields based on one key column, updating old leads and ...
0
votes
1answer
61 views

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 ...
0
votes
1answer
6k views

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 ...
0
votes
2answers
281 views

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, ...
0
votes
2answers
226 views

Automatically set up user's subscription in SSRS

I have a very simple report in SSRS that is just a table with three columns, an object name, client account, and expiration date. In my report, I include a filter by UserID to limit the data to just ...
0
votes
1answer
651 views

Possible to connect securely to remote MySQL using SSIS?

I've downloaded an ADO.NET and ODBC connector from the MySQL website. I'd like to access a remote MySQL server from within BIDS with the goal of importing the remote data and populating a local SQL ...
0
votes
3answers
570 views

BIDS and SSIS projects on SQL Server 2005

I have trouble just getting started with BIDS, the development environment for creating SSIS packages in SQL Server 2005. I don't know if it is just a license / version issue or if i am missing some ...
0
votes
1answer
201 views

How to remove database backups 2 days or older through SQL Server 2005 Integration Service?

I have a simple Integration Service package which has one SQL Task as shown below; WLSTAGE Bakup using Red Gate: Calls master..sqlbackup to backup database Here is the SQL to run the actual backup ...