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

learn more… | top users | synonyms

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
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
5answers
439 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
857 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
2answers
972 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 ...
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
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 ...
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 ...
3
votes
4answers
2k 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 ...
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 ...
2
votes
3answers
7k 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 ...
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 ...