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

learn more… | top users | synonyms

1
vote
1answer
26 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 ...
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: ...
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 + ...
3
votes
3answers
18k 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
281 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
855 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
203 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
971 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
599 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
397 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 ...