SQL Server Integration Services, used for data migration in and out of Microsoft SQL Server
2
votes
2answers
5k 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:
...
0
votes
1answer
1k 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 + ...
2
votes
3answers
15k 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 ...
0
votes
1answer
270 views
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}
> ...
3
votes
4answers
685 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, ...
0
votes
1answer
185 views
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 ...
0
votes
2answers
802 views
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 ...
2
votes
4answers
2k views
can SSIS connect to another sql server?
I'm a complete newbie and I'm just learning how to administrate SQL Server Integration Services (SSIS). I'm thinking of running SQL Server 2005 with SSIS install. Can an SSIS package run on a ...
1
vote
1answer
561 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 ...
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
1answer
371 views
Why is my SSIS configuration update not being saved?
I asked this over on SO with little success. I was wondering if any SF folks had some insight...
I have a SSIS 2005 package that is up and running in our production environment. The package uses an ...
